oracle切换instance,如何指定Oracle instance在多instance db 环境

<9.2.0:rephd:>cat jumpto

#! /bin/ksh

#

typeset -u x=$1

#

#  Edit SID list using /etc/oratab file entries

#

passedit=N

#

lowerx=`echo $x | tr '[A-Z]' '[a-z]'`

sidlist=`grep -v '#' /etc/oratab | grep ':/' | cut -d: -f1 | tr '[a-z]' '[A-Z]'`

for sid in $sidlist

do

if [[ $sid = $x ]];

then

passedit=Y

fi

done

if [[ $passedit = N ]];

then

echo "Illegal ORACLE_SID parameter"

echo "Choose from:"

echo $sidlist

else

ORACLE_SID=$lowerx; export ORACLE_SID

DATAGUARD_ID=$ORACLE_SID; export DATAGUARD_ID

ORAENV_ASK=NO

. /usr/local/bin/oraenv

VERSION=`echo $ORACLE_HOME | cut -d/ -f 5`

HOST=`hostname`

HOSTNAME=`basename $HOST .vcd.hp.com`

fi

#

export LD_LIBRARY_PATH=$ORACLE_HOME/lib64

export SHLIB_PATH=$ORACLE_HOME/lib

PS1="\"

9.2.0:rephd:>

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