Wednesday, December 4, 2013

10g RAC Administritave Commands

Database related srvctl commands
srvctl add database -d <name> -o <oracle_home> [-m <domain_name>] [-p <spfile>] [-A <name|ip>/netmask] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY}] [-s <start_options>] [-n <db_name>] [-y {AUTOMATIC | MANUAL}]
srvctl config database
srvctl config database -d <name> [-a] [-t]
srvctl disable database -d <name>
srvctl enable database -d <name>
srvctl getenv database -d <name> [-t "<name_list>"]
srvctl modify database -d <name> [-n <db_name] [-o <ohome>] [-m <domain>] [-p <spfile>]  [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY}] [-s <start_options>] [-y {AUTOMATIC | MANUAL}]
srvctl remove database -d <name> [-f]
srvctl setenv database -d <name> {-t <name>=<val>[,<name>=<val>,...] | -T <name>=<val>}
srvctl start database -d <name> [-o <start_options>]
srvctl status database -d <name> [-f] [-v] [-S <level>]
srvctl stop database -d <name> [-o <stop_options>]
srvctl unsetenv database -d <name> -t "<name_list>"


Instance related srvctl commands
srvctl add instance -d <name> -i <inst_name> -n <node_name>
srvctl disable instance -d <name> -i "<inst_name_list>"
srvctl enable instance -d <name> -i "<inst_name_list>"
srvctl getenv instance -d <name> -i <inst_name> [-t "<name_list>"]
srvctl modify instance -d <name> -i <inst_name> -n <node_name>
srvctl modify instance -d <name> -i <inst_name> {-s <asm_inst_name> | -r}
srvctl remove instance -d <name> -i <inst_name> [-f]
srvctl setenv instance -d <name> [-i <inst_name>] {-t "<name>=<val>[,<name>=<val>,...]" | -T "<name>=<val>"}
srvctl start instance -d <name> -i "<inst_name_list>" [-o <start_options>]
srvctl status instance -d <name> -i "<inst_name_list>" [-f] [-v] [-S <level>]
srvctl stop instance -d <name> -i "<inst_name_list>" [-o <stop_options>]
srvctl unsetenv instance -d <name> [-i <inst_name>] -t "<name_list>"

Listener related srvctl commands
srvctl config listener -n <node_name>
srvctl start listener -n <node_name> [-l <lsnr_name_list>]
srvctl stop listener -n <node_name> [-l <lsnr_name_list>]




Service related srvctl commands
srvctl add service -d <name> -s <service_name> -r "<preferred_list>" [-a "<available_list>"] [-P <TAF_policy>]
srvctl add service -d <name> -s <service_name> -u {-r "<new_pref_inst>" | -a "<new_avail_inst>"}
srvctl config service -d <name> [-s <service_name>] [-a] [-S <level>]
srvctl disable service -d <name> -s "<service_name_list>" [-i <inst_name>]
srvctl enable service -d <name> -s "<service_name_list>" [-i <inst_name>]
srvctl getenv service -d <name> -s <service_name> [-t "<name_list>"]
srvctl modify service -d <name> -s <service_name> -i <old_inst_name> -t <new_inst_name> [-f]
srvctl modify service -d <name> -s <service_name> -i <avail_inst_name> -r [-f]
srvctl modify service -d <name> -s <service_name> -n -i <prefered_inst> [-a <available_list>] [-f]
srvctl relocate service -d <name> -s <service_name> -i <old_inst_name> -t <new_inst_name> [-f]
srvctl remove service -d <name> -s <service_name> [-i <inst_name>] [-f]
srvctl setenv service -d <name> [-s <service_name>] {-t "<name>=<val>[,<name>=<val>,...]" | -T "<name>=<val>"}
srvctl start service -d <name> [-s "<service_name_list>" [-i <inst_name>]] [-o <start_options>]
srvctl status service -d <name> [-s "<service_name_list>"] [-f] [-v] [-S <level>]
srvctl stop service -d <name> [-s "<service_name_list>" [-i <inst_name>]] [-f]
srvctl unsetenv service -d <name> [-s <service_name>] -t "<name_list>"


Nodeapps related srvctl commands
srvctl add nodeapps -n <node_name> -o <oracle_home> -A <name|ip>/netmask[/if1[|if2|...]]
srvctl config nodeapps -n <node_name> [-a] [-g] [-o] [-s] [-l]
srvctl getenv nodeapps -n <node_name> [-t "<name_list>"]
srvctl remove nodeapps -n "<node_name_list>" [-f]
srvctl setenv nodeapps -n <node_name> {-t "<name>=<val>[,<name>=<val>,...]" | -T "<name>=<val>"}
srvctl start nodeapps -n <node_name>
srvctl status nodeapps -n <node_name>
srvctl stop nodeapps -n <node_name> [-r]
srvctl unsetenv nodeapps -n <node_name> -t "<name_list>"


