Thursday, September 22, 2016

Toad – SQLNET Editor && TNS Names Editor are Disabled?

After successfully Installed the toad, while trying to connect to a Database using Toad with TNS, Even the TNS entry is created in tnsnames.ora file under Oracle Home\NETWORK\ADMIN Not able to connect the due to TNS Editor and SQLNET editors are disabled.

For Toad version 11.0 above need to install the oracle client 64 bit version .

Issue 1: SQLNET Editor and TNS Names Editor Disabled as shown in below pic.

And not able to find the TNS Name in the drop down as shown in below pic

Solution : Go to environmental variables and create a new variable Name as “TNS_ADMIN” and set the value as  Oracle Home\NETWORK\ADMIN.

5 comments:

Thanks for giving comments!!