You can set the TNS_ADMIN environment variable to point every application on the machine at a single tnsnames.ora file (generally because you have multiple Oracle Homes). You can also override the system's tnsnames.ora file by putting a tnsnames.ora file in the application directory.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: Andres Martin [mailto:oracledba-ezmlmshield-x94986603.[Email address protected]
Sent: Thursday, June 02, 2005 11:30 AM
To: LazyDBA Discussion
Subject: Specify diferent tnsnames.ora

Hello,

I have an application that runs his own tnsnames file and I want to
force the system to use a different one. There's any way in
windows/MSDOS console to force the system to use my tnsnames.ora?

thank you


--
Un saludo

Andrés Martín
Dpt. Informática



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page