Probelms with PLSQL developer installation (tns names)

zbastos

Member
Hi all,

I'm trying to install a PL/SQL Developer version 14.0.6.1988 (64bit) on a Windows 10 Pro PC.
I've downloaded and unzipped Oracle Instant Client 21.3 Basic Package
Under the same directory I've create the network/admin/tnsnames.ora files and I've added the directory to the corresponding environment variables (Path the path where oci.dll is located "C:\instantclient_21_3" and TNS_ADMIN where .ora files are located "C:\instantclient_21_3\network\admin")
But PL/SQL Developer doesn't seems to detect the tnsnames.ora files as in PLSQL Developer Support Info -> Info -> DLLs and TNS File are empty. Tab TNS Names also empty
Really don't know what I can do.

Thanks in advance
 
It seems that PL/SQL Developer does not see the environment variables that you created. Perhaps you can reboot the PC, start a Windows Command Prompt, and enter the following?

type "%TNS_ADMIN%\tnsnames.ora"

Let me know if this displays the tnsnames.ora file contents.

If this works correctly, start PL/SQL Developer without connecting, go to Preferences > Oracle / Connection, select the oci.dll file for the "OCI LIbrary" field, restart PL/SQL Developer, and try again.
 
It displayed the path correctly

So I put manually the configurations for the connections like you said, and it worked
Thanks
 
Back
Top