Exadata Software - Oracle Exadata Recipes: A Problem-Solution Approach - page 38

--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA_CM01.dg
ONLINE ONLINE cm01dbm01
ONLINE ONLINE cm01dbm02
ora.DBFS_DG.dg
ONLINE ONLINE cm01dbm01
ONLINE ONLINE cm01dbm02
ora.LISTENER.lsnr
ONLINE ONLINE cm01dbm01
ONLINE ONLINE cm01dbm02
... Addtional cluster resources omitted
We have abbreviated the previous output for sake of brevity, but if we format the output of crsctl using the
following program, we can get an easy-to-read listing of our cluster resources, as displayed in Listing 2-2.
Listing 2-2. lst02-02-crsstat.sh
[grid@cm01dbm01 ~]$ cat /tmp/crsstat
#!/usr/bin/ksh
ORA_CRS_HOME=/u01/app/11.2.0.3/grid
RSC_KEY=$1
QSTAT=−u
AWK=/bin/awk # if not available use /usr/bin/awk
# 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;}'
[grid@cm01dbm01 ~]$ crsstat
HA Resource Target State
----------- ------ -----
ora.DATA_CM01.dg ONLINE ONLINE on cm01dbm01
ora.DBFS_DG.dg ONLINE ONLINE on cm01dbm01
ora.LISTENER.lsnr ONLINE ONLINE on cm01dbm01
ora.LISTENER_SCAN1.lsnr ONLINE ONLINE on cm01dbm02
ora.LISTENER_SCAN2.lsnr ONLINE ONLINE on cm01dbm01
... Additional output omitted
[grid@cm01dbm01 ~]$