ASM related srvctl commands
srvctl add asm -n <node_name> -i <asm_inst_name> -o <oracle_home> [-p <spfile>]
srvctl config asm -n <node_name>
srvctl disable asm -n <node_name> [-i <inst_name>]
srvctl enable asm -n <node_name> [-i <inst_name>]
srvctl modify instance -d <name> -i <inst_name> {-s <asm_inst_name> | -r}
srvctl modify asm -n <node_name> -i <asm_inst_name> [-o <oracle_home>] [-p <spfile>]
srvctl remove asm -n <node_name> [-i <asm_inst_name>] [-f]
srvctl start asm -n <node_name> [-i <asm_inst_name>] [-o <start_options>]
srvctl status asm -n <node_name>
srvctl stop asm -n <node_name> [-i <asm_inst_name>] [-o <stop_options>]

Ocrconfig
Name:
   ocrconfig - Configuration tool for Oracle Cluster Registry.

Synopsis:
   ocrconfig [option]
   option:
       -export <filename> [-s online]
                                           - Export cluster register contents to a file
       -import <filename>                  - Import cluster registry contents from a file
       -upgrade [<user> [<group>]]
                                           - Upgrade cluster registry from previous version
       -downgrade [-version <version string>]
                                           - Downgrade cluster registry to the specified version
       -backuploc <dirname>                - Configure periodic backup location
       -showbackup                         - Show backup information
       -restore <filename>                 - Restore from physical backup
       -replace ocr|ocrmirror [<filename>] - Add/replace/remove a OCR device/file
       -overwrite                          - Overwrite OCR configuration on disk
       -repair ocr|ocrmirror <filename>    - Repair local OCR configuration
       -help                               - Print out this help information

Note:
   A log file will be created in
   $ORACLE_HOME/log/<hostname>/client/ocrconfig_<pid>.log. Please ensure
   you have file creation privileges in the above directory before
   running this tool.


CRSCTL
Usage: crsctl check  crs          - checks the viability of the CRS stack
      crsctl check  cssd         - checks the viability of CSS
      crsctl check  crsd         - checks the viability of CRS
      crsctl check  evmd         - checks the viability of EVM
      crsctl set    css <parameter> <value> - sets a parameter override
      crsctl get    css <parameter> - gets the value of a CSS parameter
      crsctl unset  css <parameter> - sets CSS parameter to its default
      crsctl query  css votedisk    - lists the voting disks used by CSS
      crsctl add    css votedisk <path> - adds a new voting disk
      crsctl delete css votedisk <path> - removes a voting disk
      crsctl enable  crs    - enables startup for all CRS daemons
      crsctl disable crs    - disables startup for all CRS daemons
      crsctl start crs  - starts all CRS daemons.
      crsctl stop  crs  - stops all CRS daemons. Stops CRS resources in case of cluster.
      crsctl start resources  - starts CRS resources.
      crsctl stop resources  - stops  CRS resources.
      crsctl debug statedump evm  - dumps state info for evm objects
      crsctl debug statedump crs  - dumps state info for crs objects
      crsctl debug statedump css  - dumps state info for css objects
      crsctl debug log css [module:level]{,module:level} ...
                            - Turns on debugging for CSS
      crsctl debug trace css - dumps CSS in-memory tracing cache
      crsctl debug log crs [module:level]{,module:level} ...
                            - Turns on debugging for CRS
      crsctl debug trace crs - dumps CRS in-memory tracing cache
      crsctl debug log evm [module:level]{,module:level} ...
                            - Turns on debugging for EVM
      crsctl debug trace evm - dumps EVM in-memory tracing cache
      crsctl debug log res <resname:level> turns on debugging for resources
      crsctl query crs softwareversion [<nodename>] - lists the version of CRS software installed
      crsctl query crs activeversion - lists the CRS software operating version
      crsctl lsmodules css - lists the CSS modules that can be used for debugging
      crsctl lsmodules crs - lists the CRS modules that can be used for debugging
      crsctl lsmodules evm - lists the EVM modules that can be used for debugging

If necesary any of these commands can be run with additional tracing by
adding a "trace" argument at the very front.
Example: crsctl trace check css

No comments:

Post a Comment