TNS_ADMIN set correctly but red "x"

Toad for Oracle
1

I have set TNS_ADMIN environment variable to my user network drive but when I start Toad for Oracle 12.8.0.49 I only see red "X". Why?

See default installation without TNS_ADMIN set:

1_ToadDefaultWithoutTNS_ADMIN.png
1_ToadDefaultWithoutTNS_ADMIN.png1194×671 25.8 KB

  1. Defining TNS_ADMIN

2_UserEnv_tnsnames.png

  1. File is there

3_File_tnsnames.png

  1. Restart Toad with set TNS_ADMIN but now I have red X

4_ToadDefaultWithoutTNS_ADMIN.png
4_ToadDefaultWithoutTNS_ADMIN.png705×560 15.7 KB

What is wrong? What can I do?

2

Did you reboot your computer after setting up the env variable? That may help. I know personally, mine is setup as a system variable, but I don’t think that would matter, but may be worth a try. Also, just as a test you could point the variable to a local c drive folder that contains the tnsnames file and see if that works. If it does, then it’s most likely having a problem communicating with your network drive (just a guess).

3

TNS_ADMIN should point to the folder containing your net configuration files, not to an actual filename itself.

Michael

4

Thanks a lot Michael. That was the reason. Unbelievable that I have forgotten it. :wink: