srvctl 命令
add Add a database or instance
config List the configuration for the database or instance
getenv List the environment variables in the SRVM configuration
modify Modify the instance configuration
remove Remove the database or instance
setenv Set the environment variable in the SRVM configuration
start Start the database or instance
status Status of the database or instance
stop Stop the database or instance
unsetenv Set the environment variable in the SRVM configuration to unspecified
database (db) Operation refers to objects for the database
instance (inst) Operation refers to objects for the instances
-h Help
-i instance
-n node
-f force
-d Database name
-h Print usage
-i Comma-separated list of instance names for the operation
-n Node name or comma separated node list
srvctl add database -d database_name [-m domain_name] -o oracle_home [-s spfile]
srvctl add instance -d database_name -i instance_name -n node_name
To add a new database:
srvctl add database -d mydb -o /ora/ora9 注册实例
To add named instances to a database:
srvctl add instance -d mydb -i mydb01 -n gm01
srvctl add instance -d mydb -i mydb02 -n gm02
srvctl add instance -d mydb -i mydb03 -n gm03
Displays a list of configured databases.
srvctl config database -d database_name 查看数据库配置信息
srvctl getenv database -d database_name [-t name[,name,...]]
srvctl getenv instance -d database_name -i instance_name [-t name[,name,...]]
srvctl getenv database -d mydb 查看环境变量
srvctl modify instance -d database_name -i instance_name -n node_name
srvctl modify instance -d mydb -n my_new_node
srvctl remove database -d database_name [-f]
srvctl remove instance -d database_name -i instance_name [-f]
srvctl remove database -d mydb 移除实例
srvctl remove instance -d mydb -i mydb01
srvctl remove instance -d mydb -i mydb02
srvctl remove instance -d mydb -i mydb03
srvctl setenv database -d database_name -t name=value [,name=value,...]
srvctl setenv instance -d database_name [-i instance_name] -t name=value
[,name=value,...]
srvctl setenv database -d mydb -t LANG=en
srvctl start database -d database_name [-o start_options] [-c connect_string]
srvctl start instance -d database_name -i instance_name [,instance_name-list]
[-o start_options] [-c connect_string]
To start the database and all enabled instances: 启动实例
srvctl start database -d mydb
To start instances:
srvctl start instance -d mydb -i mydb1,mydb4
srvctl status database -d database_name 数据库状态
srvctl status instance -d database_name -i instance_name [,instance_name-list]
Status of the database and all instances:
srvctl status database -d mydb
Status of named instances:
srvctl status instance -d mydb -i mydb1,mydb2
srvctl stop database -d database_name [-o stop_options] [-c connect_string]
srvctl stop instance -d database_name -i instance_name [,instance_name_list] [-o
stop_options][-c connect_string]
Stop the database all instances:
srvctl stop database -d mydb
Stop named instances:
srvctl stop instance -d mydb -i mydb1
9i RAC 安装