RAC administration Commands

Ø  [oracle@rac1 ~]$ srvctl status database -d prod

Instance prod1 is running on node rac1

Instance prod2 is running on node rac2

Ø  [oracle@rac1 ~]$ srvctl status instance -d prod -i prod1

Instance prod1 is running on node rac1

Ø  [oracle@rac1 ~]$ srvctl status asm

ASM is running on rac2,rac1

Ø  [oracle@rac1 ~]$ srvctl status listener

Listener LISTENER is enabled

Listener LISTENER is running on node(s): rac2,rac1

Ø  [oracle@rac1 ~]$ srvctl config scan      [ it displays scan-ip ]

SCAN name: rac-scan, Network: 1/147.43.0.0/255.255.0.0/eth0

SCAN VIP name: scan1, IP: /rac-scan/147.43.0.100

Ø  [oracle@rac1 bin]$ ocrcheck    [Gives the info about OCR ]

Status of Oracle Cluster Registry is as follows :

         Version                           :          3

         Total space (kbytes)     :     262120

         Used space (kbytes)      :       3072

         Available space (kbytes) :     259048

         ID                                      :   38995204

         Device/File Name         :       +OCR

           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

(How take backup of OCR)

Ø  [oracle@rac1 bin]$ ocrconfig –local –showbackup

] mkdir ocrbkp

] su – root

root@rac1]# ./ocrconfig –backuploc /u01/home/ocrbkp  {rac1 & rac2}

root@rac1]# ./ocrconfig –local –export /u01/home/ocrbkp/ocr.exp

                                     ********************

Ø  [oracle@rac1 bin]$ ocrconfig -import /u01/home   (Restore backup from Local location to SAN)

Ø  [oracle@rac1 bin]$ ocrconfig -showbackup manual

PROT-25: Manual backups for the Oracle Cluster Registry are not available

OCR-DUMP:- It is used for changing the file from Binary to Human Readble Format.

Ø  [oracle@rac1 u02]$ ocrdump /u02/moin

Ø  [oracle@rac1 ~]$ olsnodes

       rac1

       rac2

Ø  [oracle@rac1 ~]$ olsnodes -n -s

       rac1    1       Active

       rac2    2       Active

Ø  [oracle@rac1 ~]$ olsnodes – c         [Check Cluster Name]

        rac-cluster

Ø  To check the status of RAC Databases from os level.

       [oracle@rac1 ~]$ crs_stat -t |grep prod

     ora.prod.db    ora....se.type ONLINE    ONLINE    rac1  

Ø  Check CRS Status

[oracle@rac1 ~]$ 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

Ø  To Check Location of Votedisk.

[oracle@rac1 ~]$ crsctl query css votedisk

##  STATE    File Universal Id                File Name Disk group

--  -----    -----------------                --------- ---------

 1. ONLINE   3e8fe285078a4fcdbfc651e65c4a55c9 (ORCL:OCR) [OCR]

Located 1 voting disk(s).

Ø  To Check OHASD status.

[oracle@rac1 bin]$ crsctl check has

CRS-4638: Oracle High Availability Services is online

Ø  To Check SCAN Configuration of Cluster.

[oracle@rac1 ~]$ srvctl config scan

SCAN name: rac-scan, Network: 1/147.43.0.0/255.255.0.0/eth0

SCAN VIP name: scan1, IP: /rac-scan/147.43.0.100

Ø  To Check VIP Status.

[oracle@rac1 ~]$ srvctl status vip -n rac1

VIP rac1-vip is enabled

VIP rac1-vip is running on node: rac1

Ø  To Check Network , Vips, ONS & GSD Status.

[oracle@rac1 ~]$ srvctl status nodeapps -n rac1

VIP rac1-vip is enabled

VIP rac1-vip is running on node: rac1

Network is enabled

Network is running on node: rac1

GSD is disabled

GSD is not running on node: rac1

ONS is enabled

ONS daemon is running on node: rac1

Ø  [oracle@rac1 ~]$ olsnodes -n -s -t

rac1    1       Active  Unpinned

rac2    2       Active  Unpinned

Ø  Verifying OCR Integrity and Location of OCR.

 [oracle@rac1 ~]$ cluvfy comp ocr -n rac1 –verbose

Verifying OCR integrity

Checking OCR integrity...

Checking the absence of a non-clustered configuration...

All nodes free of non-clustered, local-only configurations

ASM Running check passed. ASM is running on all specified nodes

Checking OCR config file "/etc/oracle/ocr.loc"...

OCR config file "/etc/oracle/ocr.loc" check successful

Disk group for ocr location "+OCR" available on all the nodes

NOTE:

This check does not verify the integrity of the OCR contents. Execute 'ocrcheck' as a privileged user to verify the contents of OCR.

OCR integrity check passed

Verification of OCR integrity was successful.

Ø  How to chek SCAN ips From root

] nslookup scanip-name  (Ex : run this command 3 types it shows how it resolves it works on round robin faishon)

Ø  Scan ips are not stored in /etc/hosts only virtual,private & public ips will store.

Ø  Oracle not recommended to store Scan ips in DNS

Ø  If only one scan ip is there then we can store in /etc/host.

 Happy Learning ...