Database News You Can Use
A monthly newsletter for Oracle users
You’re invited to submit your Oracle-related questions to us at firstname.lastname@example.org. 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.
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.
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.
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