Crs Stat Script To Display Full Resource Name
$ cat /sbin/crs_stat RSC_KEY=$1 #QSTAT=-u AWK=/usr/bin/awk # if not available use /usr/bin/awk #support -t -v -p if [ "$1" == "-t" ] ; then if [ "$2" == "-v" -o "$2" == "-q" -o "$3" == "-v" -o "$3" == "-q" ] ; then $ORA_CRS_HOME/bin/crs_stat $* exit fi shift RSC_KEY= # Table header:echo "" $AWK \ 'BEGIN {printf "%-45s %-10s %-18s\n", "HA Resource", "Target", "State"; printf "%-45s %-10s %-18s\n", "-----------", "------", "-----";}' # Table body: $ORA_CRS_HOME/bin/crs_stat $QSTAT $* | $AWK \ 'BEGIN { FS="="; state = 0; } $1~/NAME/ && $2~/'$RSC_KEY'/ {appname = $2; state=1}; state == 0 {next;} $1~/TARGET/ && state == 1 {apptarget = $2; state=2;} $1~/STATE/ && state == 2 {appstate = $2; state=3;} state == 3 {printf "%-45s %-10s %-18s\n", appname, apptarget, appstate; state=0;}' elif [ "$2" == "-t" ] ; then if [ "$3" == "-v" -o "$4" == "-q" -o "$3" == "-v" -o "$4" == "-q" ] ; then $ORA_CRS_HOME/bin/crs_stat $* exit fi shift 2 # Table header:echo "" $AWK \ 'BEGIN {printf "%-45s %-10s %-18s\n", "HA Resource", "Target", "State"; printf "%-45s %-10s %-18s\n", "-----------", "------", "-----";}' # Table body: $ORA_CRS_HOME/bin/crs_stat $QSTAT $* | $AWK \ 'BEGIN { FS="="; state = 0; } $1~/NAME/ && $2~/'$RSC_KEY'/ {appname = $2; state=1}; state == 0 {next;} $1~/TARGET/ && state == 1 {apptarget = $2; state=2;} $1~/STATE/ && state == 2 {appstate = $2; state=3;} state == 3 {printf "%-45s %-10s %-18s\n", appname, apptarget, appstate; state=0;}' else $ORA_CRS_HOME/bin/crs_stat $* fi
example:
/sbin/crs_stat -t
HA Resource Target State
----------- ------ -----
ora.t.db ONLINE ONLINE on t01
ora.t.t1.inst ONLINE ONLINE on t01
ora.t.t2.inst ONLINE ONLINE on t02
ora.t01.ASM1.asm ONLINE ONLINE on t01
ora.t01.LISTENER_T01.lsnr ONLINE ONLINE on t01
ora.t01.gsd ONLINE ONLINE on t01
ora.t01.ons ONLINE ONLINE on t01
ora.t01.vip ONLINE ONLINE on t01
ora.t02.ASM2.asm ONLINE ONLINE on t02
ora.t02.LISTENER_T02.lsnr ONLINE ONLINE on t02
ora.t02.gsd ONLINE ONLINE on t02
ora.t02.ons ONLINE ONLINE on t02
ora.t02.vip ONLINE ONLINE on t02