Wednesday, February 1, 2017

Check the status of running Clusterware & DB Status

Check the status of running clusterware & DB Status :::

Once completed the grid installation  need to check and verify the cluster services.

To check the status need to run the below commands. Here is the commands with output.
To run the below commands need to login in as grid user or grid home directory.
Check CRS Status ::

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

Check Clusterware Resources :::

[grid@ocluster01 grid]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host       
----------------------------------------------------------------------
ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    ocluster01 
ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    ocluster01 
ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    ocluster02 
ora....N2.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    ocluster01 
ora....N3.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    ocluster01 
ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    ocluster01 
ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    ocluster01 
ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE              
ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    ocluster01 
ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    ONLINE    ocluster01 
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    ocluster01 
ora....01.lsnr application    0/5    0/0    ONLINE    ONLINE    ocluster01 
ora....r01.gsd application    0/5    0/0    OFFLINE   OFFLINE              
ora....r01.ons application    0/3    0/0    ONLINE    ONLINE    ocluster01 
ora....r01.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    ocluster01 
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    ocluster02 
ora....02.lsnr application    0/5    0/0    ONLINE    ONLINE    ocluster02 
ora....r02.gsd application    0/5    0/0    OFFLINE   OFFLINE              
ora....r02.ons application    0/3    0/0    ONLINE    ONLINE    ocluster02 
ora....r02.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    ocluster02 
ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    ocluster01 
ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    ocluster02 
ora.scan2.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    ocluster01 
ora.scan3.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    ocluster01 
[grid@ocluster01 grid]$

Check Cluster Nodes :::

[grid@ocluster01 grid]$ olsnodes -n
ocluster01    1
ocluster02    2

Check Oracle TNS Listener Process on Both Nodes :::

[grid@ocluster01 grid]$ ps -ef | grep lsnr | grep -v 'grep' | grep -v 'ocfs' | awk '{print $9}'
LISTENER_SCAN2
LISTENER_SCAN3
LISTENER

Confirming Oracle ASM Function for Oracle Clusterware Files :::

[grid@ocluster01 grid]$ srvctl status asm -a
ASM is running on ocluster02,ocluster01
ASM is enabled.


Check Oracle Cluster Registry (OCR) :::

[grid@ocluster01 grid]$
[grid@ocluster01 grid]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
     Version                  :          3
     Total space (kbytes)     :     262120
     Used space (kbytes)      :       2672
     Available space (kbytes) :     259448
     ID                       :   16461733
     Device/File Name         :      +DATA
                                    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



Check Voting Disk :::

[grid@ocluster01 grid]$ crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   5b7bf089cab44f30bf7ba5dd0337f7d9 (ORCL:ASMDISK1) [DATA]
Located 1 voting disk(s).


No comments:

Post a Comment

Thanks for giving comments!!