查看crs状态
[oracle@RAC3 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM.lsnr ora....er.type ONLINE ONLINE rac1
ora.DATA.dg ora....up.type ONLINE ONLINE rac1
ora....ER.lsnr ora....er.type ONLINE ONLINE rac1
ora....AF.lsnr ora....er.type OFFLINE OFFLINE
ora....N1.lsnr ora....er.type ONLINE ONLINE rac2
ora....N2.lsnr ora....er.type ONLINE ONLINE rac3
ora....N3.lsnr ora....er.type ONLINE ONLINE rac1
ora.MGMTLSNR ora....nr.type ONLINE ONLINE rac1
ora.asm ora.asm.type ONLINE ONLINE rac1
ora.cvu ora.cvu.type ONLINE ONLINE rac1
ora.gns ora.gns.type ONLINE ONLINE rac1
ora.gns.vip ora....ip.type ONLINE ONLINE rac1
ora.mgmtdb ora....db.type ONLINE ONLINE rac1
ora....network ora....rk.type ONLINE ONLINE rac1
ora.oc4j ora.oc4j.type ONLINE ONLINE rac1
ora.ons ora.ons.type ONLINE ONLINE rac1
ora.proxy_advm ora....vm.type ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip ora....t1.type ONLINE ONLINE rac1
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip ora....t1.type ONLINE ONLINE rac2
ora....C3.lsnr application ONLINE ONLINE rac3
ora.rac3.ons application ONLINE ONLINE rac3
ora.rac3.vip ora....t1.type ONLINE ONLINE rac3
ora.scan1.vip ora....ip.type ONLINE ONLINE rac2
ora.scan2.vip ora....ip.type ONLINE ONLINE rac3
ora.scan3.vip ora....ip.type ONLINE ONLINE rac1
Name和Type两列总是显示不全,让人只能了解的信息有所限制,这个让人很恼火。。
无意中在一个大仙的博文上看到了个脚本,可以解决这一问题,所有就抄袭下来了,此文章随标有原创的标题,但是此处注明,这个脚本是从别处贴过来的,用由于时间久远了,所有现在也不知的出处了,只是向和这个脚本的创造这一样,将这个脚本分享给大家而已,内容如下:
[oracle@RAC3 ~]$ cat crsstatus.sh
RSC_KEY=$1
QSTAT=-u
AWK=/usr/bin/awk # if not available use /usr/bin/awk
#
$AWK \
'BEGIN {printf "%-45s %-10s %-18s\n", " Resource name", "Target", "State";
printf "%-45s %-10s %-18s\n", "--------------", "------", "-----";}'
$ORACLE_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;}'
此脚本的显示效果如下
[oracle@RAC3 ~]$ sh crsstatus.sh
Resource name Target State
-------------- ------ -----
ora.ASMNET1LSNR_ASM.lsnr ONLINE ONLINE on rac1
ora.DATA.dg ONLINE ONLINE on rac1
ora.LISTENER.lsnr ONLINE ONLINE on rac1
ora.LISTENER_LEAF.lsnr OFFLINE OFFLINE
ora.LISTENER_SCAN1.lsnr ONLINE ONLINE on rac2
ora.LISTENER_SCAN2.lsnr ONLINE ONLINE on rac3
ora.LISTENER_SCAN3.lsnr ONLINE ONLINE on rac1
ora.MGMTLSNR ONLINE ONLINE on rac1
ora.asm ONLINE ONLINE on rac1
ora.cvu ONLINE ONLINE on rac1
ora.gns ONLINE ONLINE on rac1
ora.gns.vip ONLINE ONLINE on rac1
ora.mgmtdb ONLINE ONLINE on rac1
ora.net1.network ONLINE ONLINE on rac1
ora.oc4j ONLINE ONLINE on rac1
ora.ons ONLINE ONLINE on rac1
ora.proxy_advm ONLINE ONLINE on rac1
ora.rac1.LISTENER_RAC1.lsnr ONLINE ONLINE on rac1
ora.rac1.ons ONLINE ONLINE on rac1
ora.rac1.vip ONLINE ONLINE on rac1
ora.rac2.LISTENER_RAC2.lsnr ONLINE ONLINE on rac2
ora.rac2.ons ONLINE ONLINE on rac2
ora.rac2.vip ONLINE ONLINE on rac2
ora.rac3.LISTENER_RAC3.lsnr ONLINE ONLINE on rac3
ora.rac3.ons ONLINE ONLINE on rac3
ora.rac3.vip ONLINE ONLINE on rac3
ora.scan1.vip ONLINE ONLINE on rac2
ora.scan2.vip ONLINE ONLINE on rac3
ora.scan3.vip ONLINE ONLINE on rac1