SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TNSNAMES (SERVICE_NAME) Vs (SID) connections issues

TrottyMar 1 2012 — edited Mar 2 2012

I have just found that when attempting to connect to a DB that has been set up in our central TNSNAME.ora file with a SERVICE_NAME entry i cannot connect and get the following message 'Status : Failure -Test failed: The Network Adapter could not establish the connection'

However if the TNS entry is changed to use SID the connection works

Why is this as both work if i use SQL/Plus ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 30 2012

Added on Mar 1 2012

#sql-developer

8 comments

3,081 views