American Database Consulting, LLC

Overview of Commonly Used RAC Commands
Home
Downloads
BLOG
ORACLE
CommVault Consultation
Support
Useful Tips
Video Training
Contact Information
Resume

Overview of Basic RAC Management Commands

The commands we will use are listed below. Remember that this document is a quick reference, and not an exhaustive list of all commands for managing your RAC environment.

Cluster Related Commands

crs_stat -t

Shows HA resource status (hard to read)

crsstat

Ouptut of crs_stat -t formatted nicely

ps -ef|grep d.bin

crsd.bin evmd.bin ocssd.bin

crsctl check crs

CSS,CRS,EVM appears healthy

crsctl stop crs

Stop crs and all other services

crsctl disable crs*

Prevents CRS from starting on reboot

crsctl enable crs*

Enables CRS start on reboot

crs_stop -all

Stops all registered resources

crs_start -all

Starts all registered resources

* These commands update the file /etc/oracle/scls_scr/<node>/root/crsstart which contains the string “enable” or “disable” as appropriate.

Database Related Commands

srvctl start instance -d <db_name> -i <inst_name>

Starts an instance

srvctl start database -d <db_name>

Starts all instances

srvctl stop database -d <db_name>

Stops all instances, closes database

srvctl stop instance -d <db_name> -i <inst_name>

Stops an instance

srvctl start service -d <db_name> -s <service_name>

Starts a service

srvctl stop service -d <db_name> -s <service_name>

Stops a service

srvctl status service -d <db_name>

Checks status of a service

srvctl status instance -d <db_name> -i <inst_name>

Checks an individual instance

srvctl status database -d <db_name>

Checks status of all instances

srvctl start nodeapps -n <node_name>

Starts gsd, vip, listener, and ons

srvctl stop nodeapps -n <node_name>

Stops gsd, vip and listener

Keep in mind that some resources will not start unless other resources are already online. We will now look at the general dependency list in greater detail.

There are three main background processes you can see when doing a ps –ef|grep d.bin.  They are normally started by init during the operating system boot process.  They can be started and stopped manually by issuing the command /etc/init.d/init.crs {start|stop|enable|disable}

  1. /etc/rc.d/init.d/init.evmd
  2. /etc/rc.d/init.d/init.cssd
  3. /etc/rc.d/init.d/init.crsd

Once the above processes are running, they will automatically start the following services in the following order if they are enabled.  This list assumes you are using ASM and have a service set up for TAF/load balancing.

  1. The nodeapps (gsd, VIP, ons, listener) are brought online.
  2. The ASM instances are brought online.
  3. The database instances are brought online.
  4. Any defined services are brought online

 

American Database Consulting and Service Company
4765 Rustler Ct.
Colorado Springs, CO 80918