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.
[[email protected] ~]$ . oraenv ORACLE_SID = [root] ? +ASM1 [[email protected] ~]$ 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 [[email protected] ~]$
To check cluster status, execute following command.
[[email protected] ~]$ crsctl check cluster CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online [[email protected] ~]$
To check all cluster resource status, execute following command.
[[email protected] ~]# 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 -------------------------------------------------------------------------------- [[email protected] ~]#
2,075 views last month, 1 views today
Hi Mehmet,
very nice article