1 / 29

Oracle10g RAC Administration

Oracle10g RAC Administration. Using srvctl and other tools for managing RAC servers. Overview. SRVCTL command syntax SRVCTL command examples OCR and CRS administration. SRVCTL. Used to control Oracle RAC instances, services, CRS, and Automatic Storage Management (ASM)

benita
Download Presentation

Oracle10g RAC Administration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle10g RACAdministration Using srvctl and other tools for managing RAC servers

  2. Overview • SRVCTL command syntax • SRVCTL command examples • OCR and CRS administration

  3. SRVCTL • Used to control Oracle RAC instances, services, CRS, and Automatic Storage Management (ASM) • Same as Oracle9i srvctl but with more options and features • Can control all systems in the cluster • Uses the OCR

  4. SRVCTL Command Scope • The srvctl command may be used to administer multiple RAC sub-systems • There are options for controlling: • Databases • Instances • Services • Nodeapps • Automatic Storage Management instances (ASM)

  5. Available SRVCTL Commands • Several basic management commands are available for srvctl (not all commands are available for each option) • start • stop • status • enable • disable • add • remove • modify • relocate • config • getenv, setenv, and unsetenv

  6. Commonly Used SRVCTLDatabase Commands • srvctl start database –d db_unique_name [–o start_options] [-c connect_string | -q {prompt for credentials}] • srvctl stop database –d db_unique_name [–o start_options] [-c connect_string | -q {prompt for credentials}] • srvctl enable database –d db_unique_name • srvctl disable database –d db_unique_name • srvctl status database –d db_unique_name [-f {include disabled applications}] –v {verbose}]

  7. SRVCTL Database Command Examples $ srvctl start database -d wwprd $ srvctl status database -d wwprd Instance wwprd1 is running on node wwprod3 Instance wwprd2 is running on node wwprod4 $ srvctl stop database -d wwprd $ srvctl disable database -d wwprd

  8. Commonly Used SRVCTLInstance Commands • srvctl start instance –d dbid –i instance_list [–o start_options] [-c connect_string | -q {prompt for credentials}] • srvctl stop instance –d dbid –i instance_list [–o start_options] [-c connect_string | -q {prompt for credentials}] • srvctl enable instance –d dbid –i instance_list • srvctl disable instance –d dbid –i instance_list • srvctl status instance –d dbid –i instance_list [-f {include disabled applications}] –v {verbose}]

  9. SRVCTL Instance Command Examples $ srvctl start instance -d wwprd -i wwprd1 $ srvctl status instance -d wwprd -i wwprd1 Instance wwprd1 is running on node wwprod3 $ srvctl stop instance -d wwprd -i wwprd1 $ srvctl disable instance -d wwprd -i wwprd1

  10. SRVCTLInstance Commands • In order to avoid the instance starting on reboot, stop and disable the instance • srvctl stop instance –d dbid –i sid • srvctl disable instance –d dbid –i sid $ srvctl status database -d wwprd -f Instance wwprd1 is disabled Instance wwprd2 is running on node wwprod4

  11. SRVCTLInstance Commands • In order to start a disabled instance, enable it and then start • srvctl enable instance –d dbid –i sid $srvctl status database -d wwprd -f Instance wwprd1 is not running on node wwprod3 Instance wwprd2 is running on node wwprod4 • srvctl start instance –d dbid –i sid

  12. SRVCTLInstance Commands • Notice the difference between stopped and disabled Instance wwprd1 is disabled Instance wwprd1 is not running on node wwprod3

  13. SRVCTLNodeapps Commands • Used to control Node Applications • VIP • GSD • Listener • ONS

  14. Commonly Used SRVCTLNodeapps Commands • srvctl start nodeapps –n node_name • srvctl stop nodeapps –n node_name • srvctl status nodeapps –n node_name

  15. SRVCTL Nodeapps Examples $ srvctl start nodeapps -n wwprod3 $ srvctl status nodeapps -n wwprod3 VIP is running on node: wwprod3 GSD is running on node: wwprod3 Listener is running on node: wwprod3 ONS daemon is running on node: wwprod3 $ srvctl stop nodeapps -n wwprod3

  16. Commonly Used SRVCTLService Commands • srvctl start service –d db_unique_name [-s service_name_list [-i instance_name] ] [ –o start_options] [-c connect_string | -q {prompt for credentials}] • srvctl stop service –d db_unique_name [-s service_name_list [-i instance_name] ] [ –o start_options] [-c connect_string | -q {prompt for credentials}] [-f {force}] • srvctl enable service –d db_unique_name [-s service_name_list | -s service_name -i instance_name ] • srvctl disable service –d db_unique_namedbid [-s service_name_list | -s service_name -i instance_name ] • srvctl status service –d db_unique_name [-s service_name_list] [-f {include disabled applications}] –v {verbose}]

  17. SRVCTL Service Command Examples $ srvctl start service –d wwprod –s ERP $ srvctl status service -d wwprd –s ERP Service ERP is running on node wwprod1 Service ERP is running on node wwprod2 $ srvctl stop service –d wwprod –s ERP $ srvctl disable service –d wwprod –s ERP

  18. Commonly Used SRVCTLASM Commands • srvctl start asm –n node_name [–i asm_instance_name] [-o start_options] • srvctl stop asm –n node_name [–i asm_instance_name] [-o start_options] • srvctl enable asm –n node_name [–i asm_instance_name] • srvctl disable asm –n node_name [–i asm_instance_name] • srvctl status asm –n node_name

  19. SRVCTL ASM Command Examples $ srvctl start asm –n wwprod3 $ srvctl status asm -n wwprod3 ASM is running on node wwprod3 $ srvctl stop asm –n wwprod3 $ srvctl disable asm –n wwprod3

  20. Using SRVCTL to Add a Node to SRVM $ srvctl add database –d wwprd –o /opt/oracle/product/10.2.0 –p /u01/spfile+ASM.ora $ srvctl add instance –d wwprd –i wwprd1 -n wwprod1 $ srvctl add nodeapps –n wwprod1 –o /opt/oracle/product/10.2.0 –A 128.96.108.1

  21. OCR (Oracle Cluster Repository) • Used to store configuration and state information about the cluster • Modified by srvctl • Used by CRS

  22. OCR (Oracle Cluster Repository) • Dump the OCR by using ocrdump • Creates a human readable file • OCRDUMPFILE

  23. OCR (Oracle Cluster Repository) • The %ORA_CRS_HOME%\bin\OCRCHECK command checks OCR integrity and status Status of Oracle Cluster Registry is as follows : Version : 2 Total space (kbytes) : 262144 Used space (kbytes) : 16256 Available space (kbytes) : 245888 ID : 1918913332 Device/File Name : /dev/raw/raw1 Device/File integrity check succeeded Device/File Name : /oradata/mirror.ocr Device/File integrity check succeeded Cluster registry integrity check succeeded

  24. OCR and Cluster Commands • Located in %ORA_CRS_HOME%\bin • crs_stat • Shows info about the CRS services • olsnodes • Lists the nodes in the cluster

  25. Cluster Verification Utility • To verify whether your system meets all of the criteria for an Oracle Clusterware installation: • cluvfy stage -pre crsinst -n node_list [ -c ocr_location ] [-r { 10gR1 | 10gR2 } ][ -q voting_disk ] [ -osdba osdba_group ] [ -orainv orainventory_group ] [-verbose] • To verify whether your system meets all of the criteria for a RAC installation, use the pre-check command for the Database Installation stage as follows: • cluvfy stage -pre dbinst -n node_list [-r { 10gR1 | 10gR2 } ] [ -osdba osdba_group ] [ -orainv orainventory_group ] [-verbose] • To verify the integrity of all of the Oracle Clusterware components, use the component verification crs command as follows: • cluvfy comp crs [ -n node_list ] [-verbose]

  26. Cluster Verification Utility • To verify the integrity of each individual Cluster Manager sub-component, use the component verification command clumgr as follows: • cluvfy comp clumgr [ -n node_list ] [-verbose] • To verify the integrity of the Oracle Cluster Registry, use the component verification command ocr as follows: • cluvfy comp ocr [ -n node_list ] [-verbose] • To check the integrity of your entire cluster, which means to verify that all of the nodes in the cluster have the same view of the cluster: • cluvfy comp clu

  27. CRS Status • Creating a tabular report: • %ORA_CRS_HOME%\bin\crs_stat -t Name Type Target State Host -------------------------------------------------------------------------------------------------- ora.rac1.gsd application ONLINE ONLINE rac1 ora.rac1.oem application ONLINE ONLINE rac1 ora.rac1.ons application ONLINE ONLINE rac1 ora.rac1.vip application ONLINE ONLINE rac1 ora.rac2.gsd application ONLINE ONLINE rac2 ora.rac2.oem application ONLINE ONLINE rac2 ora.rac2.ons application ONLINE ONLINE rac2 ora.rac2.vip application ONLINE ONLINE rac2

  28. Review • What is the srvctl command to start the wwprod1 instance for database wwprod? • True or False: If you want to perform maintenance on an instance, all that you have to do is stop the instance with srvctl. • What command would you use to list the status for the database wwprod, including any disabled instances? • If the VIP service is stopped, what command could you use to restart it? • How could you check Oracle Cluster Registry integrity?

  29. Summary • The SRVCTL command may be used to administer multiple Real Application Cluster components, including: • Databases • Instances • Services • Nodeapps • Automatic Storage Management instances (ASM) • The Oracle Cluster Repository is used to store configuration and state information about the cluster • The OCR may be administered with the ocrdump, ocrcheck, cluvfy, srvctl, olsnodes, and crs_stat commands

More Related