switch between oracle versions

I've installed two different versions of oracle database (10.2.0.1 and 11.2.0.1) on the SLES11.1 X64. 

oracle 10g is set to be the default version in /etc/profile.oracle.sh. I want to switch between these two versions. So I've made this script. to be called during the login process.

oracle@orcl10g:~> cat /etc/oratab

orcl10g:/app/oracle/product/10.2.0/db_1:N

orcl11g:/app/oracle/product/11.2.0/db_1:N

oracle@orcl10g:~> cat .profile

#!/bin/bash

export ORAENV_ASK=YES

. /usr/local/bin/oraenv

if [ $ORACLE_SID == 'orcl11g' ];then

  export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib

  export TNS_ADMIN=$ORACLE_HOME/network/admin

  export PATH=/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/sbin:$ORACLE_HOME/bin

  export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

else

  source /etc/profile.d/oracle.sh

fi
export ORACLE_PATH=/home/oracle/scripts

export SQLPATH=/home/oracle/scripts

 

 

v2:

oracle@orcl10g:~> cat .profile

#!/bin/bash
export ORAENV_ASK=YES
. /usr/local/bin/oraenv
ORACLE_SID=`echo $ORACLE_SID|tr '[:lower:]' '[:upper:]'`
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib
export PATH=/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/sbin:$ORACLE_HOME/bin
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib
export ORA_NLS10=$ORACLE_HOME/nls/data

export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORACLE_PATH=/home/oracle/scripts
export SQLPATH=/home/oracle/scripts

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7314577/viewspace-735119/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7314577/viewspace-735119/