Re: 9i OEM standalone console, TNS_ADMIN and tnsnames.ora
Date: Tue, 29 Jan 2008 11:46:06 -0800
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
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 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 29 2008 - 13:46:06 CST