Oracle RAC & ASM

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

12c: RAC Environment

https://memorydatabase2023.blogspot.com/2016/02/rac-environment.html


CLUSTERWARE STARTUP Sequence RAC 11gr2/ 12c

https://memorydatabase2023.blogspot.com/2016/07/clusterware-startup-sequence-rac.html


12c: Mirror copy of OCR onto different asm diskgroup

https://memorydatabase2023.blogspot.com/2016/02/oracle-rac-mirror-copy-of-ocr-onto.html


12c: Pin Nodes On Cluster

https://memorydatabase2023.blogspot.com/2016/02/12c-pin-nodes-on-cluster.html


12c: Oracle Local Registry(OLR)

https://memorydatabase2023.blogspot.com/2016/02/12c-olr-oracle-local-registry.html


12c: RAC Modify Default scan port Number

https://memorydatabase2023.blogspot.com/2016/02/12c-rac-modify-default-scan-port-number.html


12c: Creating New Virtual IP to manager HA 

https://memorydatabase2023.blogspot.com/2016/03/oracle-goldengate-creating-virtual-ip.html


12c: Multiplex Voting Files on Oracle RAC 12c

https://memorydatabase2023.blogspot.com/2016/02/multiplex-voting-files-on-oracle-rac-12c.html


12c: ACFS On RAC 12c

https://memorydatabase2023.blogspot.com/2016/03/acfs-automatic-cluster-filesystem-on.html


RAC: Creating service using "srvctl" on pdb

https://memorydatabase2023.blogspot.com/2016/02/rac-creating-service-on-pdb.html


RAC Diagwait

https://memorydatabase2023.blogspot.com/2016/02/rac-diagwait.html


creating OCM response file to apply patch # RAC cluster 

https://memorydatabase2023.blogspot.com/2016/05/creating-ocm-response-file-to-apply.html


Maintainance #


12c: RAC Health Checks

https://memorydatabase2023.blogspot.com/2016/02/rac-health-checks-12c.html


12c: Applying Database Rolling Patch on RAC Cluster

https://memorydatabase2023.blogspot.com/2016/02/applying-database-rolling-patch.html


Resize Online redolog files 

https://memorydatabase2023.blogspot.com/2016/02/resize-online-redologs-files-12c-rac.html


12c:converting database from No Archivelog mode to Archivelog Mode

https://memorydatabase2023.blogspot.com/2016/03/converting-12c-rac-database-to.html


12c: Monitoring Fusion Write RAC 

https://memorydatabase2023.blogspot.com/2016/03/monitoring-fusion-write-rac-12c_15.html


To find Master Node in RAC

https://memorydatabase2023.blogspot.com/2016/05/how-to-find-master-node-in-rac.html 


Troubleshooting # 


12c: RAC Blocked Listener

https://memorydatabase2023.blogspot.com/2016/02/12c-rac-blocked-listener.html


CRS-4535 12C RAC Cluster “ Cannot communicate with Cluster Ready Services “ 

https://memorydatabase2023.blogspot.com/2016/02/12c-rac-crs-4535.html


CRS-8503 12C RAC Cluster “ has a disk HB, but no network HB, DHB has rcfg “ 

https://memorydatabase2023.blogspot.com/2016/03/crs-8503.html


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

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...