TNSPING and SQLPlus works but not Able to connect SQL Developer

advertisements

_____________________________________________________________________________________________________________________

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.

_____________________________________________________________________________________________________________________

Website Stats