Re: 9i OEM standalone console, TNS_ADMIN and tnsnames.ora
Date: Tue, 29 Jan 2008 11:46:06 -0800
Message-ID: <bf46380801291146pcfd8501r9808c284408b429e@mail.gmail.com>
On Jan 16, 2008 5:39 AM, Tony Sequeira <tony_at_sequeira.org.uk> wrote:
> ...
> Is this a 9i problem? Anyone out there running a 9i client with an OEM
> Console using TNS_ADMIN?
>
>
Since this is windows, it is likely the environment, which is always a
challenge
with multiple versions of Oracle on one machine.
There is likely some interence in the PATH variable with other Oracle
versions,
and possibly CLASS_PATH as well.
Make sure that ORACLE_HOME is NOT set for the cmd environment.
Start up a command window.
If ORACLE_HOME is set, you need to unset it in My Computer->Properties>Advanced->Env Variables
There is a decent free tool for managing the environment for multiple Oracle
Homes on Windows:
http://www.dbmotive.com/ole/
HTH
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 29 2008 - 13:46:06 CST