Managing Resources

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

Leave a Reply

Your email address will not be published. Required fields are marked *