Friday, February 19, 2016

OLR Oracle Local Registry 12c

# Oracle Local Registry # 12c RAC Cluster #
OLR is managed by OHASD on each node
OLR is not shared by any another node in a cluster
OLR is required by OHASD start up the Oracle CLusterware during startup  
OLR stores the information about clusterware configuration that helps CRS to Join in a cluster
When ever Node joins a cluster, it brings ASM / Here we know in 11GR2/12C OCR and VOTING FILES STORED ON ASM and CRS uses the information in the OCR and brings up all  resources in a cluster 

Location of OLR 
[root@tnc1 ~]# cd /etc/oracle
[root@tnc1 oracle]# ls -ltr olr.loc
-rw-r--r-- 1 root oinstall 84 Feb 13 01:47 olr.loc

[root@tnc1 oracle]# cat olr.loc
olrconfig_loc=/u01/app/12.1.0.2/grid/cdata/tnc1.olr
crs_home=/u01/app/12.1.0.2/grid


Checking Health of the OCR
[root@tnc1 oracle]# ocrcheck -local
Status of Oracle Local Registry is as follows :
Version                         :   4
Total space (kbytes)      :   409568
Used space (kbytes)       :   976
Available space (kbytes) :  408592
ID                                  :  272906895
Device/File Name          :  /u01/app/12.1.0.2/grid/cdata/tnc1.olr
                                    Device/File integrity check succeeded
Local registry integrity check succeeded Logical corruption check succeeded

ManualBackup of OLR:
Perform Backup as Root User
[oracle@tnc2 ~]$ ocrconfig -local -manualbackup
PROTL-20: Insufficient permission to proceed. Require privileged user
[oracle@tnc2 ~]$ su - root
[root@tnc2 ~]# grid_env
[root@tnc2 ~]# ocrconfig -local -manualbackup
tnc2     2016/02/19 18:18:32     /u01/app/12.1.0.2/grid/cdata/tnc2/backup_20160219_181832.olr     0  
tnc2     2016/02/19 17:54:07     /u01/app/12.1.0.2/grid/cdata/tnc2/backup_20160219_175407.olr     0  
tnc2     2016/02/13 02:17:07     /u01/app/12.1.0.2/grid/cdata/tnc2/backup_20160213_021707.olr     0    

[root@tnc2 ~]# ocrconfig -local -showbackup
tnc2     2016/02/19 18:18:32     /u01/app/12.1.0.2/grid/cdata/tnc2/backup_20160219_181832.olr     0  
tnc2     2016/02/19 17:54:07     /u01/app/12.1.0.2/grid/cdata/tnc2/backup_20160219_175407.olr     0  
tnc2     2016/02/13 02:17:07     /u01/app/12.1.0.2/grid/cdata/tnc2/backup_20160213_021707.olr     0

--Nikhil Tatineni--
--12c RAC Cluster--

Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...