Administering Oracle RAC 19c with SRVCTL & CRSCTL – Essential Commands 🚀
Oracle Real Application Clusters (RAC) ensures high availability, scalability, and reliability for mission-critical databases. But how do we manage and troubleshoot RAC environments efficiently?
Enter SRVCTL & CRSCTL – two essential tools for managing Oracle RAC components. Let’s dive into their real-world use cases with commands. 🛠️
1️⃣ SRVCTL – Managing RAC Services & Database
SRVCTL (Server Control Utility) is used for managing database instances, listeners, services, and cluster components.
🟢 SRVCTL Commands for Oracle RAC
✅ Check Cluster Configuration:
srvctl config database -d RACDB
✅ Start & Stop Database in RAC:
srvctl start database -d RACDB
srvctl stop database -d RACDB
✅ Start & Stop an Instance in RAC:
srvctl start instance -d RACDB -i RACDB1
srvctl stop instance -d RACDB -i RACDB1
✅ Manage Listeners in RAC:
srvctl start listener
srvctl stop listener
srvctl config listener
✅ Check Running Services in RAC:
srvctl status service -d RACDB
✅ Add, Modify, or Remove a Service:
srvctl add service -d RACDB -s SALES_SRV -r RACDB1,RACDB2
srvctl modify service -d RACDB -s SALES_SRV -r RACDB1
srvctl remove service -d RACDB -s SALES_SRV
2️⃣ CRSCTL – Managing Cluster Resources & Nodes
CRSCTL (Cluster Ready Services Control Utility) is used for low-level cluster management, including node eviction, resource control, and CRS status checks.
🟢 CRSCTL Commands for Oracle RAC
✅ Check Cluster Status:
crsctl check crs
✅ Start & Stop Oracle Clusterware:
crsctl start crs
crsctl stop crs
✅ Check Cluster Nodes:
olsnodes -n
✅ Check Voting Disk Status:
crsctl query css votedisk
✅ Manually Relocate a Resource:
crsctl relocate resource ora.RACDB.db -n NODE2
✅ Stop a Specific Resource:
crsctl stop resource ora.RACDB.db
✅ Get Detailed Resource Information:
crsctl status resource -t
🚀 Why is SRVCTL & CRSCTL Important in Oracle RAC?
✔ Ensures High Availability – Quick management of instances & services.
✔ Optimized Load Balancing – Distribute workloads across nodes.
✔ Troubleshooting & Failover – Handle node failures efficiently.
✔ Cluster Resource Management – Monitor & manage cluster health.