Re: 9i OEM standalone console, TNS_ADMIN and tnsnames.ora

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-l