OracleRAC & ASM

Cluster status commands (srvctl and crsctl)

The Clusterware commands for checking a RAC database, its services and every cluster resource.

Not yet verified. How scripts are tested

1-- From the OS prompt as the oracle or grid owner2srvctl status database -d <db_unique_name> -v3srvctl config database -d <db_unique_name>4srvctl status service -d <db_unique_name>5srvctl status asm6srvctl status listener7crsctl stat res -t8crsctl check cluster -all

Run these at the operating system prompt.

Open in denrepo

Helps with

• ORA-01034: ORACLE not available
• ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
• ORA-12541: TNS:no listener

More Oracle scripts: RAC & ASM

• Stop, start and check a RAC database (srvctl)Clusterware commands to stop the database, start it read-only, check its status, and start a single instance in MOUNT mode. Run one line at a time;…
• ASM disk group spaceSize, free and usable space per disk group. Usable GB already accounts for mirroring, so it's the number to alert on. Works from the ASM or database…
• ASM disks and their statusEvery disk ASM can see, including CANDIDATE disks not yet in a group. Check MODE and STATE after storage maintenance.
• ASM rebalance progressRebalance operations in flight with power level and estimated minutes left. No rows means nothing is rebalancing.
• Sessions per instance and serviceHow connections are spread across RAC nodes and services. A lopsided spread usually means a service isn't running where you think it is.
• Global cache (interconnect) waits by instanceCluster-class waits per instance since startup. High average times on gc cr or gc current events point at the interconnect or at hot blocks shared…