TNS path change

[Jim123]

Hi,

I'm using PL/SQL 7.1.5.1398. My TNS file is place in "C:\Program Files\Common Files\Oracle\NETWORK\ADMIN". But I dont have write access in this location. I need to add more TNS entries and place it to a different location(Say D:\TNS.ora) and I want my PL/SQL developer to point to this new location.

I request you to please guide me how to do this? Thanks.

Jim.

 

[Marco Kalter]

You will need to define TNS_ADMIN, which is the directory where the tnsnames.ora and sqlnet.ora file are searched by the Oracle client. You can either define it in the registry for a specific Oracle Home (HKEY_LOCAL_MACHINE\Software\Oracle\Key_\TNS_ADMIN) or as an environment variable for all Oracle Homes.

 

[Jim123]

Thanks Marco. I don't have admin rights. Is it possible to solve the issue?

Rgds,
Jim

 

[Marco Kalter]

You don't need admin rights to set a user environment variable. You can even set it from a script:

set tns_admin=<directory>
"C:\Program Files\PLSQL Developer\plsqldev.exe"

 

[DoNotPanic]

Hi,
I have the same problem with tnsnames.ora.
I do not have a permitions for changing default folder for TNS.
So, i used your advise. I changed TNS_ADMI directory.
SQL Developer found my TNS file, but PL/SQL developer did not change TNS path.
Reboot does not help
Please advice.

 

[Marco Kalter]

How exactly did you change your TNS_ADMIN directory?

 

[DoNotPanic]

It really works. Thx
I used PL/SQL developer from remote PC.
So, it was updated only after parent PC's reboot.