Shulou(Shulou.com)06/01 Report--

SRVCTL is an ORACLE RAC cluster configuration management tool that can manage Database, Instance, ASM, Service, Listener and Node Application,Node Application, including GSD,ONS,VIP

1 SRVCTL Config

Db

Srvctl config database

Srvctl config database-a

Srvctl config database-db dbname

Node Application (mainly VIP information)

Srvctl config nodeapps-n hostnode (hostname)

Srvctl config nodeapps-a

Srvctl config nodeapps-n hostnode-g (- g GSD)

Srvctl config nodeapps-n hostnode-s (- s ONS)

Srvctl config nodeapps-n hostnode-l (- l Listener)

Srvctl config asm-n hostnode

Srvctl config service-d dbname-a

Srvctl config service-d dbname-s service_name

Srvctl config service-d dbname-s service_name-a

2 SRVCTL Add

-m database domain name format such as "us.oracle.com"

The specified database domain name must match the DB_DOMAIN and DB_NAME parameters in the database INIT.ORA or SPFILE.

-d specified database name

-n instance node name

-o $ORACLE_HOME (used to determine command paths such as lsnrctl and Oracle)

-p SPFILE file name

-S service name

-r preferred instance name

-an alternate instance name

-P TAF strategy

Srvctl add database-d-o $ORACLE_HOME-p spfile_dest

Srvctl add instance-d dbname-I inst1-n host node-o $ORACLE_HOME

Srvctl add service-d dbname-s Service_name-r "inst1,inst2"-a "inst3,inst4"-P basic

3 SRVCTL enable/disable

By default, databases, instances, services, and ASM are all started automatically with the startup of CRS. Sometimes this feature can be turned off first for maintenance needs.

Srvctl enable database-d dbname

Srvctl disable database-d dbname

Srvctl enable database-d dbname-I inst1

Srvctl disable database-d dbname-I inst-s service_name

4 、 SRVCTL Modify

Modify the node configuration information of the instance, these changes will take effect after the next restart of the program, and the modified information will be saved permanently.

Srvctl modify instance-d database_name-I instance_name-n host node

5 、 SRVCTL Remove

Srvctl remove database-d database_name [- f]

Srvctl remove instance-d database_name-I instance_name [- f]

6. SRVCTL Start command

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]

-o options for startup commands passed directly in SQL*Plus, which can include PFILE

-c use SQL*Plus to connect to the connection string of the database instance

Srvctl start database-d dbname

Srvctl stop database-d dbname-c "SYS/SYS_password as SYSDBA"

Srvctl start instance-d dbname-I inst1,inst2

Start and stop monitoring

Srvctl stop listener-n host node

Srvctl start listener-n host node

Http://blog.itpub.net/27661381/viewspace-1243149/

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.