TNSPING and SQLPlus works but not Able to connect SQL Developer

Error description:

TNSPING and SQLPlus is working perfectly but when I try to connect through SQL developer it is giving error.

Solution description
You will have to set the tnsnames.ora location in the SQL developer configuration


How to Set it?
Goto Tools -> Preference menu
Expand the database Menu
Click on advanced and set correct value for the TNSnames Directory text box.

Example: C:\Oracle\network\admin

Also check the Use Oracle Client.


The above steps will make the SQL Developer works with TNS.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google