Re: Several oracle instances

Just set the correct PATH for each user, for example:

User1:

ORACLE_HOME=/u01/app/oracle/product/9.2.0

PATH=${PATH}:/usr/sbin:$ORACLE_HOME/dbs

PATH=$ORACLE_HOME/bin:$PATH

ORAENV_ASK=NO LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/dt/lib:/usr/lib

SHLIB_PATH=$ORACLE_HOME/lib:/usr/lib

ORACLE_SID=USR1SID export ORACLE_SID ORACLE_BASE ORACLE_HOME ORAENV_ASK PATH

export LD_LIBRARY_PATH SHLIB_PATH

User2:

ORACLE_HOME=/u01/app/oracle/product/8.1.7

PATH=${PATH}:/usr/sbin:$ORACLE_HOME/dbs

PATH=$ORACLE_HOME/bin:$PATH

ORAENV_ASK=NO LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/dt/lib:/usr/lib

SHLIB_PATH=$ORACLE_HOME/lib:/usr/lib

ORACLE_SID=USR2SID export ORACLE_SID ORACLE_BASE ORACLE_HOME ORAENV_ASK PATH

export LD_LIBRARY_PATH SHLIB_PATH

:cool:

--
Posted via http://dbforums.com