multiple ORACLE_HOMES under 8i ?

From: <hrkyemba_at_ingr.com>
Date: Thu, 23 Sep 1999 19:48:52 GMT
Message-ID: <7se06v$mg3$1@nnrp1.deja.com>

I just installed Oracle 8i on NT. Oracle8i requires that the enterprise manager (OEM) be installed in a spearate ORACLE_HOME than the server. OEM installs some of the Net8 stuff, and it has its own tnsnames.ora file. Our in-house app (written in OCI8) appears to be reading the tnsnames.ora file under the OEM directory. I don't know why it is selecting that tnsnames.ora file.

I looked at the Oracle docs, and they only say that you should set your path environment variable so that the preferred ORACLE_HOME/bin directory is first. I looked in Oracle's docs on the registry, but they don't say that you can specify the preferred ORACLE_HOME through the registry.

TIA, Heather Kyemba

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Sep 23 1999 - 14:48:52 CDT