Re: ORACLE_HOME
From: Bill Ferguson <wbfergus_at_gmail.com>
Date: Tue, 19 Jan 2010 06:21:14 -0700
Message-ID: <4025610e1001190521u626ed960r81b37d5d01b6a282_at_mail.gmail.com>
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.
Date: Tue, 19 Jan 2010 06:21:14 -0700
Message-ID: <4025610e1001190521u626ed960r81b37d5d01b6a282_at_mail.gmail.com>
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 <wellmetus_at_gmail.com> wrote:Received on Tue Jan 19 2010 - 07:21:14 CST
> 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 :)
-- http://www.freelists.org/webpage/oracle-l