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

From: Jared Still <>
Date: Tue, 29 Jan 2008 11:46:06 -0800
Message-ID: <>

On Jan 16, 2008 5:39 AM, Tony Sequeira <> 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:


Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Received on Tue Jan 29 2008 - 13:46:06 CST

Original text of this message