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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

2,891 views