Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\db\latest\dg\dg_post

Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\db\latest\dg\dg_post_creation.sql

Rem drv: <create type="post_creation"/>
Rem
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/latest/dg/dg_post_creation.sql /st_emdbsa_11.2/1 2009/01/27 16:16:43 mmootha Exp $
Rem
Rem dg_post_creation.sql
Rem
Rem Copyright (c) 2002, 2008, Oracle and/or its affiliates. All rights reserved.
Rem
Rem    NAME
Rem      dg_post_creation.sql - Register job commands for DG
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    ngade       09/25/08 -  "Code slap 10.2.0.5.0 -> 11.2SA"
Rem    ngade       03/19/07 - Register rowser handler for loader
Rem    ngade       05/24/06 - add switchoverJob 
Rem    rimmidi     05/07/08 - Code swap 11g-10.2.0.4
Rem    sjconnol    09/12/05 - reloadObserverMetric
Rem    kramarat    07/27/05 - Add new RepManager header 
Rem    sjconnol    06/28/05 - sjconnol_bug-4303735
Rem    sjconnol    05/18/05 - Creation
Rem

BEGIN

mgmt_jobs.register_command('prepareRestartInput',
                         'oracle.sysman.db.dg.util.PrepareRestartInput',
                         MGMT_JOBS.LONG_RUNNING_COMMAND);

mgmt_jobs.register_command('reloadObserverMetric',
                         'oracle.sysman.db.dg.util.ReloadObserverMetric',
                         MGMT_JOBS.LONG_RUNNING_COMMAND);

mgmt_jobs.register_command('reloadTargetPropertiesDG',
                         'oracle.sysman.db.dg.util.ReloadTargetProperties',
                         MGMT_JOBS.LONG_RUNNING_COMMAND);

mgmt_jobs.register_command('switchoverJob',
                         'oracle.sysman.db.dg.SwitchoverJob',
                         MGMT_JOBS.LONG_RUNNING_COMMAND);

mgmt_jobs.register_command('prepareSwitchoverJob',
                         'oracle.sysman.db.dg.PrepareSwitchoverJob',
                         MGMT_JOBS.LONG_RUNNING_COMMAND);

mgmt_jobs.register_command('postSwitchoverJob',
                         'oracle.sysman.db.dg.PostSwitchoverJob',
                         MGMT_JOBS.LONG_RUNNING_COMMAND);

END;
/

ALTER SESSION SET CONSTRAINTS = IMMEDIATE;
COMMIT;

-- PL/SQL Procedure used by loader to handle table inserts for mgmt_ha_backup.
BEGIN
    emd_loader.add_plsql_handler_for_rowset(
        p_rowset_name => 'MGMT_HA_DG_TARGET_SUMMARY',
        p_proc_name => 'mgmt_ha_dg.update_mgmt_ha_dg_target_sum');
    COMMIT;
END;
/

SET DEFINE ON

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de