From: Bill Ferguson <>
Date: Tue, 19 Jan 2010 06:21:14 -0700
Message-ID: <>

In this case, on Windows, set the system environment variable TNS_ADMIN to point to the location of the tnsnames.ora file you want to always use.

If this variable is set, this is the file that will always be used by Windows, regardless of the current PATH settings.

-- Bill Ferguson

On Mon, Jan 18, 2010 at 3:03 PM, Roger Xu <> wrote:

> In my case below, I just want to know which tnsnames.ora file I am using.
> There are many tnsnames.ora files in this server and I was able to try each
> to figure out the one I am using. But this is not the right way to get the
> answer ... (I feel home when running Oracle in UNIX :)
Received on Tue Jan 19 2010 - 07:21:14 CST

Original text of this message