Service Mapping to an Oracle Database with only the SID

[Patrick Oudshoo]

Hi all,

In my TomCat Service Mapping map, I find a reference to an Oracle database in the following format:

url="jdbc:oracle:thin:@x0ipatrick01"

From what I understand from here java - Accessing oracle database via SID through JDBC without host:port - Stack Overflow is this an Oracle connection purely based on a SID.

However, what Connection should I use in my pattern now to continue my mapping from here? The standard Oracle DB Endpoint connection is asking for Host, Port, Instance and Schema. I cannot find a connection that is based on just an Oracle SID.

Anyone who knows what Connection to use here?

Kind regards, Patrick

[Patrick Oudsho1]

While searching for answers, I did now find a reference to an Oracle home in the command line running the TomCat.

In this Oracle Home I found a TNSNames.ora in which I am able to find the SID and also the missing info about host and port. That is what I am using now to create my Oracle RAC connection and it works!