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.
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.
simple, right to the point. very helpful. thanks Murthy!
ReplyDeleteGreat!it's work, thanks a lot
ReplyDeleteperfect! thank you
ReplyDeleteVery Good. Thanks a lot
ReplyDeleteThank you !
ReplyDelete