Forum Discussion

gmathai's avatar
gmathai
Occasional Contributor
6 years ago

How to connect to an Oracle Thin DB which is identified by 'Service Name' instead of SID

There is a requirement for me to connect to an Oracle thin DB which is identified by 'Service Name' instead of SID. Our DBA advised that SID is a thing of the past and they’re using Service Name no...
OracleThinDB
ServiceName vs SID
ServiceNameVsSID
SoapUI
rwilson352's avatar
rwilson352
Occasional Contributor

To be clearer: the change that needs to be made is that ReadyAPI needs to allow connection strings to be in the following format:

 

jdbc:oracle:thin:user/PASS_VALUE@xyz.int.com:1521/DBSCHEMA

currently, it only allows this (as far as I can tell):

jdbc:oracle:thin:user/PASS_VALUE@xyz.int.com:1521:DBSCHEMA

The difference: the Service Name takes a / between it and the port, not a :

 

Another related SO Q&A:

https://stackoverflow.com/questions/18192521/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript

 

  • sonya_m's avatar
    sonya_m
    SmartBear Alumni (Retired)
    5 years ago

    Hi rwilson352,  thank you for digging into this and sharing the solution with us.

  • Terkon's avatar
    Terkon
    Contributor
    5 years ago

    Hi,

     

    we are also using service name in our TNS files.

    In the SOAPui environment config I just entered the service name in the SID field and it works.

     

    Rg

    Terkon