Thursday 9 September 2010

SID

echo

echo "SIDs on this node:"

for i in `cat /etc/oratab|grep -v \#|grep -v \*|cut -d":" -f1`

#for i in `ps -ef | awk {'print $8'}|grep pmon | grep -v grep | cut -c 10-40`

do

echo ' '$i

done

ORACLE_SID=$i

#ORACLE_UNQNAME=`echo $ORACLE_SID | cut -c 1-6`

echo

ORAENV_ASK="YES"

. /usr/local/bin/oraenv

echo

echo ORACLE_SID=$ORACLE_SID

#echo ORACLE_UNQNAME=$ORACLE_UNQNAME

echo ORACLE_HOME=$ORACLE_HOME

echo

No comments: