Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #umask 022
- PATH=$PATH:$HOME/bin
- # author Kosseila Hd
- # Oracle Settings for oracle user
- export TMP=/tmp
- export ORACLE_PATH=/home/oracle/scripts/eclipsys
- export TMPDIR=$TMP
- export ORACLE_HOSTNAME=$(hostname)
- #export ORACLE_UNQNAME=`awk -F: '/^[^#]/ { print $1 } ' /etc/oratab | uniq | grep -m -1 product`
- export ORACLE_BASE=/u01/app/oracle
- export ORACLE_HOME=`awk -F: '/^[^#]/ { print $2 } ' /etc/oratab | uniq | grep -m 1 product`
- #export ORACLE_SID=db12c
- export GRID_HOME=`awk -F: '/^[^#]/ && /^+ASM/ { print $2 }' /etc/oratab | uniq`
- export PATH=/usr/sbin:$PATH
- export PATH=$PATH:$ORACLE_HOME/bin
- export PATH=$PATH:$GRID_HOME/bin
- export PATH=/usr/sbin:$PATH
- export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
- export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
- # switch database
- echo Please Choose the DB or GRID HOME you wish to manage
- echo ' oratab source '
- awk -F: '/^[^#]/ { print " -- " $1 }' /etc/oratab | uniq
- echo ' current processes'
- ps -ef | awk '$8 ~ /_pmon_/ {print $8}'| cut -c 10-|sed -e 's/^/ -- /'
- read sid
- export ORACLE_SID=$sid
- if [[ "$sid" == *"+ASM"* ]];
- then export ORACLE_BASE=/u01/app/grid;
- export ORACLE_HOME=$GRID_HOME
- else
- v=`awk -F: '/^[^#]/ { print $1 } ' /etc/oratab | uniq | grep -m 1 $sid`
- if [[ "$sid" == "$v" ]];
- then export ORACLE_HOME=`awk -F: '/^[^#]/ { print } ' /etc/oratab |grep -m 1 $sid|awk -F: '{print $2}'`
- fi
- fi
- if [ ! -n "$GRID_HOME" ] ;
- then echo "==== There is no GRID installed in this server ===="
- else
- /home/oracle/scripts/eclipsys/check_crs.sh
- fi
- /home/oracle/scripts/eclipsys/rac_status.sh -e
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement