Posted By: Jim123 TNS path change - 09/17/12 01:35 PM
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.
Posted By: Marco Kalter Re: TNS path change - 09/17/12 01:54 PM
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_<HomeName>\TNS_ADMIN) or as an environment variable for all Oracle Homes.
Posted By: Jim123 Re: TNS path change - 09/21/12 06:38 AM
Thanks Marco. I don't have admin rights. Is it possible to solve the issue?

Rgds,
Jim
Posted By: Marco Kalter Re: TNS path change - 09/21/12 09:26 AM
You don't need admin rights to set a user environment variable. You can even set it from a script:

Code
set tns_admin=<directory>
"C:\Program Files\PLSQL Developer\plsqldev.exe"
Posted By: DoNotPanic Re: TNS path change - 05/27/15 10:52 AM
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 frown
Please advice.
Posted By: Marco Kalter Re: TNS path change - 05/28/15 09:55 AM
How exactly did you change your TNS_ADMIN directory?
Posted By: DoNotPanic Re: TNS path change - 05/28/15 02:05 PM
It really works. Thx smile
I used PL/SQL developer from remote PC.
So, it was updated only after parent PC's reboot.
© Allround Automations forums