askMLabs

This article is to present various commands used to perform rac health checks. In oracle RAC, there are various components and to know the status of individual components, these commands may help you as reference. The commands are not limited , but as an easy reference to check the status.


Login to server using grid user ( clusterware software owner ) :
Execute the environment profile.


1) RAC Node Apps Health Checks :

[grid@rac11gdb01 ~]$ srvctl status nodeapps
VIP rac11gdb01-vip is enabled
VIP rac11gdb01-vip is running on node: rac11gdb01
VIP rac11gdb02-vip is enabled
VIP rac11gdb02-vip is running on node: rac11gdb02
Network is enabled
Network is running on node: rac11gdb01
Network is running on node: rac11gdb02
GSD is disabled
GSD is not running on node: rac11gdb01
GSD is not running on node: rac11gdb02
ONS is enabled
ONS daemon is running on node: rac11gdb01
ONS daemon is running on node: rac11gdb02
[grid@rac11gdb01 ~]$

2) ASM Status : 

[grid@rac11gdb01 ~]$ srvctl status asm
ASM is running on rac11gdb02,rac11gdb01
[grid@rac11gdb01 ~]$ srvctl status asm -n rac11gdb01
ASM is running on rac11gdb01
[grid@rac11gdb01 ~]$ srvctl status asm -n rac11gdb02
ASM is running on rac11gdb02
[grid@rac11gdb01 ~]$

3) Database Status:

[grid@rac11gdb01 ~]$ srvctl status database -d racdb
Instance racdb1 is running on node rac11gdb01
Instance racdb2 is running on node rac11gdb02
[grid@rac11gdb01 ~]$ srvctl status instance -d racdb -i racdb1
Instance racdb1 is running on node rac11gdb01
[grid@rac11gdb01 ~]$ srvctl status instance -d racdb -i racdb2
Instance racdb2 is running on node rac11gdb02
[grid@rac11gdb01 ~]$

4) CRS Status:

[grid@rac11gdb01 ~]$ 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
[grid@rac11gdb01 ~]$

5) Cluster Status:

[grid@rac11gdb01 ~]$ crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[grid@rac11gdb01 ~]$

6) RAC High Availability Services Status:

[grid@rac11gdb01 ~]$ crsctl check has
CRS-4638: Oracle High Availability Services is online
[grid@rac11gdb01 ~]$

7) Database Services Status : 

[grid@rac11gdb01 ~]$ srvctl status service -d racdb
Service racdb_service is running on instance(s) racdb1,racdb2
[grid@rac11gdb01 ~]$

8) Listener Status: 

[grid@rac11gdb01 ~]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): rac11gdb02,rac11gdb01
[grid@rac11gdb01 ~]$

9) SCAN VIP Status : 

[grid@rac11gdb01 ~]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node rac11gdb02
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node rac11gdb01
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node rac11gdb01
[grid@rac11gdb01 ~]$

10) Scan Listener Status : 

[grid@rac11gdb01 ~]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node rac11gdb02
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node rac11gdb01
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node rac11gdb01
[grid@rac11gdb01 ~]$

11) Server Status : 

[grid@rac11gdb01 ~]$ srvctl status server -n rac11gdb01 -a
Server name: rac11gdb01
Server state: ONLINE
Server active pools: Generic ora.racdb ora.racdb_racdb_service
Server state details:
[grid@rac11gdb01 ~]$ srvctl status server -n rac11gdb02 -a
Server name: rac11gdb02
Server state: ONLINE
Server active pools: Generic ora.racdb ora.racdb_racdb_service
Server state details:
[grid@rac11gdb01 ~]$

12)CVU Status: 

[grid@rac11gdb01 ~]$ srvctl status cvu
CVU is enabled and running on node rac11gdb01
[grid@rac11gdb01 ~]$

13) GNS Status :  ( As root user)

[root@rac11gdb01 ~]# /o001/home/11.2.0.2/grid/bin/srvctl status gns
PRCS-1065 : GNS is not configured.
[root@rac11gdb01 ~]#

14) Serverpool Details : 

[grid@rac11gdb01 ~]$ srvctl status srvpool
Server pool name: Free
Active servers count: 0
Server pool name: Generic
Active servers count: 2
[grid@rac11gdb01 ~]$

15) Cluster Interconnect Details : 

[grid@rac11gdb01 ~]$ oifcfg getif
eth0  192.168.1.0  global  public
eth1  192.168.50.0  global  cluster_interconnect

16) OCR Checks:

[grid@rac11gdb01 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       3224
         Available space (kbytes) :     258896
         ID                       : 1449084471
         Device/File Name         :  +OCR_VOTE
                                    Device/File integrity check succeeded
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
         Cluster registry integrity check succeeded
         Logical corruption check bypassed due to non-privileged user
[grid@rac11gdb01 ~]$

17) OCR Backups:

[grid@rac11gdb01 ~]$ ocrconfig -showbackup
rac11gdb01     2013/09/23 11:46:41     /o001/home/11.2.0.2/grid/cdata/orrcdbdv-clstr/backup00.ocr
rac11gdb01     2013/09/23 04:19:26     /o001/home/11.2.0.2/grid/cdata/orrcdbdv-clstr/backup01.ocr
rac11gdb01     2013/09/23 00:19:25     /o001/home/11.2.0.2/grid/cdata/orrcdbdv-clstr/backup02.ocr
rac11gdb01     2013/09/22 08:19:24     /o001/home/11.2.0.2/grid/cdata/orrcdbdv-clstr/day.ocr
rac11gdb01     2013/09/10 08:18:54     /o001/home/11.2.0.2/grid/cdata/orrcdbdv-clstr/week.ocr
PROT-25: Manual backups for the Oracle Cluster Registry are not available
[grid@rac11gdb01 ~]$

18) Voting Disk Status: 

[grid@rac11gdb01 ~]$ crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   9bc0828570854fa5bff3221500a1fc63 (ORCL:CRSVOL1) [OCR_VOTE]
Located 1 voting disk(s).
[grid@rac11gdb01 ~]$

19) Node apps config details : 

[grid@rac11gdb01 ~]$ srvctl config nodeapps  -a -g -s
Network exists: 1/192.168.1.0/255.255.255.0/eth0, type static
VIP exists: /rac11gdb01-vip/192.168.1.73/192.168.1.0/255.255.255.0/eth0, hosting node rac11gdb01
VIP exists: /rac11gdb02-vip/192.168.1.74/192.168.1.0/255.255.255.0/eth0, hosting node rac11gdb02
GSD exists
ONS exists: Local port 6100, remote port 6200, EM port 2016
[grid@rac11gdb01 ~]$

20) Diskgroups Status:

[grid@rac11gdb01 ~]$ crs_stat -t | grep -i dg
ora....DATA.dg ora....up.type ONLINE    ONLINE    rac11gdb01
ora.FLASH.dg   ora....up.type ONLINE    ONLINE    rac11gdb01
ora....VOTE.dg ora....up.type ONLINE    ONLINE    rac11gdb01
[grid@rac11gdb01 ~]$

Hope this helps
SRI