Ittichai: Created page with "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 pref..."

2012-05-19T20:24:19Z

Created page with "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 pref..."

New page

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
<pre>
srvctl add service -d db_unique_name -s service_name -r preferred_list [-a available_list] [-P TAF_policy]
</pre>

The TAF policy (NONE, BASIC, or PRECONNECT). If you choose PRECONNECT, it creates a service_Preconnect.

Update
<pre>
srvctl add service -d db_unique_name -s service_name -u [-r new_preferred_inst | -a new_available_inst]
</pre>

Reference: http://docs.oracle.com/cd/B28359_01/rac.111/b28254/srvctladmin.htm#i1008562

Sample:
<pre>
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
</pre>

11.2
<pre>
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
</pre>

http://docs.oracle.com/cd/E11882_01/server.112/e25494/restart005.htm#i1008562

<pre>
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;
</pre>

Srvctl add service in Oracle 11g - Revision history

Ittichai: Created page with "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 pref..."

Ittichai: Created page with "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 pref..."