New Post has been published on Varinder Sandhu 's Blog
New Post has been published on http://www.varindersandhu.in/2013/05/16/toad-sqlnet-editor-and-tns-names-editor-disabled/
Toad - SQLNET Editor and TNS Names Editor Disabled
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
Issue 1: SQLNET Editor and TNS Names Editor Disabled as shown in below snapshot
<!-- google_ad_client = "pub-2404605494811633"; google_alternate_color = "FFFFFF"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_link = "0000FF"; google_color_bg = "FFFFFF"; google_color_text = "000000"; google_color_url = "008000"; google_ui_features = "rc:6"; //-->
Issue 2: Not able to find the TNS Name in the dropdown as shown in below snapshot
Cause: TNS entry missing in the environmental variables
Resolution: Go to environmental variables and create a new variable Name as “TNS_ADMIN” and set the value as Oracle Home\NETWORK\ADMIN (as shown in below screen shot )
That’s all, now you will able to connect to a Database using Toad with TNS.