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 -tShows HA resource status (hard to read)
crsstatOuptut of crs_stat -t formatted nicely
ps -ef|grep d.bincrsd.bin evmd.bin ocssd.bin
crsctl check crsCSS,CRS,EVM appears healthy
crsctl stop crsStop crs and all other services
crsctl disable crs*Prevents CRS from starting on reboot
crsctl enable crs*Enables CRS start on reboot
crs_stop -allStops all registered resources
crs_start -allStarts 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.

5 comments:

  1. WOW AM REALLY HELPED BY THIS QUESTIONS, I JUST ADDED U ON FACEBOOK

    ReplyDelete
  2. Florida Personal Injury Attorney Sinclair Law - Leading Florida Law Firm Attorney Brad Sinclair Represents Personal Injury, Car Accident, Motorcycle Accident Victims in Melbourne.

    ReplyDelete
  3. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete

Note: Only a member of this blog may post a comment.