Hi,
Hi, I will continue to share Oracle RAC Administration Scripts in this post.
Oracle DBA can administer Oracle Clusterware using the Oracle Clusterware Control (CRSCTL) utility.
To check clusterware status, execute following command.
[root@MehmetSalih1 ~]$ . oraenv
ORACLE_SID = [root] ? +ASM1
[root@MehmetSalih ~]$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[root@MehmetSalih ~]$
To check cluster status, execute following command.
[root@MehmetSalih ~]$ crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[root@MehmetSalih ~]$
To check all cluster resource status, execute following command.
[root@Devecidbadm01 ~]# crsctl status resource -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATAC1.dg
ONLINE ONLINE Devecidbadm01 STABLE
ONLINE ONLINE Devecidbadm02 STABLE
ora.DBFS_DG.dg
ONLINE ONLINE Devecidbadm01 STABLE
ONLINE ONLINE Devecidbadm02 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE Devecidbadm01 STABLE
ONLINE ONLINE Devecidbadm02 STABLE
ora.RECOC1.dg
ONLINE ONLINE Devecidbadm01 STABLE
ONLINE ONLINE Devecidbadm02 STABLE
ora.asm
ONLINE ONLINE Devecidbadm01 Started,STABLE
ONLINE ONLINE Devecidbadm02 Started,STABLE
ora.net1.network
ONLINE ONLINE Devecidbadm01 STABLE
ONLINE ONLINE Devecidbadm02 STABLE
ora.ons
ONLINE ONLINE Devecidbadm01 STABLE
ONLINE ONLINE Devecidbadm02 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE Devecidbadm02 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE Devecidbadm01 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE Devecidbadm01 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE Devecidbadm01 169.254.94.159,STABL
E
ora.cvu
1 ONLINE ONLINE Devecidbadm01 STABLE
ora.dbm01.db
1 ONLINE OFFLINE STABLE
2 ONLINE OFFLINE Instance Shutdown,ST
ABLE
ora.ebys.db
1 ONLINE ONLINE Devecidbadm01 Open,STABLE
2 ONLINE ONLINE Devecidbadm02 Open,STABLE
ora.ebytest.db
1 OFFLINE OFFLINE STABLE
2 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
ora.mgmtdb
1 ONLINE ONLINE Devecidbadm01 Open,STABLE
ora.oc4j
1 ONLINE ONLINE Devecidbadm01 STABLE
ora.repdb.db
1 ONLINE ONLINE Devecidbadm01 Open,STABLE
2 ONLINE ONLINE Devecidbadm02 Open,STABLE
ora.scan1.vip
1 ONLINE ONLINE Devecidbadm02 STABLE
ora.scan2.vip
1 ONLINE ONLINE Devecidbadm01 STABLE
ora.scan3.vip
1 ONLINE ONLINE Devecidbadm01 STABLE
ora.test.db
1 OFFLINE OFFLINE STABLE
2 ONLINE OFFLINE Instance Shutdown,ST
ABLE
ora.test.db
1 OFFLINE OFFLINE STABLE
2 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
ora.Deveci.db
1 ONLINE ONLINE Devecidbadm01 Open,STABLE
2 ONLINE ONLINE Devecidbadm02 Open,STABLE
ora.Devecidbadm01.vip
1 ONLINE ONLINE Devecidbadm01 STABLE
ora.Devecidbadm02.vip
1 ONLINE ONLINE Devecidbadm02 STABLE
--------------------------------------------------------------------------------
[root@Devecidbadm01 ~]#