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

From: Tony Sequeira <>
Date: Tue, 29 Jan 2008 20:12:14 +0000
Message-Id: <1201637534.2767.19.camel@comet.sequestor.lan>

[Oops, send to list as well, for posterity]

On Tue, 2008-01-29 at 11:46 -0800, Jared Still wrote:
> 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.

Agreed :)

> There is likely some interence in the PATH variable with other Oracle

PATH starts with 11g\bin, then 10g\bin, then 9i\jre\1.4.2\bin (twice, I'll fix that), 9i\bin, Program Files\jre\1.3.1\bin and Program Files \jre\1.1.8\bin and the rest of the Win PATH

> versions,
> and possibly CLASS_PATH as well.

CLASS_PATH is not set in the environment.

> Make sure that ORACLE_HOME is NOT set for the cmd environment.

It's not.

> Start up a command window.
> If ORACLE_HOME is set, you need to unset it in My
> Computer->Properties>Advanced->Env Variables

There is something called WF_RESOURCES 9i\WF\RES\WFus.RES, I take it it's something to do with the Workflow Builder?

> There is a decent free tool for managing the environment for multiple
> Oracle Homes on Windows:

I will have a look at this thanks. Much obliged.

> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist

S. Anthony Sequeira
Talking much about oneself can also be a means to conceal oneself.
		-- Friedrich Nietzsche

Received on Tue Jan 29 2008 - 14:12:14 CST

Original text of this message