Display local and clusterwide resources
Local resources ( based on crsctl stat res -t -init )
# my_crs_stat_init
NAME TARGET STATE SERVER STATE_DETAILS
------------------------- ---------- ---------- ------------ ------------------
ora.asm ONLINE ONLINE grac41 Started
ora.cluster_interconnect.haip ONLINE ONLINE grac41
ora.crf ONLINE ONLINE grac41
ora.crsd ONLINE ONLINE grac41
ora.cssd ONLINE ONLINE grac41
ora.cssdmonitor ONLINE ONLINE grac41
ora.ctssd ONLINE ONLINE grac41 OBSERVER
ora.diskmon OFFLINE OFFLINE
ora.drivers.acfs ONLINE ONLINE grac41
ora.evmd ONLINE ONLINE grac41
ora.gipcd ONLINE ONLINE grac41
ora.gpnpd ONLINE ONLINE grac41
ora.mdnsd ONLINE ONLINE grac41
Note : ora.diskmon is OFFLINE for Non-Exadata system . This is the expected behavior. For details read
11.2.0.3 Grid Infrastructure diskmon Will be Offline by Default in Non-Exadata Environment (Doc ID 1346881.1)
Stop and start a local resources
# crsctl stop resource ora.crf -init
# crsctl start resource ora.crf -init
Note you should start an stop HAIP with an active RAC
# crsctl stop resource ora.cluster_interconnect.haip -init
# crsctl start resource ora.cluster_interconnect.haip -init
Display CLusterwide resources (based on crsctl stat res -t )
# my_crs_stat
NAME TARGET STATE SERVER STATE_DETAILS
------------------------- ---------- ---------- ------------ ------------------
ora.DATA.dg ONLINE ONLINE grac41
ora.DATA.dg OFFLINE ONLINE grac42
ora.DATA.dg OFFLINE ONLINE grac43
ora.FRA.dg ONLINE ONLINE grac41
ora.FRA.dg OFFLINE ONLINE grac42
ora.FRA.dg OFFLINE ONLINE grac43
ora.LISTENER.lsnr ONLINE ONLINE grac41
ora.LISTENER.lsnr ONLINE ONLINE grac42
ora.LISTENER.lsnr ONLINE ONLINE grac43
ora.OCR.dg ONLINE ONLINE grac41
ora.OCR.dg ONLINE ONLINE grac42
ora.OCR.dg ONLINE ONLINE grac43
ora.SSD.dg ONLINE ONLINE grac41
ora.SSD.dg ONLINE ONLINE grac42
ora.SSD.dg ONLINE ONLINE grac43
ora.asm ONLINE ONLINE grac41 Started
ora.asm ONLINE ONLINE grac42 Started
ora.asm ONLINE ONLINE grac43 Started
ora.gsd OFFLINE OFFLINE grac41
ora.gsd OFFLINE OFFLINE grac42
ora.gsd OFFLINE OFFLINE grac43
ora.net1.network ONLINE ONLINE grac41
ora.net1.network ONLINE ONLINE grac42
ora.net1.network ONLINE ONLINE grac43
ora.ons ONLINE ONLINE grac41
ora.ons ONLINE ONLINE grac42
ora.ons ONLINE ONLINE grac43
ora.registry.acfs ONLINE ONLINE grac41
ora.registry.acfs ONLINE ONLINE grac42
ora.registry.acfs ONLINE ONLINE grac43
ora.LISTENER_SCAN1.lsnr ONLINE ONLINE grac43
ora.LISTENER_SCAN2.lsnr ONLINE ONLINE grac41
ora.LISTENER_SCAN3.lsnr ONLINE ONLINE grac42
ora.cvu ONLINE ONLINE grac42
ora.gns ONLINE ONLINE grac43
ora.gns.vip ONLINE ONLINE grac43
ora.grac4.db ONLINE ONLINE grac41 Open
ora.grac4.db ONLINE ONLINE grac42 Open
ora.grac4.db ONLINE ONLINE grac43 Open
ora.grac4.grac41.svc ONLINE ONLINE grac41
ora.grac4.grac42.svc ONLINE ONLINE grac42
ora.grac4.grac43.svc ONLINE ONLINE grac43
ora.grac4.report.svc ONLINE ONLINE grac42
ora.grac41.vip ONLINE ONLINE grac41
ora.grac42.vip ONLINE ONLINE grac42
ora.grac43.vip ONLINE ONLINE grac43
ora.oc4j ONLINE ONLINE grac42
ora.scan1.vip ONLINE ONLINE grac43
ora.scan2.vip ONLINE ONLINE grac41
ora.scan3.vip ONLINE ONLINE grac42
procwatcher OFFLINE OFFLINE
procwatcher ONLINE ONLINE grac43
procwatcher ONLINE ONLINE grac42
Display Resource Details
crsctl status resource switches:
-f display full configuration
-p dislpay static configuration
-v display runtime configuration
Display all resources with full details
# crsctl status resource -f
Display a single resource with full details
# crsctl status resource ora.grac4.db -f
NAME=ora.grac4.db
TYPE=ora.database.type
ACL=owner:oracle:rwx,pgrp:oinstall:r--,other::r--,group:dba:r-x,group:oper:r-x,user:grid:r-x
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
ACTIVE_PLACEMENT=1
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
AUTO_START=restore
CARDINALITY=3
CHECK_INTERVAL=1
CHECK_TIMEOUT=30
CLUSTER_DATABASE=true
DATABASE_TYPE=RAC
DB_UNIQUE_NAME=grac4
DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=database) PROPERTY(DB_UNIQUE_NAME= CONCAT(PARSE(%NAME%, ., 2), %USR_ORA_DOMAIN%, .)) ELEMENT(INSTANCE_NAME= %GEN_USR_ORA_INST_NAME%) ELEMENT(DATABASE_TYPE= %DATABASE_TYPE%)
DEGREE=1
DESCRIPTION=Oracle Database resource
ENABLED=1
FAILOVER_DELAY=0
FAILURE_INTERVAL=60
FAILURE_THRESHOLD=1
GEN_AUDIT_FILE_DEST=/u01/app/oracle/admin/grac4/adump
GEN_START_OPTIONS=
GEN_START_OPTIONS@SERVERNAME(grac41)=open
GEN_START_OPTIONS@SERVERNAME(grac42)=open
GEN_START_OPTIONS@SERVERNAME(grac43)=open
GEN_USR_ORA_INST_NAME=
GEN_USR_ORA_INST_NAME@SERVERNAME(grac41)=grac41
GEN_USR_ORA_INST_NAME@SERVERNAME(grac42)=grac42
GEN_USR_ORA_INST_NAME@SERVERNAME(grac43)=grac43
HOSTING_MEMBERS=
INSTANCE_FAILOVER=0
LOAD=1
LOGGING_LEVEL=1
MANAGEMENT_POLICY=AUTOMATIC
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
ONLINE_RELOCATION_TIMEOUT=0
ORACLE_HOME=/u01/app/oracle/product/11204/racdb
ORACLE_HOME_OLD=
PLACEMENT=restricted
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=2
ROLE=PRIMARY
SCRIPT_TIMEOUT=60
SERVER_POOLS=ora.grac4
SPFILE=+DATA/grac4/spfilegrac4.ora
START_DEPENDENCIES=hard(ora.DATA.dg,ora.SSD.dg) weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns,ora.FRA.dg) pullup(ora.DATA.dg,ora.SSD.dg)
START_TIMEOUT=600
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(intermediate:ora.asm,shutdown:ora.DATA.dg,shutdown:ora.SSD.dg)
STOP_TIMEOUT=600
TYPE_VERSION=3.2
UPTIME_THRESHOLD=1h
USR_ORA_DB_NAME=grac4
USR_ORA_DOMAIN=
USR_ORA_ENV=
USR_ORA_FLAGS=
USR_ORA_INST_NAME=
USR_ORA_INST_NAME@SERVERNAME(grac41)=grac41
USR_ORA_INST_NAME@SERVERNAME(grac42)=grac42
USR_ORA_INST_NAME@SERVERNAME(grac43)=grac43
USR_ORA_OPEN_MODE=open
USR_ORA_OPI=false
USR_ORA_STOP_MODE=immediate
VERSION=11.2.0.4.0