Topic Options
#44577 - 09/17/12 09:35 AM TNS path change
Jim123 Offline
Member

Registered: 09/17/12
Posts: 2
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.

Top
#44578 - 09/17/12 09:54 AM Re: TNS path change [Re: Jim123]
Marco Kalter Administrator Offline
Member

Registered: 08/30/99
Posts: 17141
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.
_________________________
Marco Kalter
Allround Automations

Top
#44604 - 09/21/12 02:38 AM Re: TNS path change [Re: Marco Kalter]
Jim123 Offline
Member

Registered: 09/17/12
Posts: 2
Thanks Marco. I don't have admin rights. Is it possible to solve the issue?

Rgds,
Jim

Top
#44610 - 09/21/12 05:26 AM Re: TNS path change [Re: Jim123]
Marco Kalter Administrator Offline
Member

Registered: 08/30/99
Posts: 17141
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"
_________________________
Marco Kalter
Allround Automations

Top


Moderator:  support