ORACLE_HOME more directories

[Rob van Buiten]

Hi,

We installed Oracle and the default for ORACLE_home=/oracle.

We also want to install the Oracle Enterprise Manager in a special filemount called /OEM. But during install at the end by making the repository DB it refers to the ORACLE_home=/oracle.

Is it possible to set ORACLE_HOME to /oracle and /OEM ???

thanks,
Ron

[Robert-Jan Goossens]

Hi Ron,

ORACLE_HOME=/app/soracle/product/8.1.7
ORACLE_HOME=/app/poracle/product/8.1.6

I use multiple oracle versions and users on our system, ORACLE_HOME are set in $HOME/.profile of the oracle users.

Hope this helps,
Robert-Jan

[Victor Fridyev]

Ron,

You can have as many ORACLE_HOMEs and Oracle version as you need. In order to implement this, print
export ORACLE_HOME=WHATEVER-YOU-NEED
before each Oracle installation.
In order to use differnt version in applications, you have to set appropriate ORACLE_HOME, include ORACLE_HOME/bin into PATH and ORACLE_HOME/lib into SHLIB_PATH

[Yogeeraj_1]

hi ron,

you can export the ORACLE_HOME each time you have to setup the environment variables for each cases.


regards
Yogeeraj

[Eric Antunes]

No! You must have only 1 ORACLE_HOME for each user! If you want to use several version, Y'll need several unix users!!

I think that during OEM installation, you're only asked to give the current user's ORACLE_HOME, you're not asked to change it.

[Stephen Badgett]

Hi Ron,

I would think you could write a small script to set (export) the ORACLE_HOME environment variable if a user needs to use a different version without having to login as a new user. The script will have to be sourced i.e. ---> . oracle_v_1

Steve

[Geoff Wild]

Another way - have 2 different oracle id's with their own ORACLE_HOME:

have an oracle userid and an oem userid.

Make them belong to same group - say dba

Rgds...Geoff