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

Question

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 now as best practice and for operational reasons.
But from SOAP UI Pro i dont see an option to enter&nbsp;Service Name in DB configurations, whereas SID is shown instead.
&nbsp;
Please advice the steps to achieve this.

rwilson352 · Accepted Answer

Further digging, I found this article: https://community.smartbear.com/t5/SoapUI-Pro/Connection-to-an-Oracle-database-without-CID-but-with/td-p/121201

The solution is to manually edit either the driver or the connection string. See the accepted answer in the linked article. I was able to achieve it.

terkon · Answer

Hi,
&nbsp;
I am using the same setup. I simply put the service name into the SID field - workes fine for me.
&nbsp;
With that I am using java class "ojdbc6.jar" in c:\&lt;yourInstallationFolder&gt;\ReadyAPI-2.7.0\bin\ext
Attached you'll find my settings. The "1" in the service name is for the cluster node I want to connect to. In a cluster environmend that is necessary to give.
&nbsp;
Hope this helps
Terkon
&nbsp;

nmrao · Answer

Try checking with sqlplus or other client software to connect to the db and see if that is working.

terkon · Answer

Ok, I think that was a step in the right direction. Unfortunately this Error (Ora-12505) can have quite a lot of reasons.
Isn't there a DB admin you can turn to?
&nbsp;
Check out this:
https://chartio.com/resources/tutorials/how-to-fix-ora-12505-tns-listener-does-not-currently-know-of-sid-given-in-connect-descriptor/
&nbsp;
Or maybe google some other sites with hints on that problem.
&nbsp;
What does the TNS look like, which you use for the DB developer? And how the connection string in that tool?
Are you working on a cluster environment or is it a single instance DB?
Maybe you have to adjust your connection string in SOAPui or adjust the TNS so they fit to each other
&nbsp;

tanyayatskovska · Answer

Thanks for your suggestion,&nbsp;Terkon!
&nbsp;
gmathai, were you able to resolve the issue?

gmathai · Answer

TanyaYatskovska&nbsp;/&nbsp;Terkon&nbsp;
After placing the ojdbc6.jar in the specified location, i am getting the attached error.

Forum Discussion

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

12 Replies

Related Content

How to identify your username

Unable to connect to Oracle database with service name (no SID)

How do i connect to a service with extension .svc??

Identifying Dynamic message window

Unable to use a service account to connect to GitHub

Recent Discussions

JDBC results are stored in the ReadyAPI project

Azure Git Integration?

How to run specific test case in particular environment?

How to remove (not clear) test case properties from SaveScript

Parameterising JDBC Connection Settings..Can you do it?