August 2007

The Specialist
Database News You Can Use
A monthly newsletter for Oracle users

August 2007
From Database Specialists
Expert onsite and remote DBA services
for your Oracle databases
Tel: 415-344-0500 • Toll-Free: 1-888-648-0500

Ask DB Specialists: Basic Oracle RAC Commands

You’re invited to submit your Oracle-related questions to us at askdbspecialists08@dbspecialists.com. Please include your name and telephone number in your email.

This month’s question comes to us from Shana in Tachikawa, Japan: I am relatively new at administering Oracle on Linux in a RAC configuration. I am struggling with how to start, stop, and check out the overall RAC health and be sure nothing is offline or failed. I would like to know if you have a “cheat sheet” for starting and stopping Oracle and the cluster services. Oracle has documentation on its web site, but it is spread out and somewhat difficult to wrangle all into a compact easy-to-read list.

Rich Headrick of the Database Specialists team responds: We have just the thing for you. We keep a short, easy to read list of common RAC commands on all of our Oracle 10g RAC servers so they are easily accessed when it’s crunch time. The first thing you might want to do is make things easy on your eyes and download the crsstat script mentioned in the May column.

Secondly, you will want to have mastery of the below commands. Note that some require root privileges, so you may need to have sudo set up for your administrations account to perform them. Also be aware that these commands are a bit different that the ones you may have used to manage an Oracle 9i RAC database.

Here are some of the commands for managing cluster services. Remember, this is a “cheat sheet,” not an exhaustive list of all possibilities:

crs_stat -t                                     :Show HA resource status (hard to read)
crsstat                                         :Ouptut of crs_stat –t formatted better
ps -ef|grep d.bin                               :crsd.bin evmd.bin ocssd.bin
crsctl check crs                                :css, crs, evm appear healthy
crsctl stop crs                                 :Stop crs and all other services
crsctl disable crs                              :Prevent crs from starting on reboot
crsctl enable crs                               :Enable crs start on reboot
crs_stop -all                                   :Stop everything
crs_start -all                                  :Start everything

Here are some of the commands for managing database-related services:

srvctl start instance -d orcl -i orcl2       :Start an instance
srvctl start database -d orcl                :Start all instances
srvctl stop database -d orcl                 :Stop all instances and close database
srvctl stop instance -d orcl -i orcl2        :Stop an instance
srvctl start service -d orcl -s rac          :Start a service
srvctl stop service -d orcl -s rac           :Stop a service
srvctl status service -d orcl                :Check status of a service
srvctl status instance -d orcl -i orcl1      :Check an individual instance
srvctl status database -d orcl               :Check status of all instances
srvctl start nodeapps -n server1             :Start gsd, vip, listener, and ons.
srvctl stop nodeapps -n server2              :Stop gsd, vip, listener, and ons

To learn more about each of these commands and see real-world examples, please read my white paper entitled, A Quick Reference for Oracle Database 10g RAC on Linux and Unix Platforms. You can find it at http://dbspecialists.wpengine.com/presentations/rac_quick_reference.html.

Streams, Optimizing SQL, and More

If you missed the last conference of the Northern California Oracle Users Group, you can still benefit by visiting their website for past presentations. Here is a sampling of the latest presentations and white papers available at http://www.nocoug.org/presentations.html.

Time to Get Certified?

Forbes.com recently reported that database administration is one of the fastest growing jobs in the US, coming in at number 12 on their list. Of course, this is good news for DBAs. But, it’s still a good idea to stay current on new releases of Oracle technology, and studying for your Oracle certification is one way to do that.

For the certification path and accompanying details, visit Oracle’s site at http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=47&p_org_id=1001&lang=US.

You can also find out about the niche-oriented Oracle Expert Program such as “Certified RAC Expert” at http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=145%20.

More RAC Reading

In recent editions of The Specialist, we have discussed the growing trend of companies adopting Real Application Clusters (RAC) as one of the options to assist with high availability. There are a few good resources available to better familiarize yourself with RAC. A good place to start is the Oracle RAC Special Interest Group (http://www.oracleracsig.org). There are forums, news, and documents on the site, including a recent white paper by Barb Lunchild entitled “Understanding RAC Internals.”

You can also find a series of RAC-related articles by Tarry Singh at http://www.databasejournal.com/article.php/3559996. These include articles on RAC administration and RAC in environments where VMware software is used to run virtual machines on a single server.

Once you get set up, don’t forget to browse our newly-released Quick Reference for Oracle Database 10g RAC on Linux and Unix Platforms. You can find it at http://dbspecialists.wpengine.com/presentations/rac_quick_reference.html.

 

  • Diagnosing Bottlenecks in Oracle Streams
  • Fusion: The New Frontier – Oracle Administration in the Future
  • Optimizing SQL in Your PL/SQL Programs
  • AWR: Going Beyond the Scripts Supplied by Oracle

Leave a Reply

Your email address will not be published. Required fields are marked *