Forum Discussion

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...

rwilson352
5 years ago
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.

TanyaYatskovska

SmartBear Alumni (Retired)

6 years ago

Thanks for your suggestion, Terkon!

gmathai, were you able to resolve the issue?

gmathai
Occasional Contributor
6 years ago
TanyaYatskovska / Terkon

After placing the ojdbc6.jar in the specified location, i am getting the attached error.
- nmrao
  Champion Level 3
  6 years ago
  Try checking with sqlplus or other client software to connect to the db and see if that is working.
  - gmathai
    Occasional Contributor
    6 years ago
    nmrao We are able to connect to this DB using Oracle SQL developer. Issue faced from SOAPUI though.
- Terkon
  Contributor
  6 years ago
  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?
  
  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/
  
  Or maybe google some other sites with hints on that problem.
  
  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
  - TanyaYatskovska
    SmartBear Alumni (Retired)
    6 years ago
    Thanks for your help, Community!
    
    gmathai, have you managed to find a solution. Please share it with us - it may help someone else.