Add services to the DB and CRS

Setup Oracle 10g services on RAC. Two steps are required (crs registration + dbms_service stored procedure). The first step will create the service in the DB and register it with CRS. The second step is used to add TAF and clb_goal to the service in step 2. Please use the manual procedure detailed here and do not use DBCA to change service configuration.

Example (please edit the clb_goal, service name and TAF parameters appropriately):

• Prerequisite: create the tnsnames.ora alias for the service and wait till it has been propagated (otherwise you'll get racmon errors)

• Step 1 from the OS:

    srvctl add service -d ` echo ${ORACLE_SID%r*}r` -s pdb_htmldb -r INST1,INST2 -a INST3,INST4  # if relevant
    srvctl start service -d ` echo ${ORACLE_SID%r*}r` -s pdb_htmldb

• Step 2 from the DB:

    begin
    DBMS_SERVICE.MODIFY_SERVICE(service_name => 'pdb_htmldb',failover_method => 
                       DBMS_SERVICE.FAILOVER_METHOD_BASIC,failover_type =>
                       DBMS_SERVICE.FAILOVER_TYPE_SELECT,failover_retries => 180,
                       failover_delay => 5, clb_goal => DBMS_SERVICE.CLB_GOAL_LONG);
    end;
    /