多实例环境中.profile示例

 
vi ~/.bash_profile
 
ORACLE_BASE=/u01/oracle
export ORACLE_BASE
resize
clear
echo "------ ORACLE Selection ---------"
echo "1. ora10g"
echo "2. ora11g"
echo "-----------------------------------"
echo "Your choice: (default 1)\c"
read sid
case $sid in
        1) ORACLE_SID=ora10g
           ORACLE_HOME=/u01/oracle/ora10g
           export DBCA_RAW_CONFIG=/home/oracle/ora10g_raw.conf
        ;;
        2) ORACLE_SID=ora11g
           ORACLE_HOME=/u01/oracle/ora11g
        ;;
        *) ORACLE_SID=ora10g
           ORACLE_HOME=/u01/oracle/ora10g
           export DBCA_RAW_CONFIG=/home/oracle/ora10g_raw.conf       
        ;;
esac
export ORACLE_SID
export ORACLE_HOME
export PS1=$(hostname)\($ORACLE_SID\):$LOGNAME:'$PWD>'
TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export NLS_LANG
PATH=$ORACLE_HOME/bin:/bin:/sbin:/usr/ccs/bin:/usr/local/bin:$PATH
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib:/usr/local/lib:/usr/lib
export LD_LIBRARY_PATH
umask 022