300 likes | 416 Views
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)
E N D
Oracle10g RACAdministration 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) • Same as Oracle9i srvctl but with more options and features • Can control all systems in the cluster • Uses the OCR
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)
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
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}]
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
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}]
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
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
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
SRVCTLInstance Commands • Notice the difference between stopped and disabled Instance wwprd1 is disabled Instance wwprd1 is not running on node wwprod3
SRVCTLNodeapps Commands • Used to control Node Applications • VIP • GSD • Listener • ONS
Commonly Used SRVCTLNodeapps Commands • srvctl start nodeapps –n node_name • srvctl stop nodeapps –n node_name • srvctl status nodeapps –n node_name
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
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}]
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
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
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
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
OCR (Oracle Cluster Repository) • Used to store configuration and state information about the cluster • Modified by srvctl • Used by CRS
OCR (Oracle Cluster Repository) • Dump the OCR by using ocrdump • Creates a human readable file • OCRDUMPFILE
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
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
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]
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
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
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?
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