Skip to main content

Oracle Grid Infrastructure srvctl options for 12.1.0.2.0

Database:
Usage: srvctl add database -db <db_unique_name> -oraclehome <oracle_home> [-dbtype {RACONENODE | RAC | SINGLE} [-server <server_list>] [-instance <inst_name>] [-timeout <timeout>]] [-domain <domain_name>] [-spfile <spfile>] [-pwfile <password_file_path>] [-role {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY | FAR_SYNC}] [-startoption <start_options>] [-stopoption <stop_options>] [-startconcurrency <start_concurrency>] [-stopconcurrency <stop_concurrency>] [-dbname <db_name>] [-policy {AUTOMATIC | MANUAL | NORESTART}] [-serverpool "<serverpool_list>" [-pqpool <pq_server_pools>]] [-node <node_name>] [-diskgroup "<diskgroup_list>"] [-acfspath "<acfs_path_list>"] [-eval] [-fixed] [-verbose]
Usage: srvctl config database [-db <db_unique_name> [-all] | -serverpool <serverpool_name>] [-verbose]
Usage: srvctl start database -db <db_unique_name> [-startoption <start_options>] [-startconcurrency <start_concurrency>] [-node <node>] [-eval] [-verbose]
Usage: srvctl stop database -db <db_unique_name> [-stopoption <stop_options>] [-stopconcurrency <stop_concurrency>] [-force] [-eval] [-verbose]
Usage: srvctl status database {-db <db_unique_name> [-serverpool <serverpool_name>] | -serverpool <serverpool_name> | -thisversion | -thishome} [-force] [-verbose]
Usage: srvctl enable database -db <db_unique_name> [-node <node_name>]
Usage: srvctl disable database -db <db_unique_name> [-node <node_name>]
Usage: srvctl modify database -db <db_unique_name> [-dbname <db_name>] [-instance <instance_name>] [-oraclehome <oracle_home>] [-user <oracle_user>] [-server <server_list>] [-timeout <timeout>] [-domain <domain>] [-spfile <spfile>] [-pwfile <password_file_path>] [-role {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}] [-startoption <start_options>] [-stopoption <stop_options>] [-startconcurrency <start_concurrency>] [-stopconcurrency <stop_concurrency>][-policy {AUTOMATIC | MANUAL | NORESTART}] [-serverpool "<serverpool_list>" [-node <node_name>]] [-pqpool <pq_server_pools>] [-diskgroup "<diskgroup_list>"|-nodiskgroup] [-acfspath "<acfs_path_list>"] [-force] [-eval] [-verbose]
Usage: srvctl remove database -db <db_unique_name> [-force] [-noprompt] [-verbose]
Usage: srvctl getenv database -db <db_unique_name> [-envs "<name>[,...]"]
Usage: srvctl setenv database -db <db_unique_name> {-envs "<name>=<val>[,...]" | -env "<name>=<val>"}
Usage: srvctl unsetenv database -db <db_unique_name> -envs "<name>[,...]"
Usage: srvctl predict database -db <database_name> [-verbose]
Usage: srvctl convert database -db <db_unique_name> -dbtype RAC [-node <node>]
Usage: srvctl convert database -db <db_unique_name> -dbtype RACONENODE [-instance <inst_name>] [-timeout <timeout>]
Usage: srvctl relocate database -db <db_unique_name> {[-node <target>] [-timeout <timeout>] [-stopoption <stop_option>] | -abort [-revert]} [-verbose]
Usage: srvctl upgrade database -db <db_unique_name> -oraclehome <oracle_home>
Usage: srvctl downgrade database -db <db_unique_name> -oraclehome <oracle_home> -targetversion <to_version>
Usage: srvctl update database -db <db_unique_name> [-startoption <start_options> [-node <node_name]]


Instance:

Usage: srvctl add instance -db <db_unique_name> -instance <inst_name> -node <node_name> [-force]
Usage: srvctl start instance -db <db_unique_name> {-node <node_name> [-instance <inst_name>] | -instance <inst_name_list>} [-startoption <start_options>]
Usage: srvctl stop instance -db <db_unique_name> {-node <node_name> | -instance <inst_name_list>}  [-stopoption <stop_options>] [-force] [-failover]
Usage: srvctl status instance -db <db_unique_name> {-node <node_name> | -instance <inst_name_list>} [-force] [-verbose]
Usage: srvctl enable instance -db <db_unique_name> -instance "<inst_name_list>"
Usage: srvctl disable instance -db <db_unique_name> -instance "<inst_name_list>"
Usage: srvctl modify instance -db <db_unique_name> -instance <inst_name> -node <node_name>
Usage: srvctl remove instance -db <db_unique_name> -instance <inst_name> [-force] [-noprompt]
Usage: srvctl update instance -db <db_unique_name> {-instance <instance_name> | -node <node_name>} -startoption <start_options>


