<\/p>\n
<\/p>\n
<\/p>\n
#!\/usr\/bin\/ksh
\n#This script gives crs status
\nif [[ `uname -s` = \u201cSunOS\u201d ]] ; then
\nAWK=\/usr\/bin\/nawk
\nelse
\nAWK=\/usr\/bin\/awk
\nfi<\/p>\n
function print_usage {
\necho \u201d \u201d
\necho \u201cUsage: crsstat [-h] [-c] [search term]\u201d
\necho \u201d \u201d
\necho \u201d -h => print this message\u201d
\necho \u201d -c => output the resources by cluster or local\u201d
\necho \u201d \u201d
\necho \u201d Examples:\u201d
\necho \u201d crsstat # show all resources\u201d
\necho \u201d crsstat listener # only show listener resources\u201d
\necho \u201d crsstat database # only show database resources\u201d
\necho \u201d crsstat -c listener # only show database resources sorted by cluster\/local\u201d
\necho \u201d \u201d
\necho \u201d Output Contains the following fields:\u201d
\necho \u201d Resource Name\u201d
\necho \u201d Resource Type, which includes an identifier C-Cluster and L-Local\u201d
\necho \u201d Target State\u201d
\necho \u201d Current State\u201d
\necho \u201d Current Node (11gR2: or the last node in paraenthesis if the resource is Offline)\u201d
\necho \u201d Failure Count (11gR2 only)\u201d
\necho \u201d Restart Count (11gR2 only)\u201d
\necho \u201d State Details (11gR2 only)\u201d
\nexit 101
\n} # print_usage<\/p>\n
function get_cmdline_options {
\nwhile getopts \u201c:chv\u201d opt; do
\ncase ${opt} in
\nc ) sort_cluster_local=\u201dtrue\u201d
\n;;
\nh ) print_usage
\nexit 10
\n;;
\nv ) echo \u201cVersion: $VERSION\u201d
\nexit 100
\n;;
\n* ) echo \u201cError: Invalid option specified.\u201d
\nprint_usage
\nexit 10
\n;;
\nesac
\ndone
\nshift $(($OPTIND -1))
\n} # get_cmdline_options<\/p>\n
get_cmdline_options $@
\nenv_file=$(dirname $0)\/crsstat.env
\nif [[ -e ${env_file} ]] ; then
\n. ${env_file}
\nelse
\nCRSCMD=\u201dquery crs softwareversion\u201d
\nHASCMD=\u201dquery has softwareversion\u201d
\n# Try to auto-determine CRS or HAS home & version
\nCSSD_DIR=`dirname $( ps -eo args | grep ocssd.bin | grep -v grep | ${AWK} \u2018{print $1}\u2019)`
\nif [[ ! -z ${CSSD_DIR} || ${CSSD_DIR} == \u201c.\u201d ]] ; then
\nCSSD_DIR=$(dirname $( ps -eo args | grep hasd.bin | grep -v grep | ${AWK} \u2018{print $1}\u2019))
\nfi
\nif [[ ! -z ${CSSD_DIR} ]] ; then
\nGRID_HOME=`echo $CSSD_DIR|${AWK} \u2018{print substr( $1, 1, length( $1)-4)}\u2019`
\nretval=`${CSSD_DIR}\/crsctl ${CRSCMD}`
\nrc=$?
\nif (( ${rc} != 0 )) ; then
\nretval=`${CSSD_DIR}\/crsctl ${HASCMD}`
\nrc=$?
\nif (( ${rc} != 0 )); then
\necho \u201cThe CRS or HAS version could not be determined.\u201d
\necho \u201cCommands to query for either failed.\u201d
\necho \u201cExiting\u2026.\u201d
\nexit 2
\nfi
\nfi
\nGRID_VER=`echo \u201c${retval}\u201d | ${AWK} \u2018{print substr( $NF, 2, 4)}\u2019`
\nif [[ ! -z ${GRID_HOME} || ! -z ${GRID_VER} ]] ; then
\necho \u201cGRID_HOME=${GRID_HOME}\u201d > ${env_file}
\necho \u201cGRID_VER=${GRID_VER}\u201d >> ${env_file}
\nfi
\nelse
\necho \u201cThe CRS or HAS home directory could not be determined.\u201d
\necho \u201cIf CRS or HAS are down, this could be the cause of the error.\u201d
\necho \u201cExiting\u2026.\u201d
\nexit 1
\nfi
\nfi<\/p>\n
if [[ -z ${GRID_HOME} || -z ${GRID_VER} ]] ; then
\necho \u201cThe configuration of your GRID Infrastructure could not be determined.\u201d
\necho \u201cExiting\u2026.\u201d
\nexit 5
\nfi<\/p>\n
format_crs_status_resource=\u2019
\nBEGIN {
\nFS=\u201d=\u201d;
\nittype=empty
\nlastnode=\u201d\u201d
\n}
\n{
\nif ( $1 == \u201cNAME\u201d) {
\ntname=$2
\ntx=split( $2, tsplit, \u201c.\u201d)
\ntabrev=tsplit[tx]
\nttype=\u201dunknown\u201d
\nif ( tabrev == \u201casm\u201d )
\nttype=\u201dASM\u201d
\nif ( tabrev == \u201clsnr\u201d )
\nttype=\u201dListener\u201d
\nif ( tabrev == \u201cdb\u201d )
\nttype=\u201dDatabase\u201d
\nif ( tabrev == \u201cinst\u201d )
\nttype=\u201dInstance\u201d
\nif ( tabrev == \u201cvip\u201d )
\nttype=\u201dVirtual IP\u201d
\nif ( tabrev == \u201cons\u201d )
\nttype=\u201dOra Notif Svc\u201d
\nif ( tabrev == \u201ccs\u201d )
\nttype=\u201dService\u201d
\nif ( tabrev == \u201csrv\u201d )
\nttype=\u201dService\u201d
\n}
\nif ( $1 == \u201cTYPE\u201d) {
\nottype=$2
\nif (ottype == \u201capplication\u201d) {
\nottype=ttype
\nittype=empty
\n}
\nelse {
\ntx=split( $2, tsplit, \u201c.\u201d)
\nittype=tsplit[2]
\nif ( ittype == \u201casm\u201d )
\nottype=\u201dASM\u201d
\nelse if ( ittype == \u201cgsd\u201d )
\nottype=\u201dGbl Svc Daemon\u201d
\nelse if ( ittype == \u201clistener\u201d )
\nottype=\u201dListener\u201d
\nelse if ( ittype == \u201cscan_listener\u201d )
\nottype=\u201dSCAN Listener\u201d
\nelse if ( ittype == \u201cscan_vip\u201d )
\nottype=\u201dSCAN VIP\u201d
\nelse if ( ittype == \u201coc4j\u201d )
\nottype=\u201dOC4J\u201d
\nelse if ( ittype == \u201ceons\u201d )
\nottype=\u201deons\u201d
\nelse if ( ittype == \u201cons\u201d )
\nottype=\u201dOra Notif Svc\u201d
\nelse if ( ittype == \u201cnetwork\u201d )
\nottype=\u201dNetwork (VIP)\u201d
\nelse if ( ittype == \u201ccluster_vip_net1\u2033 )
\nottype=\u201dCluster VIP\u201d
\nelse ottype=ittype
\n}
\n}
\nif ( $1 == \u201cCARDINALITY_ID\u201d ) {
\nif ( $2 == \u201cONLINE\u201d || $2 == \u201cOFFLINE\u201d ) {
\nrtype=\u201dL\u201d
\n}
\nelse {
\nrtype=\u201dC\u201d
\n}
\n}
\nif ( $1 == \u201cLAST_SERVER\u201d) {
\nlastnode=\u201d(\u201c$2\u2033)\u201d
\n}
\nif ( $1 == \u201cRESTART_COUNT\u201d) {
\ntrc=$2
\n}
\nif ( $1 == \u201cFAILURE_COUNT\u201d) {
\ntfc=$2
\n}
\nif ( $1 == \u201cTARGET\u201d) {
\nttarget=$2
\ntx=split( $2, targetsplit, \u201c,\u201d)
\n}
\nif ( $1 == \u201cSTATE\u201d) {
\nif ( ittype == \u201casm\u201d || ittype == \u201cons\u201d || ittype == \u201ceons\u201d || ittype == \u201cnetwork\u201d || ittype == \u201clistener\u201d ) {
\nstx=split( $2, statesplit, \u201c,\u201d)
\n}
\nelse {
\ntx=split( $2, tsplit, \u201d \u201c)
\ntstate=tsplit[1]
\ntnode=tsplit[3]
\n}
\n}
\nif ( $1 == \u201cSTATE_DETAILS\u201d) {
\ntdetail=$2
\nif ( ittype == \u201casm\u201d || ittype == \u201cons\u201d || ittype == \u201ceons\u201d || ittype == \u201cnetwork\u201d || ittype == \u201clistener\u201d ) {
\nfor (i in statesplit) {
\ntx=split( statesplit[i], tsplit, \u201d \u201c)
\ntstate=tsplit[1]
\ntnode=tsplit[3]
\nttarget=targetsplit[i]
\ngsub(\/ *\/,\u201d\u201d,ttarget)
\ngsub(\/ *\/,\u201d\u201d,tstate)
\nif ( tnode == \u201c\u201d )
\ntnode=lastnode
\nif ( parm_rtype == \u201cA\u201d || ( parm_rtype == rtype ) ) {
\nif ( ttarget == \u201cONLINE\u201d && tstate != \u201cONLINE\u201d )
\nprintf( \u201c[0;31;40m%-40s %-14s %1s %-10s %-12s %-15s %2s %2s %s[0m\\n\u201d, tname, ottype, rtype, ttarget, tstate, tnode, tfc, trc, tdetail)
\nelse
\nprintf( \u201c[0;37;40m%-40s %-14s %1s %-10s %-12s %-15s %2s %2s %s[0m\\n\u201d, tname, ottype, rtype, ttarget, tstate, tnode, tfc, trc, tdetail)
\n}
\n}
\n}
\nelse {
\nif ( tnode == \u201c\u201d )
\ntnode=lastnode
\nif ( parm_rtype == \u201cA\u201d || ( parm_rtype == rtype ) ) {
\nif ( ttarget == \u201cONLINE\u201d && tstate != \u201cONLINE\u201d )
\nprintf( \u201c[0;31;40m%-40s %-14s %1s %-10s %-12s %-15s %2s %2s %s[0m\\n\u201d, tname, ottype, rtype, ttarget, tstate, tnode, tfc, trc, tdetail)
\nelse
\nprintf( \u201c[0;37;40m%-40s %-14s %1s %-10s %-12s %-15s %2s %2s %s[0m\\n\u201d, tname, ottype, rtype, ttarget, tstate, tnode, tfc, trc, tdetail)
\n}
\n}
\n}
\n}\u2019
\n# End of variable: format_crs_status_resource<\/p>\n
format_crs_stat=\u2019
\n{
\nif ($1 == \u201cNAME\u201d) {
\ntname=$2
\n}
\nif ($1 == \u201cTYPE\u201d) {
\nttype=$2
\n}
\nif ($1 == \u201cTARGET\u201d) {
\nttarget=$2
\n}
\nif ($1 == \u201cSTATE\u201d) {
\nsplit( $2, tsplit, \u201d \u201c)
\ntstate=tsplit[1]
\ntnode=tsplit[3]
\nif ( ttarget == \u201cONLINE\u201d && tstate != \u201cONLINE\u201d )
\nprintf( \u201c[0;31;40m%-40s %-14s %-10s %-12s %-15s[0m\\n\u201d, tname, ttype, ttarget, tstate, tnode)
\nelse
\nprintf( \u201c[0;37;40m%-40s %-14s %-10s %-12s %-15s[0m\\n\u201d, tname, ttype, ttarget, tstate, tnode)
\n}
\n}\u2019
\n# End of variable: format_crs_stat<\/p>\n
printf \u201c[0;40;37m\\n\\n%-40s %-16s %-10s %-12s %-15s %-2s %-2s %s[0m\\n\u201d \u201cResource Name\u201d \u201cResource Type\u201d \u201cTarget\u201d \u201cState\u201d \u201cNode\u201d \u201cFC\u201d \u201cRC\u201d \u201cState Details\u201d
\nprintf \u201c[0;40;37m%-40s %-16s %-10s %-12s %-15s %-2s %-2s %s[0m\\n\u201d \u201c\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-\u201d \u201c\u2014\u2014\u2014\u2014\u2014-\u201d \u201c\u2014\u2014\u2014-\u201d \u201c\u2014\u2014\u2014\u2014\u201d \u201c\u2014\u2014\u2014\u2014\u2014\u201d \u201c\u2013\u201d \u201c\u2013\u201d \u201c\u2014\u2014\u2014\u2014\u2014\u201d<\/p>\n
if [[ ${GRID_VER} == \u201c11.2\u201d ]] ; then
\nformat_output=${format_crs_status_resource}
\nif [[ \u201c$1\u201d != \u201c-c\u201d ]] ; then
\nsearchterm=$1
\nelif [[ ! -z \u201c$2\u2033 ]] ; then
\nsearchterm=$2
\nfi
\nif [[ ! -z ${sort_cluster_local} ]] ; then
\nsort_cluster_local=\u201dlocal\u201d
\nprintf \u201c[0;40;37mLocal Resources[0m\\n\u201d
\nprintf \u201c[0;40;37m\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2013\\n\u201d
\nif [[ -z ${searchterm} ]] ; then
\n${GRID_HOME}\/bin\/crsctl status resource -v | ${AWK} -v \u201cparm_rtype=L\u201d \u201c${format_output}\u201d
\nelse
\n${GRID_HOME}\/bin\/crsctl status resource -v | ${AWK} -v \u201cparm_rtype=L\u201d \u201c${format_output}\u201d | grep -i \u201c${searchterm}\u201d
\nfi
\nsort_cluster_local=\u201dcluster\u201d
\nprintf \u201c[0;40;37m\\nCluster Resources[0m\\n\u201d
\nprintf \u201c[0;40;37m\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2013[0m\\n\u201d
\nif [[ -z ${searchterm} ]] ; then
\n${GRID_HOME}\/bin\/crsctl status resource -v | ${AWK} -v \u201cparm_rtype=C\u201d \u201c${format_output}\u201d
\nelse
\n${GRID_HOME}\/bin\/crsctl status resource -v | ${AWK} -v \u201cparm_rtype=C\u201d \u201c${format_output}\u201d | grep -i \u201c${searchterm}\u201d
\nfi
\nelse
\nif [[ -z ${searchterm} ]] ; then
\n${GRID_HOME}\/bin\/crsctl status resource -v | ${AWK} -v \u201cparm_rtype=A\u201d \u201c${format_output}\u201d
\nelse
\n${GRID_HOME}\/bin\/crsctl status resource -v | ${AWK} -v \u201cparm_rtype=A\u201d \u201c${format_output}\u201d | grep -i \u201c${searchterm}\u201d
\nfi
\nfi
\nelse
\nif [[ -e ${GRID_HOME}\/bin\/crs_stat ]] ; then
\nformat_output=${format_crs_stat}
\nif [[ \u201c$1\u201d != \u201c-c\u201d ]] ; then
\nsearchterm=$1
\nelif [[ ! -z \u201c$2\u201d ]] ; then
\nsearchterm=$2
\nfi
\nif [[ -z ${searchterm} ]] ; then
\n${GRID_HOME}\/bin\/crs_stat | ${AWK} -F= \u201c${format_output}\u201d
\nelse
\n${GRID_HOME}\/bin\/crs_stat | ${AWK} -F= \u201c${format_output}\u201d | grep -i \u201c${searchterm}\u201d
\nfi
\nelse
\necho \u201ccrs_stat was not found in the ${GRID_HOME}\/bin\u201d
\nfi
\nfi<\/p>\n","protected":false},"excerpt":{"rendered":"
ASM \u2013 CHECK CRS STATUS SCRIPT #!\/usr\/bin\/ksh #This script gives crs status if [[ `uname -s` = \u201cSunOS\u201d ]] ; then AWK=\/usr\/bin\/nawk else AWK=\/usr\/bin\/awk fi function print_usage { echo \u201d \u201d echo \u201cUsage: crsstat [-h] [-c] [search term]\u201d echo \u201d \u201d echo \u201d -h => print this message\u201d echo \u201d -c => […]<\/p>\n","protected":false},"author":1,"featured_media":3402,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[9],"tags":[1274,1271,1273,1272],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/1-know-how-1.jpg?fit=937%2C450","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4717"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4717"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4717\/revisions"}],"predecessor-version":[{"id":4718,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4717\/revisions\/4718"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/3402"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4717"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}