{"id":22,"date":"2012-04-11T12:38:00","date_gmt":"2012-04-11T12:38:00","guid":{"rendered":"http:\/\/anjo.pt\/wp\/keyword-oracle\/2012\/04\/11\/crs_stat-and-oracle-cluster-resources-status\/"},"modified":"2015-11-17T20:27:24","modified_gmt":"2015-11-17T19:27:24","slug":"crs_stat-and-oracle-cluster-resources-status","status":"publish","type":"post","link":"https:\/\/anjo.pt\/keyword-oracle\/2012\/04\/11\/crs_stat-and-oracle-cluster-resources-status\/","title":{"rendered":"crs_stat and Oracle cluster resources status"},"content":{"rendered":"<p>One script output that Oracle to my knowledge did not improve yet was the &#8220;crs_stat -t&#8221;. On 11.2 there is the &#8220;<b>.\/crsctl status resource -t<\/b>&#8220;, but the output is quite long. <\/p>\n<p>The usual output is like this:<\/p>\n<pre>\nhqbuun415:\/oracle\/app\/product\/11.1\/crs\/bin:crs:$crs_stat -t\nName           Type           Target    State     Host\n------------------------------------------------------------\nora....ISP1.cs application    ONLINE    ONLINE    hqbuun415\nora....ss2.srv application    ONLINE    ONLINE    hqbuun415\nora....ISP2.cs application    ONLINE    ONLINE    hqbuun414\nora....ss1.srv application    ONLINE    ONLINE    hqbuun414\nora....OAFO.cs application    ONLINE    ONLINE    hqbuun414\nora....ss1.srv application    ONLINE    ONLINE    hqbuun414\nora....M3PL.cs application    ONLINE    ONLINE    hqbuun415\nora....ss2.srv application    ONLINE    ONLINE    hqbuun415\nora....MALF.cs application    ONLINE    ONLINE    hqbuun414\nora....ss1.srv application    ONLINE    ONLINE    hqbuun414\nora....MAVE.cs application    ONLINE    ONLINE    hqbuun415\nora....ss2.srv application    ONLINE    ONLINE    hqbuun415\nora....WMEA.cs application    ONLINE    ONLINE    hqbuun414\nora....ss1.srv application    ONLINE    ONLINE    hqbuun414\nora....WMSS.db application    ONLINE    ONLINE    hqbuun414\nora....s1.inst application    ONLINE    ONLINE    hqbuun414\nora....s2.inst application    ONLINE    ONLINE    hqbuun415\nora....SM1.asm application    ONLINE    ONLINE    hqbuun414\nora....14.lsnr application    ONLINE    ONLINE    hqbuun414\nora....414.gsd application    ONLINE    ONLINE    hqbuun414\nora....414.ons application    ONLINE    ONLINE    hqbuun414\nora....414.vip application    ONLINE    ONLINE    hqbuun414\nora....SM2.asm application    ONLINE    ONLINE    hqbuun415\nora....15.lsnr application    ONLINE    ONLINE    hqbuun415\nora....415.gsd application    ONLINE    ONLINE    hqbuun415\nora....415.ons application    ONLINE    ONLINE    hqbuun415\nora....415.vip application    ONLINE    ONLINE    hqbuun415\n<\/pre>\n<p>But on Metalink (My Oracle Support) note 259301.1 we can find the magic script (which works still with Oracle 11.2):<\/p>\n<pre>\n--------------------------- Begin Shell Script -------------------------------\n\n#!\/usr\/bin\/ksh\n#\n# Sample 10g CRS resource status query script\n#\n# Description:\n#    - Returns formatted version of crs_stat -t, in tabular\n#      format, with the complete rsc names and filtering keywords\n#   - The argument, $RSC_KEY, is optional and if passed to the script, will\n#     limit the output to HA resources whose names match $RSC_KEY.\n# Requirements:\n#   - $ORA_CRS_HOME should be set in your environment \n\nRSC_KEY=$1\nQSTAT=-u\nAWK=\/usr\/xpg4\/bin\/awk    # if not available use \/usr\/bin\/awk\n\n# Table header:echo \"\"\n$AWK \n  'BEGIN {printf \"%-45s %-10s %-18sn\", \"HA Resource\", \"Target\", \"State\";\n          printf \"%-45s %-10s %-18sn\", \"-----------\", \"------\", \"-----\";}'\n\n# Table body:\n$ORA_CRS_HOME\/bin\/crs_stat $QSTAT | $AWK \n 'BEGIN { FS=\"=\"; state = 0; }\n  $1~\/NAME\/ && $2~\/'$RSC_KEY'\/ {appname = $2; state=1};\n  state == 0 {next;}\n  $1~\/TARGET\/ && state == 1 {apptarget = $2; state=2;}\n  $1~\/STATE\/ && state == 2 {appstate = $2; state=3;}\n  state == 3 {printf \"%-45s %-10s %-18sn\", appname, apptarget, appstate; state=0;}'\n--------------------------- End Shell Script -------------------------------\n<\/pre>\n<p>This script makes a clear output as:<\/p>\n<pre>\nhqbuun414:\/oracle\/app\/product\/11.1\/crs\/bin:crs:$.\/crsstat\nHA Resource                                   Target     State\n-----------                                   ------     -----\nora.WMS01_WMSS.EISP1.cs                       ONLINE     ONLINE on hqbuun415\nora.WMS01_WMSS.EISP1.wmss2.srv                ONLINE     ONLINE on hqbuun415\nora.WMS01_WMSS.EISP2.cs                       ONLINE     ONLINE on hqbuun414\nora.WMS01_WMSS.EISP2.wmss1.srv                ONLINE     ONLINE on hqbuun414\nora.WMS01_WMSS.NESOAFO.cs                     ONLINE     ONLINE on hqbuun414\nora.WMS01_WMSS.NESOAFO.wmss1.srv              ONLINE     ONLINE on hqbuun414\nora.WMS01_WMSS.WM3PL.cs                       ONLINE     ONLINE on hqbuun415\nora.WMS01_WMSS.WM3PL.wmss2.srv                ONLINE     ONLINE on hqbuun415\nora.WMS01_WMSS.WMALF.cs                       ONLINE     ONLINE on hqbuun414\nora.WMS01_WMSS.WMALF.wmss1.srv                ONLINE     ONLINE on hqbuun414\nora.WMS01_WMSS.WMAVE.cs                       ONLINE     ONLINE on hqbuun415\nora.WMS01_WMSS.WMAVE.wmss2.srv                ONLINE     ONLINE on hqbuun415\nora.WMS01_WMSS.WMEA.cs                        ONLINE     ONLINE on hqbuun414\nora.WMS01_WMSS.WMEA.wmss1.srv                 ONLINE     ONLINE on hqbuun414\nora.WMS01_WMSS.db                             ONLINE     ONLINE on hqbuun414\nora.WMS01_WMSS.wmss1.inst                     ONLINE     ONLINE on hqbuun414\nora.WMS01_WMSS.wmss2.inst                     ONLINE     ONLINE on hqbuun415\nora.hqbuun414.ASM1.asm                        ONLINE     ONLINE on hqbuun414\nora.hqbuun414.LISTENER_HQBUUN414.lsnr         ONLINE     ONLINE on hqbuun414\nora.hqbuun414.gsd                             ONLINE     ONLINE on hqbuun414\nora.hqbuun414.ons                             ONLINE     ONLINE on hqbuun414\nora.hqbuun414.vip                             ONLINE     ONLINE on hqbuun414\nora.hqbuun415.ASM2.asm                        ONLINE     ONLINE on hqbuun415\nora.hqbuun415.LISTENER_HQBUUN415.lsnr         ONLINE     ONLINE on hqbuun415\nora.hqbuun415.gsd                             ONLINE     ONLINE on hqbuun415\nora.hqbuun415.ons                             ONLINE     ONLINE on hqbuun415\nora.hqbuun415.vip                             ONLINE     ONLINE on hqbuun415\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>One script output that Oracle to my knowledge did not improve yet was the &#8220;crs_stat -t&#8221;. On 11.2 there is the &#8220;.\/crsctl status resource -t&#8220;, but the output is quite long. The usual output is like this: hqbuun415:\/oracle\/app\/product\/11.1\/crs\/bin:crs:$crs_stat -t Name Type Target State Host &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; ora&#8230;.ISP1.cs application ONLINE ONLINE hqbuun415 ora&#8230;.ss2.srv application ONLINE ONLINE hqbuun415 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,15],"tags":[],"class_list":{"0":"post-22","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-oracle","7":"category-rac","8":"czr-hentry"},"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/22","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=22"}],"version-history":[{"count":1,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/22\/revisions"}],"predecessor-version":[{"id":166,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/22\/revisions\/166"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=22"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=22"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=22"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}