Service:

Usage: srvctl add service -db <db_unique_name> -service <service_name> {-preferred "<preferred_list>" [-available "<available_list>"] [-tafpolicy {BASIC | NONE | PRECONNECT}] | -serverpool <pool_name> [-cardinality {UNIFORM | SINGLETON}] } [-netnum <network_number>] [-role "[PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]"] [-policy {AUTOMATIC | MANUAL}] [-notification {TRUE|FALSE}] [-dtp {TRUE|FALSE}] [-clbgoal {SHORT|LONG}] [-rlbgoal {NONE|SERVICE_TIME|THROUGHPUT}] [-failovertype {NONE|SESSION|SELECT|TRANSACTION}] [-failovermethod {NONE|BASIC}] [-failoverretry <failover_retries>] [-failoverdelay <failover_delay>] [-edition <edition>] [-pdb <pluggable_database>] [-global {TRUE|FALSE}] [-maxlag <max_lag_time>] [-sql_translation_profile <sql_translation_profile>] [-commit_outcome {TRUE|FALSE}] [-retention <retention>] [-replay_init_time <replay_initiation_time>] [-session_state {STATIC|DYNAMIC}] [-pqservice <pq_service>] [-pqpool <pq_pool_list>] [-gsmflags <gsm_flags>] [-force] [-eval] [-verbose]
Usage: srvctl add service -db <db_unique_name> -service <service_name> -update {-preferred "<new_pref_inst>" | -available "<new_avail_inst>"} [-force] [-verbose]
Usage: srvctl config service {-db <db_unique_name> [-service <service_name>] | -serverpool <serverpool_name> [-db <db_unique_name>]} [-verbose]
Usage: srvctl enable service -db <db_unique_name> -service  "<service_name_list>" [-instance <inst_name> | -node <node_name>] [-global_override]
Usage: srvctl disable service -db <db_unique_name> -service  "<service_name_list>" [-instance <inst_name> | -node <node_name>] [-global_override]
Usage: srvctl status service {-db <db_unique_name> [-service  "<service_name_list>"] | -serverpool <serverpool_name> [-db <db_unique_name>]} [-force] [-verbose]
Usage: srvctl predict service -db <database_name> -service <service_name> [-verbose]
Usage: srvctl modify service -db <db_unique_name> -service <service_name> -oldinst <old_inst_name> -newinst <new_inst_name> [-force]
Usage: srvctl modify service -db <db_unique_name> -service <service_name> -available <avail_inst_name> -toprefer [-force]
Usage: srvctl modify service -db <db_unique_name> -service <service_name> -modifyconfig -preferred "<preferred_list>" [-available "<available_list>"] [-force]
Usage: srvctl modify service -db <db_unique_name> -service <service_name> [-serverpool <pool_name>] [-pqservice <pqsvc_name>] [-pqpool <pq_pool_list>] [-cardinality {UNIFORM | SINGLETON}] [-tafpolicy {BASIC|NONE}] [-role [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-policy {AUTOMATIC | MANUAL}][-notification {TRUE|FALSE}] [-dtp {TRUE|FALSE}] [-clbgoal {SHORT|LONG}] [-rlbgoal {NONE|SERVICE_TIME|THROUGHPUT}] [-failovertype {NONE|SESSION|SELECT|TRANSACTION}] [-failovermethod {NONE|BASIC}] [-failoverretry <integer>] [-failoverdelay <integer>] [-edition <edition>] [-pdb <pluggable_database>] [-sql_translation_profile <sql_translation_profile>] [-commit_outcome {TRUE|FALSE}] [-retention <retention>] [-replay_init_time <replay_initiation_time>] [-session_state {STATIC|DYNAMIC}] [-maxlag <max_lag_time>] [-gsmflags <gsm_flags>] [-global_override] [-eval] [-verbose] [-force]
Usage: srvctl relocate service -db <db_unique_name> -service <service_name> {-oldinst <old_inst_name> -newinst <new_inst_name> | -currentnode <current_node> -targetnode <target_node>} [-pq] [-force [-noreplay]] [-eval] [-verbose]
Usage: srvctl remove service -db <db_unique_name> -service <service_name> [-instance <inst_name>] [-global_override] [-force]
Usage: srvctl start service -db <db_unique_name> [-service  "<service_name_list>"] [-serverpool <pool_name>] [-node <node_name> | -instance <inst_name>] [-pq] [-global_override] [-startoption <start_options>] [-eval] [-verbose]
Usage: srvctl stop service -db <db_unique_name> [-service  "<service_name_list>"] [-serverpool <pool_name>] [-node <node_name> | -instance <inst_name>] [-pq] [-global_override] [-force [-noreplay]] [-eval] [-verbose]


Nodeapps:

Usage: srvctl add nodeapps { { -node <node_name> -address {<vip_name>|<ip>}/<netmask>[/if1[|if2...]] [-skip]} | { -subnet <subnet>/<netmask>[/if1[|if2...]] } } [-emport <em_port>] [-onslocalport <ons_local_port>]  [-onsremoteport <ons_remote_port>] [-remoteservers <host>[:<port>][,<host>[:<port>]...]] [-clientdata <file>] [-pingtarget "<pingtarget_list>"] [-verbose]Usage: srvctl config nodeapps [-viponly] [-onsonly]
Usage: srvctl modify nodeapps {[-node <node_name> -address {<vip_name>|<ip>}/<netmask>[/if1[|if2...]] [-skip]] | [-subnet <subnet>/<netmask>[/if1[|if2|...]]]} [-nettype {STATIC|DHCP|AUTOCONFIG|MIXED}] [-emport <em_port>] [ -onslocalport <ons_local_port> ] [-onsremoteport <ons_remote_port> ] [-remoteservers <host>[:<port>][,<host>[:<port>]...]] [-clientdata <file>] [-pingtarget "<pingtarget_list>"] [-verbose]
Usage: srvctl start nodeapps [-node <node_name>] [-adminhelper | -onsonly] [-verbose]
Usage: srvctl stop nodeapps [-node <node_name>] [-adminhelper | -onsonly | -relocate] [-force] [-verbose]
Usage: srvctl status nodeapps [-node <node_name>]
Usage: srvctl enable nodeapps [-adminhelper] [-verbose]
Usage: srvctl disable nodeapps [-adminhelper] [-verbose]
Usage: srvctl remove nodeapps [-force] [-noprompt] [-verbose]
Usage: srvctl getenv nodeapps [-viponly] [-onsonly] [-envs "<name>[,...]"]
Usage: srvctl setenv nodeapps {-envs "<name>=<val>[,...]" | -env "<name>=<val>"} [-viponly | -onsonly] [-verbose]
Usage: srvctl unsetenv nodeapps -envs "<name>[,...]" [-viponly | -onsonly] [-verbose]


VIP:

Usage: srvctl add vip -node <node_name> -netnum <network_number> -address {<name>|<ip>}/<netmask>[/if1[|if2...]] [-skip] [-verbose]
Usage: srvctl config vip {-node <node_name> | -vip <vip_name>}
Usage: srvctl disable vip -vip <vip_name> [-verbose]
Usage: srvctl enable vip -vip <vip_name> [-verbose]
Usage: srvctl remove vip -vip <vip_name_list> [-force] [-noprompt] [-verbose]
Usage: srvctl getenv vip -vip <vip_name> [-envs "<name>[,...]"]
Usage: srvctl start vip {-node <node_name> [-netnum <network_number>] | -vip <vip_name>} [-verbose]
Usage: srvctl stop vip {-node <node_name> [-netnum <network_number>] | -vip <vip_name>} [-force] [-relocate] [-verbose]
Usage: srvctl relocate vip -vip <vip_name> [-node <node_name>] [-force] [-verbose]
Usage: srvctl status vip {-node <node_name> | -vip <vip_name>} [-verbose]
Usage: srvctl setenv vip -vip <vip_name> {-envs "<name>=<val>[,...]" | -env "<name>=<val>"} [-verbose]
Usage: srvctl unsetenv vip -vip <vip_name> -envs "<name>[,...]" [-verbose]
Usage: srvctl predict vip -vip <vip_name> [-verbose]


Network:

Usage: srvctl add network [-netnum <network_number>] -subnet <subnet>/<netmask>[/if1[|if2...]] [-nettype {STATIC|DHCP|AUTOCONFIG|MIXED}] [-pingtarget "<pingtarget_list>"] [-leaf] [-verbose]
Usage: srvctl config network [-netnum <network_number>]
Usage: srvctl modify network [-netnum <network_number>] [-subnet <subnet>/<netmask>[/if1[|if2...]]] [-nettype {STATIC|DHCP|AUTOCONFIG|MIXED}] [-iptype {IPV4|IPV6|BOTH}] [-pingtarget "<pingtarget_list>"] [-verbose]
Usage: srvctl remove network {-netnum <network_number> | -all} [-force] [-verbose]
Usage: srvctl predict network [-netnum <network_number>] [-verbose]


ASM:

Usage: srvctl add asm [-listener <lsnr_name>] [-pwfile <password_file_path>] [-flex [-count {<number_of_instances>|ALL}]|-proxy]
Usage: srvctl start asm [-proxy] [-node <node_name>] [-startoption <start_options>]
Usage: srvctl stop asm [-proxy] [-node <node_name>] [-stopoption <stop_options>] [-force]
Usage: srvctl config asm [-proxy] [-detail]
Usage: srvctl status asm [-proxy] [-node <node_name>] [-detail] [-verbose]
Usage: srvctl enable asm [-proxy] [-node <node_name>]
Usage: srvctl disable asm [-proxy] [-node <node_name>]
Usage: srvctl modify asm [-listener <lsnr_name>] [-pwfile <password_file_path>] [-count {<number_of_instances>|ALL}] [-force]
Usage: srvctl remove asm [-proxy] [-force]
Usage: srvctl relocate asm -currentnode <current_node> [-targetnode <target_node>] [-force]
Usage: srvctl getenv asm [-envs "<name>[,...]"]
Usage: srvctl setenv asm {-envs "<name>=<val>[,...]" | -env "<name>=<value>"}
Usage: srvctl unsetenv asm -envs "<name>[,...]"
Usage: srvctl predict asm [-node <node_name>] [-verbose]


DISKGROUP:

Usage: srvctl start diskgroup -diskgroup <dg_name> [-node "<node_list>"]
Usage: srvctl stop diskgroup -diskgroup <dg_name> [-node "<node_list>"] [-force]
Usage: srvctl status diskgroup -diskgroup <dg_name> [-node "<node_list>"] [-detail] [-verbose]
Usage: srvctl enable diskgroup -diskgroup <dg_name> [-node "<node_list>"]
Usage: srvctl disable diskgroup -diskgroup <dg_name> [-node "<node_list>"]
Usage: srvctl remove diskgroup -diskgroup <dg_name> [-force]
Usage: srvctl predict diskgroup -diskgroup <diskgroup_name> [-verbose]


LISTENER:

Usage: srvctl add listener [-listener <lsnr_name>] {[-netnum <network_number>] [-oraclehome <path>] [-user <oracle_user>] | -asmlistener [-subnet <subnet>] | -leaflistener [-subnet <subnet>]} [-skip] [-endpoints "[TCP:]<port>[, ...][/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]"] [-invitednodes <node_list>] [-invitedsubnets <subnet_list>]
Usage: srvctl config listener [-listener <lsnr_name> | -asmlistener | -leaflistener] [-all]
Usage: srvctl start listener [-listener <lsnr_name>] [-node <node_name>]
Usage: srvctl stop listener [-listener <lsnr_name>] [-node <node_name>] [-force]
Usage: srvctl status listener [-listener <lsnr_name>] [-node <node_name>] [-verbose]
Usage: srvctl enable listener [-listener <lsnr_name>] [-node <node_name>]
Usage: srvctl disable listener [-listener <lsnr_name>] [-node <node_name>]
Usage: srvctl modify listener [-listener <lsnr_name>] [-oraclehome <path>] [-endpoints "[TCP:]<port>[, ...][/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]"] [-user <oracle_user>] [-netnum <network_number>]
Usage: srvctl remove listener [-listener <lsnr_name> | -all] [-force]
Usage: srvctl getenv listener [-listener <lsnr_name>] [-envs "<name>[,...]"]
Usage: srvctl setenv listener [-listener <lsnr_name>] {-envs "<name>=<val>[,...]" | -env "<name>=<value>"}
Usage: srvctl unsetenv listener [-listener <lsnr_name>] -envs "<name>[,...]"
Usage: srvctl predict listener -listener <listener_name> [-verbose]


SCAN:

Usage: srvctl add scan -scanname <scan_name> [-netnum <network_number>]
Usage: srvctl config scan [[-netnum <network_number>] [-scannumber <scan_ordinal_number>] | -all]
Usage: srvctl start scan [-netnum <network_number>] [-scannumber <scan_ordinal_number>] [-node <node_name>]
Usage: srvctl stop scan [-netnum <network_number>] [-scannumber <scan_ordinal_number>] [-force]
Usage: srvctl relocate scan -scannumber <scan_ordinal_number> [-netnum <network_number>] [-node <node_name>]
Usage: srvctl status scan [[-netnum <network_number>] [-scannumber <scan_ordinal_number>] | -all] [-verbose]
Usage: srvctl enable scan [-netnum <network_number>] [-scannumber <scan_ordinal_number>]
Usage: srvctl disable scan [-netnum <network_number>] [-scannumber <scan_ordinal_number>]
Usage: srvctl modify scan -scanname <scan_name> [-netnum <network_number>]
Usage: srvctl remove scan [-netnum <network_number>] [-force] [-noprompt]
Usage: srvctl predict scan -scannumber <scan_ordinal_number> [-netnum <network_number>] [-verbose]


SCAN_LISTENER:

Usage: srvctl add scan_listener [-netnum <network_number>] [-listener <lsnr_name_prefix>] [-skip] [-endpoints [TCP:]<port>[/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]] [-invitednodes <node_list>] [-invitedsubnets <subnet_list>]
Usage: srvctl config scan_listener [[-netnum <network_number>] [-scannumber <scan_ordinal_number>] | -all]
Usage: srvctl start scan_listener [-netnum <network_number>] [-scannumber <scan_ordinal_number>] [-node <node_name>]
Usage: srvctl stop scan_listener [-netnum <network_number>] [-scannumber <scan_ordinal_number>] [-force]
Usage: srvctl relocate scan_listener -scannumber <scan_ordinal_number> [-netnum <network_number>] [-node <node_name>]
Usage: srvctl status scan_listener [[-netnum <network_number>] [-scannumber <scan_ordinal_number>] | -all] [-verbose]
Usage: srvctl enable scan_listener [-netnum <network_number>] [-scannumber <scan_ordinal_number>]
Usage: srvctl disable scan_listener [-netnum <network_number>] [-scannumber <scan_ordinal_number>]
Usage: srvctl modify scan_listener {-update|-endpoints [TCP:]<port>[/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]} [-netnum <network_number>] [-invitednodes <node_list>] [-invitedsubnets <subnet_list>]
Usage: srvctl update scan_listener
Usage: srvctl remove scan_listener [-netnum <network_number>] [-force] [-noprompt]
Usage: srvctl predict scan_listener -scannumber <scan_ordinal_number> [-netnum <network_number>] [-verbose]


SRVPOOL:

Usage: srvctl add srvpool -serverpool <pool_name> [-min <min>] [-max <max>] [-importance <importance>] [-servers "<server_list>" | -category <server_category>] [-force] [-eval] [-verbose]
Usage: srvctl config srvpool [-serverpool <pool_name>]
Usage: srvctl status srvpool [-serverpool <pool_name>] [-detail]
Usage: srvctl status server -servers "<server_list>" [-detail]
Usage: srvctl relocate server -servers "<server_list>" -serverpool <pool_name> [-force] [-eval] [-verbose]
Usage: srvctl modify srvpool -serverpool <pool_name> [-min <min>] [-max <max>] [-importance <importance>] [-servers "<server_list>" | -category <server_category>] [-force] [-eval] [-verbose]
Usage: srvctl remove srvpool -serverpool <pool_name> [-eval] [-verbose]


OC4J:

Usage: srvctl add oc4j [-verbose]
Usage: srvctl config oc4j
Usage: srvctl start oc4j [-node <node_name>] [-verbose]
Usage: srvctl stop oc4j [-force] [-verbose]
Usage: srvctl relocate oc4j [-node <node_name>] [-verbose]
Usage: srvctl status oc4j [-node <node_name>] [-verbose]
Usage: srvctl enable oc4j [-node <node_name>] [-verbose]
Usage: srvctl disable oc4j [-node <node_name>] [-verbose]
Usage: srvctl modify oc4j [-rmiport <oc4j_rmi_port>] [-httpport <oc4j_http_port>] [-verbose] [-force]
Usage: srvctl remove oc4j [-force] [-verbose]
Usage: srvctl predict oc4j [-verbose]


RHPSERVER:

Usage: srvctl add rhpserver -storage <base_path> -diskgroup <dg_name>
Usage: srvctl config rhpserver
Usage: srvctl start rhpserver [-node <node_name>]
Usage: srvctl stop rhpserver
Usage: srvctl relocate rhpserver [-node <node_name>]
Usage: srvctl status rhpserver
Usage: srvctl enable rhpserver [-node <node_name>]
Usage: srvctl disable rhpserver [-node <node_name>]
Usage: srvctl modify rhpserver [-port <rmi_port> [-force]]
Usage: srvctl remove rhpserver [-force]


HAVIP:

Usage: srvctl add havip -id <id> -address {<name>|<ip>} [-netnum <network_number>] [-description <text>] [-skip] [-homenode <node_name>]
Usage: srvctl config havip [-id <id>]
Usage: srvctl start havip -id <id> [-node <node_name>]
Usage: srvctl stop havip -id <id> [-node <node_name>] [-force]
Usage: srvctl relocate havip -id <id> [-node <node_name>] [-force]
Usage: srvctl status havip [-id <id>]
Usage: srvctl enable havip -id <id> [-node <node_name>]
Usage: srvctl disable havip -id <id> [-node <node_name>]
Usage: srvctl modify havip -id <id> [-address {<name>|<ip>} [-netnum <network_number>] [-skip]] [-description <text>] [-homenode <node_name>]
Usage: srvctl remove havip -id <id> [-force]


EXPORTFS:

Usage: srvctl add exportfs -name <expfs_name>  -id <id> -path <exportpath> [-clients <export_clients>] [-options <export_options>]
Usage: srvctl config exportfs [-name <expfs_name> | -id <havip id>]
Usage: srvctl start exportfs {-name <expfs_name> | -id <havip id> }
Usage: srvctl stop exportfs {-name <expfs_name> | -id <havip id> } [-force]
Usage: srvctl status exportfs [-name <expfs_name> |-id <havip id>]
Usage: srvctl enable exportfs -name <expfs_name>
Usage: srvctl disable exportfs -name <expfs_name>
Usage: srvctl modify exportfs -name <expfs_name> [-path <exportpath>] [-clients <export_clients>] [-options <export_options>]
Usage: srvctl remove exportfs -name <expfs_name> [-force]


RHPCLIENT:

Usage: srvctl add rhpclient -clientdata <file> [-diskgroup <dg_name> -storage <base_path>]
Usage: srvctl config rhpclient
Usage: srvctl start rhpclient [-node <node_name>]
Usage: srvctl stop rhpclient
Usage: srvctl relocate rhpclient [-node <node_name>]
Usage: srvctl status rhpclient
Usage: srvctl enable rhpclient [-node <node_name>]
Usage: srvctl disable rhpclient [-node <node_name>]
Usage: srvctl modify rhpclient [-clientdata <file>] [-port <rmi_port>] [-diskgroup <dg_name> -storage <base_path>]
Usage: srvctl remove rhpclient [-force]


ORACLEHOME:

Usage: srvctl start home -oraclehome <oracle_home> -statefile <state_file> -node <node_name>
Usage: srvctl stop home -oraclehome <oracle_home> -statefile <state_file> -node <node_name> [-stopoption <stop_options>] [-force]
Usage: srvctl status home -oraclehome <oracle_home> -statefile <state_file> -node <node_name>


FILESYSTEM:

Usage: srvctl add filesystem -device <volume_device> -path <mountpoint_path> [-volume <volume_name>] [-diskgroup <dg_name>] [-node <node_list> | -serverpool <serverpool_list>] [-user <user_list>] [-fstype {ACFS|EXT3|EXT4}] [-fsoptions <options>] [-description <description>] [-appid <application_id>] [-autostart {ALWAYS|NEVER|RESTORE}] [-auxvolumes <volume_device>]
Usage: srvctl config filesystem [-device <volume_device>]
Usage: srvctl start filesystem -device <volume_device> [-node <node_name>]
Usage: srvctl stop filesystem -device <volume_device> [-node <node_name>] [-force]
Usage: srvctl relocate filesystem -device <volume_device> [-node <node_name>] [-force] [-verbose]
Usage: srvctl status filesystem [-device <volume_device>] [-verbose]
Usage: srvctl enable filesystem -device <volume_device>
Usage: srvctl disable filesystem -device <volume_device>
Usage: srvctl modify filesystem -device <volume_device> [-user {[/+ | /-]<user> | <user_list>}] [-path <mountpoint_path>] [-node <node_list> | -serverpool <serverpool_list>] [-fsoptions <options>] [-description <description>] [-autostart  {ALWAYS|NEVER|RESTORE}] [-force]
Usage: srvctl remove filesystem -device <volume_device> [-force]
Usage: srvctl predict filesystem -device <volume_device> [-verbose]


VOLUME:

Usage: srvctl config volume [-volume <volume_name>] [-diskgroup <group_name>] [-device <volume_device>]
Usage: srvctl start volume {-volume <volume_name> -diskgroup <group_name> | -device <volume_device>} [-node <node_list>]
Usage: srvctl stop volume {-volume <volume_name> -diskgroup <group_name> | -device <volume_device>} [-node <node_list>] [-force]
Usage: srvctl status volume [-device <volume_device>] [-volume <volume_name>] [-diskgroup <group_name>] [-node <node_list> | -all]
Usage: srvctl enable volume {-volume <volume_name> -diskgroup <group_name> | -device <volume_device>} [-node <node_name>]
Usage: srvctl disable volume {-volume <volume_name> -diskgroup <group_name> | -device <volume_device>} [-node <node_name>]



GNS:

Usage: srvctl start gns [-loglevel <log_level>] [-node <node_name>] [-verbose]
Usage: srvctl stop gns [-node <node_name>] [-force] [-verbose]
Usage: srvctl config gns [-detail] [-subdomain] [-multicastport] [-node <node_name>] [-port] [-status] [-version] [-query <name>] [-list] [-clusterguid] [-clustername] [-clustertype] [-loglevel] [-network] [-verbose]
Usage: srvctl status gns [-node <node_name>] [-verbose]
Usage: srvctl enable gns [-node <node_name>] [-verbose]
Usage: srvctl disable gns [-node <node_name>] [-verbose]
Usage: srvctl relocate gns [-node <node_name>] [-verbose]
Usage: srvctl add gns {-vip {<vip_name> | <ip>} [-skip] [-domain <domain>] [-verbose] | -clientdata <filename>}
Usage: srvctl modify gns {-loglevel <log_level> | [-resolve <name>] [-verify <name>] [-parameter <name>:<value>[,<name>:<value>...]] [-vip {<vip_name> | <ip>} [-skip]] [-clientdata <filename>] [-verbose]}
Usage: srvctl remove gns [-force] [-verbose]
Usage: srvctl import gns -instance <filename>
Usage: srvctl export gns {-instance <filename> | -clientdata <filename>}
Usage: srvctl update gns {-advertise <name> -address <address> [-timetolive <time_to_live>] | -delete <name> [-address <address>] | -alias <alias> -name <name> [-timetolive <time_to_live>] | -deletealias <alias> | -createsrv <service> -target <target> -protocol <protocol> [-weight <weight>] [-priority <priority>] [-port <port_number>] [-timetolive <time_to_live>] [-instance <instance_name>] | -deletesrv <service_name> -target <target> -protocol <protocol> [-instance <instance_name>] | -createtxt <name> -target <target> [-timetolive <time_to_live>] [-namettl <name_ttl>] | -deletetxt <name> -target <target> | -createptr <name> -target <target> [-timetolive <time_to_live>] [-namettl <name_ttl>] | -deleteptr <name> -target <target>} [-verbose]


CVU:

Usage: srvctl add cvu [-checkinterval <check_interval_in_minutes>]
Usage: srvctl config cvu
Usage: srvctl start cvu [-node <node_name>]
Usage: srvctl stop cvu [-force]
Usage: srvctl relocate cvu [-node <node_name>]
Usage: srvctl status cvu [-node <node_name>]
Usage: srvctl enable cvu [-node <node_name>]
Usage: srvctl disable cvu [-node <node_name>]
Usage: srvctl modify cvu -checkinterval <check_interval_in_minutes>
Usage: srvctl remove cvu [-force]


MGMTDB:

Usage: srvctl add mgmtdb [-domain <domain_name>]
Usage: srvctl config mgmtdb [-verbose] [-all]
Usage: srvctl start mgmtdb [-startoption <start_option>] [-node <node_name>]
Usage: srvctl stop mgmtdb [-stopoption <stop_option>] [-force]
Usage: srvctl update mgmtdb -startoption <start_options>
Usage: srvctl status mgmtdb [-verbose]
Usage: srvctl enable mgmtdb [-node <node_name>]
Usage: srvctl disable mgmtdb [-node <node_name>]
Usage: srvctl modify mgmtdb [-pwfile <password_file_path>] [-spfile <server_parameter_file>]
Usage: srvctl remove mgmtdb [-force] [-noprompt] [-verbose]
Usage: srvctl getenv mgmtdb [-envs "<name>[,...]"]
Usage: srvctl setenv mgmtdb {-envs "<name>=<value>[,...]" | -env "<name=value>"}
Usage: srvctl unsetenv mgmtdb -envs "<name>[,..]"
Usage: srvctl relocate mgmtdb [-node <node_name>]


MGMTLSNR:

Usage: srvctl add mgmtlsnr [-endpoints "[TCP:]<port>[, ...][/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]"] [-skip]
Usage: srvctl config mgmtlsnr [-all]
Usage: srvctl start mgmtlsnr [-node <node_name>]
Usage: srvctl stop mgmtlsnr [-node <node_name>] [-force]
Usage: srvctl status mgmtlsnr [-verbose]
Usage: srvctl enable mgmtlsnr [-node <node_name>]
Usage: srvctl disable mgmtlsnr [-node <node_name>]
Usage: srvctl modify mgmtlsnr -endpoints "[TCP:]<port>[,...][/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]"
Usage: srvctl remove mgmtlsnr [-force]
Usage: srvctl getenv mgmtlsnr [ -envs "<name>[,...]"]
Usage: srvctl setenv mgmtlsnr { -envs "<name>=<val>[,...]" | -env "<name>=<value>"}
Usage: srvctl unsetenv mgmtlsnr -envs "<name>[,...]"


MOUNTFS:

Usage: srvctl add mountfs -name <mountfs_name> -path <mount_path> -exportserver <server_name> -exportpath <path> [-mountoptions <mount_options>] [-user <user>]
Usage: srvctl config mountfs [-name <mountfs_name>]
Usage: srvctl start mountfs -name <mountfs_name> [-node <node_list>]
Usage: srvctl stop mountfs -name <mountfs_name> [-node <node_list>] [-force]
Usage: srvctl status mountfs -name <mountfs_name>
Usage: srvctl enable mountfs -name <mountfs_name> [-node <node_list>]
Usage: srvctl disable mountfs -name <mountfs_name> [-node <node_list>]
Usage: srvctl modify mountfs -name <mountfs_name> [-path <mount_path>] [-exportserver <server_name>] [-exportpath <path>] [-mountoptions <mount_options>] [-user <user>]
Usage: srvctl remove mountfs -name <mountfs_name> [-force]

Comments

Popular posts from this blog

Oralce Pluggable Database

Pluggable database administration:-

Open all pluggable databases:
Connect to container database using oraenv
$. oraenv=DB_Name
$sqlplus "/as sysdba"
SQL> alter pluggable database all open;
Get pluggable database status:
SQL> select con_id, dbid, name, open_mode from v$pdbs;
Switch to Puggable database from container :
SQL> alter session set container = <Puggable_DB>;
Get status of Pluggable database
SELECT v.name, v.open_mode, NVL(v.restricted, 'n/a') "RESTRICTED", d.status
FROM v$pdbs v, dba_pdbs d WHERE v.guid = d.guid ORDER BY v.create_scn;
Get file location for pluggable database:
SQL>select file_name from dba_data_files;
Create table space for pluggable datatbase:
SQL> alter session set container=<Pluggable_DB>;
Session altered.
SQL> CREATE TABLESPACE TB_Name LOGGING DATAFILE '/<Path>/<File_Name>.dbf' SIZE 1024M REUSE AUTOEXTEND ON NEXT 8192K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
Set new t…

Oracle Golden Gate Basic Classic

Create environment
01. Source & target - Create GG tablespace.
02. Source & target - Create the GoldenGate Schema Owner
03. Grant privilege including DBA to GG schema owner
04. Add schema owner to global parameter file ./GLOBALS
05. Execute role set up script to create role GGS_GGSUSER_ROLE
06. Grant role GGS_GGSUSER_ROLE to GG user at both Source and target
Configure GG  Extract
01. Source and Target - Configure Manager Parameters
$ ggsci
GGSCI 1> EDIT PARAMS MGR
PORT 7809
DYNAMICPORTLIST 7810-7820
02. Source, create parameter file for Extract - ex1,
EXTRACT ex1
USERID <id>, PASSWORD <pwd>
EXTTRAIL /home/oracle/goldengate/dirdat/ex
TABLE <Schema>.*;
03. Source, configure Data Pump Parameters
EXTRACT dp1
USERID <id>, PASSWORD <pwd>
RMTHOST <hostname>, MGRPORT 7809
RMTTRAIL /home/oracle/goldengate/dirdat/rt
TABLE <schema>.*;
Target - Create check point table
$ ggsci
GGSCI 1> DBLOGIN USERID <id>, PASSWORD <pwd>
GGSCI 2>…

Oracle Daily SQL

Enable System-wide tracing: alter system set events '10046 trace name context forever,level 12'; Disabled in all sessions alter system set events '10046 trace name context off'; Session Tracing alter session set tracefile_identifier='10046'; alter session set timed_statistics = true; alter session set statistics_level=all; alter session set max_dump_file_size = unlimited; alter session set events '10046 trace name context forever,level 12'; crsctl for Oracle RAC ./crsctl start cluster ./crsctl check crs Make column to CLOB ALTER TABLE TABLE_NAME MODIFY (COLUMN_NAME LONG); ALTER TABLE TABLE_NAME MODIFY (COLUMN_NAME CLOB); RENAME <TABLE_NAME> TO <NEW_TABLE_NAME>; Rename column, change data type, drop column ALTER TABLE TABLE_NAME RENAME COLUMN COLUMN_NAME TO COLUMN_NAME1; ALTER TABLE TABLE_NAME MODIFY (COLUMN_NAME VARCHAR2(10)); ALTER TABLE TABLE_NAME DROP COLUMN COLUMN_NAME; Create Primary Key ALTER TABLE TABLE_NAME ADD CONSTRAINT CONSTRAINT_NAME PRIMARY KEY (COL…