Toad World® Forums

TNS_ADMIN set correctly but red "x"


#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. 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

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: