(RAC) Real Application Clusters
Do you need RAC?
Using RAC where you don't have OJVM installed mostly gives you zero downtime patching (but there will be exceptions).
RAC is also a solution for scaling out (adding more smaller servers) when scaling up (making your big server bigger) is not an option.
Many other features of RAC can be achieved with less cost and complexity using Data Guard.
Virtualisation can also work well, but does introduce license complexity.
Oracle RAC One Node
Retains the shared disk element of RAC but enables failover to a, started on demand, second instance instead of running multiple instances concurrently.
Licensable option, but is cheaper than full RAC. (RAC is $23,000 per core, RAC One-Node is $10,000 per core - Jun-2023)
Check
srvctl -V
crsctl query crs softwareversion
crsctl check cluster
NOTE: crs_stat is deprecated since 12.1
crs_stat -t
crs_stat -u
sqlplus / as sysdba
SHOW PARAMETER cluster_database;
SHOW PARAMETER cluster_database_instances
SHOW PARAMETER cluster_interconnects
Bibliography
http://www.slideshare.net/yvelikanov/oracle-12c-rac-on-your-laptop-step-by-step-implementation-guide-10-23587496 https://www.slideshare.net/MarkusMichalewicz/make-your-application-oracle-rac-ready-test-for-ithttps://www.slideshare.net/AnilNair27/oracle-rac-19c-best-practices-and-secret-internals
https://blog.pythian.com/oracle-12c-rac-on-your-laptop-step-by-step-guide/ http://houseofbrick.com/the-oracle-rac-dilemma-part-i/http://houseofbrick.com/the-oracle-rac-dilemma-part-ii/
Oracle RAC One Nodehttps://www.oracle.com/database/technologies/rac/racone.htmlhttps://www.oracle.com/docs/tech/database/rondbrelocateforpsudemo.mp4
VMWare Fault Tolerancehttp://houseofbrick.com/the-oracle-rac-dilemma-part-iii/
Licensing & Supporthttp://houseofbrick.com/oracle-feigns-support-challenges-of-rac-in-third-party-clouds/