Oracle: srvctl 命令小結

其實,官方文件中都已經說的很清楚了，之所以自己整理這麼一個tip,主要是方便自己使用。

[@more@]

Detailed Usage of "srvctl"

Keyword: Node,Database,Instance,Service,Nodeapp,Listener,ASM

# Author Date Purpose
# Leo 2005-06-29 Add "Overview" and add description for new features in DB 10.2
# Leo 2005-06-13 Add new examples
# Leo 2004-10-28 Add description for new command (start/stop/add/remove)
# Leo 2004-10-28 Add description for new option (ASM)
# Leo 2004-09-30 Add description for new command (status)
# Leo 2004-09-08 Creation

Reference:

0. Overview of SRVCTL for Administering Real Application Clusters

The Server Control (SRVCTL) utility is installed on each node by default. You can use SRVCTL
to start and stop the database and instances, manage configuration information, delete or move instances and services. SRVCTL also manages configuration information.

Some SRVCTL operations store configuration information in the Oracle Cluster Registry (OCR).
SRVCTL performs other operations, such as starting and stopping instances, by sending requests to the Oracle Clusterware process (CRSD), which then starts or stops the Oracle Clusterware resources.

To use SRVCTL, enter the srvctl command and its options in case sensitive syntax as described below:

srvctl add

srvctl config

srvctl enable

srvctl disable

srvctl start

srvctl stop

srvctl modify

srvctl relocate

srvctl status

srvctl getenv

srvctl setenv and unsetenv

srvctl remove

1. Grammar:

srvctl <command> <object> [<options]]

available <command>: enable/disable/start/stop/relocate/status/
add/remove/modify/getenv/setenv/unsetenv/config

avaliable <object>: database/instance/service/nodeapps/vip_range

show help: srvctl <command> <object> -h

2. Examples:

2.1 srvctl config

Available options: database|service|nodeapps|asm

Usage for backward compatibility

srvctl config: Display database name

srvctl config -V : Display the version of srvctl

# display the database info on the specfied node
srvctl config -p orcl -n rac1 :

Full usage:

# list all registered instance of the database
srvctl config database -d orcl
example output:

rac1 orcl1 /orabase/product/10.1.0/db_1
rac2 orcl2 /orabase/product/10.1.0/db_1

# show additional attributes
srvctl config database -d orcl -a
example output:

DB_NAME: orcl
ORACLE_HOME: /orabase/product/10.1.0/db_1
SPFILE: /oradata/orcl/spfileorcl.ora
DOMAIN: null
DB_ROLE: null
START_OPTIONS: null

# show tns entries
srvctl config database -d orcl -t

Example client-side TNS entry for service orcltest:

orcltest =
(description=
(address=(protocol=tcp)(host=db_vip)(port=dedicated_port))
(connect_data=
(service_name=orcltest)
(failover_mode=
(type=select)
(method=basic)
)
)
)

# Display help
srvctl config service -h

# Display service's information
srvctl config service -d orcl -s <service_name>

# display help
srvctl config nodeapps -h

# display node's information
srvctl config nodeapps -n rac1

example output:
rac1 orcl1 /orabase/product/10.1.0/db_1

# display VIP configuration
srvctl config nodeapps -n rac1 -a

# display GSD configuration
srvctl config nodeapps -n rac1 -g

# display OSD configuration
srvctl config nodeapps -n rac1 -s

# display Listener configuration
srvctl config nodeapps -n rac1 -l

2.2 srvctl status

Available options: database|instance|service|nodeapps|asm

# Display help for database level
srvctl status database -h

# Display instance's running status on each node
srvctl status database -d orcl

example output:
Instance orcl1 is(not) running on node rac1
Instance orcl2 is(not) running on node rac2

# include disabled applications
srvctl status database -d orcl -f

# verbos output
srvctl status database -d orcl -v

# Additional information for EM Console
srvctl status database -d orcl -S EM_AGENT_DEBUG

# Additional information for EM Console
srvctl status database -d orcl -i orcl1 -S EM_AGENT_DEBUG

# Display help for instance level
srvctl status instance -h

# display appointed instance's running status
srvctl status instance -d orcl -i orcl1

# Display help for node level
srvctl status nodeapps -h

# Display all app's status on the node xxx
srvctl status nodeapps -n <node_name>

# Display ASM instance's status on the node xxx (new)
srvctl status asm -n <node_name>

2.3 srvctl start

I think maybe it's one of the most frequently used commands as well as 'srvctl stop'.

Available options: database|instance|service|nodeapps|asm

# Start database
srvctl start database -d orcl -o nomount
srvctl start database -d orcl -o mount
srvctl start database -d orcl -o open

# Grammar for start instance
srvctl start instance -d [db_name] -i [instance_name]
-o [start_option] -c [connect_str] -q

# Start all instances on the all nodes
srvctl start instance -d orcl -i orcl1,orcl2,...

# Start ASM instance
srvctl start ASM -n [node_name] -i asm1 -o open

# Start all apps in one node
srvctl start nodeapps -n [node_name]

# New: srvctl can manage listener's startup in DB 10.2

srvctl start listener -n <node_name>

2.4 srvctl stop

I think maybe it's also one of the most frequently used
commands as well as 'srvctl start'.

Available options: database|instance|service|nodeapps|asm

# Stop database
srvctl stop database -d orcl -o normal
srvctl stop database -d orcl -o immediate
srvctl stop database -d orcl -o abort

# Grammar for start instance
srvctl stop instance -d [db_name] -i [instance_name]
-o [start_option] -c [connect_str] -q

# Stop all instances on the all nodes
srvctl stop instance -d orcl -i orcl1,orcl2,...

# Stop ASM instance
srvctl stop ASM -n [node_name] -i asm1 -o [option]

# Stop all apps in one node
srvctl stop nodeapps -n [node_name]

# New: srvctl can manage listener's stop in DB 10.2
srvctl stop listener -n <node_name>

2.5 srvctl add

Available options: database|instance|service|nodeapps|asm

Description:

Add a configuration to your cluster database configuration. "srvctl add service" adds services to a database and assigns them to instances. You can use "srvctl add service" to configure the Transparent Application Failover (TAF) policy for a service.

# Add database

2.6 srvctl remove

Available options: database|instance|service|nodeapps|asm

Description:

Removes the named object from the cluster environment.

# Remove database

2.7 srvctl modify

...