crs_stat信息显示全问题的解决

来源：互联网发布：大数据算法聚类编辑：程序博客网时间：2024/05/08 15:41

查看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