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.

SQL developer cannot see connection info from tnsnames.ora file

913701Jan 27 2012 — edited Jan 27 2012

Greetings All,

I have been using sql developer for a while. Currently on 3.0.04.34.

I have 16 database connections.

Everything was working fine until yesterday.

Today when I tried to connect to a database from the list of connections I am getting following error:
Invalid connection information specified. Verify url format for specified driver.

When I pull up the property for this connection -connection type is still TNS, Netwrok Alias is now greyed out and what was in Netwrok Alias has shifted to Connect Identifier.

When I try to create a new connection I do not see entry from tnsnames.ora file for the databse I am trying to connect to in the Network Alias drop down list.

I can connect to this database from sqlplus.

Has anyone seen this behavior? Does any one know the fix for this?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 24 2012

Added on Jan 27 2012

#sql-developer

1 comment

16,159 views