WARNING: This web is not used anymore. Please use PDBService.Service_Definition instead!

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:
    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);

Edit | Attach | Watch | Print version | History: r6 < r5 < r4 < r3 < r2 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r6 - 2008-01-30 - LucaCanali
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback