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

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: tony@xxxxxxxxxxxxxxx
  • Date: Tue, 29 Jan 2008 11:46:06 -0800

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

Other related posts: