Oracle10g RAC Administration

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_name dbid -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/spfileASM.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