problem in tnsnames.ora [message #67597] |
Mon, 08 November 2004 23:32 |
panna desai
Messages: 2 Registered: November 2004
|
Junior Member |
|
|
how the "tnsnames.ora" file on all client(windows xp) machines can be updated automatically whenever something changed on central 'tnsnames.ora'?
i am using 9i(2)
please reply me on pannavipool@yahoo.com
yr suggestions is highly appericiat...
regards
Panna
|
|
|
Re: problem in tnsnames.ora [message #67598 is a reply to message #67597] |
Tue, 09 November 2004 07:43 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
Place the common TNSNAMES.ORA file onto a shared drive.
Each client PC must be able to access this shared drive.
Define the TNS_ADMIN environment variable on each client PC to the shared drive where the TNSNAMES.ORA file is located.
or
use IFILE option
|
|
|