Srvctl add service in Oracle 11g
Jump to navigation
Jump to search
The *srvctl add service* adds a database service to the Oracle Restart configuration. Creates the database service if it does not exist. This method of creating a service is preferred over using the DBMS_SERVICE PL/SQL package.
11.1 Add
srvctl add service -d db_unique_name -s service_name -r preferred_list [-a available_list] [-P TAF_policy]
The TAF policy (NONE, BASIC, or PRECONNECT). If you choose PRECONNECT, it creates a service_Preconnect.
Update
srvctl add service -d db_unique_name -s service_name -u [-r new_preferred_inst | -a new_available_inst]
Reference: http://docs.oracle.com/cd/B28359_01/rac.111/b28254/srvctladmin.htm#i1008562
Sample:
srvctl add service -d PMDW -s PMDW_APEX -r PMDW3 -a PMDW1,PMDW2 -P BASIC begin dbms_service.modify_service ( SERVICE_NAME => 'PMDW_APEX', GOAL => DBMS_SERVICE.GOAL_SERVICE_TIME, aq_ha_notifications => TRUE, FAILOVER_METHOD => 'BASIC', FAILOVER_TYPE => 'SELECT', FAILOVER_RETRIES => 20, FAILOVER_DELAY => 15, CLB_GOAL => DBMS_SERVICE.CLB_GOAL_SHORT ); end; / srvctl add service -d PMDW -s PMDW_APEX -u -r PMDW3 -a PMDW1,PMDW2
11.2
srvctl add service -d db_unique_name -s service_name [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC | MANUAL}] [-e {NONE | SESSION | SELECT}] [-m {NONE | BASIC}] [-w integer] [-z integer] [-j {SHORT | LONG}] [-B {SERVICE_TIME | THROUGHPUT | NONE}] [-q {TRUE | FALSE}] -t edition_name
http://docs.oracle.com/cd/E11882_01/server.112/e25494/restart005.htm#i1008562
srvctl add service -d PMDW -s PMDW_APEX -r PMDW1 -a PMDW2,PMDW3 -e SELECT -m BASIC -z 20 -w 15 -j SHORT -B SERVICE_TIME srvctl start service -d PMDW -s PMDW_APEX SELECT * FROM dba_services;