RE: windows question

Additional points. It will look in the current directory first, working directory.

Ie if you have an icon on your desk that executes out of c:\working, and you have six tnsnames.ora files laying around... one of them in c:\working, then your app will look there first and use c:\working\tnsnames.ora.

I believe you can set TNS_ADMIN through your environment variables also... but Brandon's advise is good advice.

Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Allen, Brandon Sent: Thursday, November 08, 2007 3:10 PM To: shrekdba_at_gmail.com; oracle-l
Subject: RE: windows question

Did you check for multiple tnsnames.ora files? You might have an old one laying around somewhere else that's getting used instead of the one you are editing. I forget exactly how it works, but I believe which tnsnames.ora gets used is based on where you run the binary from - there is an oracle.key file in the same directory that points to a Windows Registry key that then points to a TNS_ADMIN location, or something like that. You can find the specifics on Metalink.

Regards,
Brandon

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 08 2007 - 14:51:25 CST