crs_stat的显示格式问题

最新推荐文章于 2021-08-28 17:45:22 发布

congzhi9734

最新推荐文章于 2021-08-28 17:45:22 发布

阅读量171

点赞数

10g和11g cluster命令crs_stat的显示格式不全，看起来比较费劲，它的结果是这样的（11g）

#crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.CRS1.dg ora....up.type ONLINE ONLINE ora

ora.DATA.dg ora....up.type ONLINE ONLINE ora

ora....ER.lsnr ora....er.type ONLINE ONLINE ora

ora....N1.lsnr ora....er.type ONLINE ONLINE orb

ora.asm ora.asm.type ONLINE ONLINE ora

ora.cvu ora.cvu.type ONLINE ONLINE orb

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....network ora....rk.type ONLINE ONLINE orb

ora.oc4j ora.oc4j.type ONLINE ONLINE ora

ora.ons ora.ons.type ONLINE ONLINE orb

ora....SM1.asm application ONLINE ONLINE ora

ora....RA.lsnr application ONLINE ONLINE ora

ora.ora.gsd application OFFLINE OFFLINE

ora.ora.ons application ONLINE OFFLINE

ora.ora.vip ora....t1.type ONLINE ONLINE ora

ora....SM2.asm application ONLINE ONLINE orb

ora....RB.lsnr application ONLINE ONLINE orb

ora.orb.gsd application OFFLINE OFFLINE

ora.orb.ons application ONLINE ONLINE orb

ora.orb.vip ora....t1.type ONLINE ONLINE orb

ora.orcl.db ora....se.type ONLINE ONLINE ora

ora.scan1.vip ora....ip.type ONLINE ONLINE orb

参考了一下别人的文档，针对10g和11g都做了些小小的修改，用grid用户，加了一个crs_stat.sh可执行文件

vi $ORACLE_HOME/bin/crs_stat.sh

##10g上使用

awk 'BEGIN {printf "%-30s %-10s %-10s %-10s \n","Name ","Target ","State ","Host "; printf "%-30s %-10s %-10s %-10s\n","------------------------------","----------", "---------","-------";}'

crs_stat | awk 'BEGIN { FS="=| ";state = 0;} $1~/NAME/ {appname = $2; state=1}; state == 0 {next;} $1~/TARGET/ && state == 1 {apptarget = $2; state=2;} $1~/STATE/ && state == 2 {appstate = $2; apphost = $4; state=3;} state == 3 {printf "%-30s %-10s %-10s %-10s\n", appname,apptarget,appstate,apphost; state=0;}'

##11g 上使用

awk 'BEGIN {printf "%-30s %-26s %-10s %-10s %-10s \n","Name ","Type ","Target ","State ","Host "; printf "%-30s %-26s %-10s %-10s %-10s\n","-----------------------------------","--------------------------","----------", "---------","-------";}'

crs_stat | awk 'BEGIN { FS="=| ";state = 0;} $1~/NAME/ {appname = $2; state=1}; state == 0 {next;} $1~/TYPE/ && state == 1 {apptype = $2; state=2;} $1~/TARGET/ && state == 2 {apptarget = $2; state=3;} $1~/STATE/ && state == 3 {appstate = $2; apphost = $4; state=4;} state == 4 {printf "%-30s %-26s %-10s %-10s %-10s\n", appname,apptype,apptarget,appstate,apphost; state=0;}'

注意上面是两条命令

给这个文件加执行权限

chmod a+x $ORACLE_HOME/bin/crs_stat.sh

执行后结果是这样子的（11g）

Name Type Target State Host

----------------------------------- -------------------------- ---------- --------- -------

ora.CRS1.dg ora.diskgroup.type ONLINE ONLINE ora

ora.DATA.dg ora.diskgroup.type ONLINE ONLINE ora

ora.LISTENER.lsnr ora.listener.type ONLINE ONLINE ora

ora.LISTENER_SCAN1.lsnr ora.scan_listener.type ONLINE ONLINE orb

ora.asm ora.asm.type ONLINE ONLINE ora

ora.cvu ora.cvu.type ONLINE ONLINE orb