按照官方文档说明,依次完成stream用户和表空间,DB——LINK,archivelog mode、初始化参数以及stream pool的配置,
然后启动OEM配置全库双向同步,发现在任务第一次时日志中报大量的错误,大多数是已经冲突错误,下面是NOD2(备库)上的错误,请高手指点下。
ORA-39111: Dependent object type TRIGGER:"SYSMAN"."EM_UPDATE_COLLECTION" skipped, base object type VIEW:"SYSMAN"."MGMT_METRIC_COLLECTIONS" already exists
ORA-39111: Dependent object type TRIGGER:"SYSMAN"."EM_DELETE_COLLECTION" skipped, base object type VIEW:"SYSMAN"."MGMT_METRIC_COLLECTIONS" already exists
ORA-39111: Dependent object type TRIGGER:"SYSMAN"."EM_INSERT_COLL_ITEM_PROPERTY" skipped, base object type VIEW:"SYSMAN"."MGMT_COLLECTION_PROPERTIES" already exists
ORA-39111: Dependent object type TRIGGER:"SYSMAN"."EM_UPDATE_COLL_ITEM_PROPERTY" skipped, base object type VIEW:"SYSMAN"."MGMT_COLLECTION_PROPERTIES" already exists
ORA-39111: Dependent object type TRIGGER:"SYSMAN"."EM_DELETE_COLL_ITEM_PROPERTY" skipped, base object type VIEW:"SYSMAN"."MGMT_COLLECTION_PROPERTIES" already exists
ORA-39111: Dependent object type TRIGGER:"SYSMAN"."MEMBERSHIPS_INSERT_TRIGGER" skipped, base object type VIEW:"SYSMAN"."MGMT_TARGET_MEMBERSHIPS" already exists
ORA-39111: Dependent object type TRIGGER:"SYSMAN"."EM_ADAPTIVE_THRESHOLDS_INS" skipped, base object type VIEW:"SYSMAN"."EM_ADAPTIVE_THRESHOLDS" already exists
ORA-39111: Dependent object type TRIGGER:"SYSMAN"."SPACE_METRICS_PURGE_TRIGGER" skipped, base object type VIEW:"SYSMAN"."MGMT_SPACE_PURGE" already exists
Processing object type DATABASE_EXPORT/SCHEMA/EVENT/TRIGGER
ORA-31684: Object type TRIGGER:"SYSMAN"."MGMT_STARTUP" already exists
Processing object type DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW
ORA-31685: Object type MATERIALIZED_VIEW:"SYSMAN"."MGMT_ECM_MD_ALL_TBL_COLUMNS" failed due to insufficient privileges. Failing sql is:
CREATE MATERIALIZED VIEW "SYSMAN"."MGMT_ECM_MD_ALL_TBL_COLUMNS" ("METADATA_ID", "TARGET_TYPE", "SNAPSHOT_TYPE", "TABLE_NAME", "NAME", "UI_NAME", "TYPE", "TYPE_FORMAT", "UI_ON", "COMPARE_ON", "COMPARE_UI_ON", "HISTORY_ON", "HISTORY_UI_ON", "IS_KEY", "IS_CONTEXT", "IS_SUMMARY", "IS_CHILD_LINK", "LINK_COLUMN_NAME", "COL_ORDER", "SOURCE_TABLE_NAME") USING ("MGMT_ECM_MD_ALL_TBL
ORA-31684: Object type MATERIALIZED_VIEW:"SH"."CAL_MONTH_SALES_MV" already exists
ORA-31684: Object type MATERIALIZED_VIEW:"SH"."FWEEK_PSCAT_SALES_MV" already exists
Processing object type DATABASE_EXPORT/SCHEMA/JOB
ORA-39083: Object type JOB failed to create with error:
ORA-12718: operation requires connection as SYS
Failing sql is:
BEGIN SYS.DBMS_IJOB.SUBMIT( JOB=> 4001, LUSER=> 'SYS', PUSER=> 'APEX_030200', CUSER=> 'APEX_030200', NEXT_DATE=> TO_DATE('2012-03-29 18:18:25', 'YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'sysdate + 8/24', BROKEN=> FALSE, WHAT=> 'wwv_flow_cache.purge_sessions(p_purge_sess_older_then_hrs => 24);', NLSENV=> 'NLS_LANGUAGE=''AMERICAN'' NLS_TERRITORY=''AMERICA'' NLS_CURRENCY=''$'' NLS_ISO_CURRENCY
ORA-39083: Object type JOB failed to create with error:
ORA-12718: operation requires connection as SYS
Failing sql is:
BEGIN SYS.DBMS_IJOB.SUBMIT( JOB=> 4002, LUSER=> 'SYS', PUSER=> 'APEX_030200', CUSER=> 'APEX_030200', NEXT_DATE=> TO_DATE('2012-03-29 14:09:50', 'YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'sysdate + 10/1440', BROKEN=> FALSE, WHAT=> 'wwv_flow_mail.push_queue(wwv_flow_platform.get_preference(''SMTP_HOST_ADDRESS''),wwv_flow_platform.get_preference(''SMTP_HOST_PORT''));', NLSENV=> 'NLS_LANGUAGE='
ORA-39083: Object type JOB failed to create with error:
ORA-12718: operation requires connection as SYS
Failing sql is:
BEGIN SYS.DBMS_IJOB.SUBMIT( JOB=> 3, LUSER=> 'SYS', PUSER=> 'SYSMAN', CUSER=> 'SYSMAN', NEXT_DATE=> TO_DATE('2012-03-29 14:04:51', 'YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'sysdate + 1 / (24 * 60)', BROKEN=> FALSE, WHAT=> 'EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS();', NLSENV=> 'NLS_LANGUAGE=''AMERICAN'' NLS_TERRITORY=''AMERICA'' NLS_CURRENCY=''$'' NLS_ISO_CURRENCY=''AMERICA'' NLS_NUMERIC_
Processing object type DATABASE_EXPORT/SCHEMA/DIMENSION
ORA-31684: Object type DIMENSION:"SH"."CUSTOMERS_DIM" already exists
ORA-31684: Object type DIMENSION:"SH"."PRODUCTS_DIM" already exists
ORA-31684: Object type DIMENSION:"SH"."TIMES_DIM" already exists
ORA-31684: Object type DIMENSION:"SH"."CHANNELS_DIM" already exists
ORA-31684: Object type DIMENSION:"SH"."PROMOTIONS_DIM" already exists
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/AUDIT
Job "STRMADMIN"."SYS_IMPORT_FULL_01" completed with 8095 error(s) at 14:08:28