Oracle RAC 12.2 on VMware Workstation – Post 5: Post-Installation and Final Validation

This post is also available in:

Series: Oracle RAC 12.2 – Complete Installation on VMware Workstation

📌 About this series: This guide covers Oracle RAC 12c, which is out of support. The goal is to document learning and revisit concepts – not to recommend this version for production. Read the full context in the series overview →

📋 This series — Oracle RAC 12.2 on VMware Workstation:

⚙️ Prerequisite: Post 4 completed — Oracle Database installed and RAC database created by DBCA.

In Post 4 the DBCA created the RAC database with all necessary configurations – archive log, UNDO tablespace, listeners, and redo logs are all set up automatically. This post validates that everything is working correctly and serves as a quick reference for day-to-day commands.

Final Validation

Verify the Cluster

crsctl stat res -t

olsnodes -v -n -i -s

crsctl query css votedisk
ocrcheck

Verify the Database

srvctl status database -d ORCL -v

su - oracle
db_env
sqlplus / as sysdba

SELECT INST_ID, INSTANCE_NAME, HOST_NAME, STATUS
FROM GV$INSTANCE ORDER BY 1;
-- 1  ORCL1  orclrac1  OPEN
-- 2  ORCL2  orclrac2  OPEN

SELECT NAME, STATE, TOTAL_MB, FREE_MB FROM V$ASM_DISKGROUP;
-- OCR, MGMT, DATA, and FRA should be MOUNTED

Verify SCAN

tnsping orclrac-scan:1521/ORCL
srvctl status scan
srvctl status scan_listener

Final Checklist

Quick Reference

Switch Environment

grid_env    # ASM / Clusterware  →  ORACLE_SID=+ASM1 or +ASM2
db_env      # Database           →  ORACLE_SID=ORCL1 or ORCL2

Cluster Management

Database Management

iSCSI

Chrony

Essential Logs

Conclusion

Throughout this series we built a complete Oracle RAC 12.2 from scratch on VMware Workstation:

• Intro: RAC architecture, components, and reference environment
• Post 1: VMware networks and Openfiler iSCSI storage
• Post 2: Oracle Linux on both nodes, clone, and iSCSI Initiator
• Post 3: Grid Infrastructure with all OUI screens and known errors
• Post 4: Oracle Database Software and DBCA with every option explained
• Post 5: Environment validation and command quick reference

The environment is ready for high availability testing, failover scenarios, performance tuning, and any Oracle RAC study topic you want to explore.