Table of Contents

Search

  1. Preface
  2. IDR-000000 to IDR-000704
  3. IDR-008001 to IDR-008006
  4. IDR-009001 to IDR-009055
  5. IDR-010002 to IDR-010812
  6. IDR-020001 to IDR-020264
  7. IDR-030001 to IDR-031041
  8. IDR-050001 to IDR-053222
  9. IDR-060002 to IDR-060123
  10. IDR-070002 to IDR-070351
  11. IDR-100001 to IDR-100030
  12. IDR-110030 to IDR-110031
  13. IDR-120001 to IDR-120007
  14. IDR-140001 to IDR-140054
  15. IDR-150001 to IDR-150014
  16. QADPTR-10001 to QADPTR-16001

IDR- 070108

IDR-
070108

[ERROR] Could not disable triggers on the target because of an OTL error.
Data Replication can suppress database triggers for Oracle targets that use Oracle 10.2.0.5 or 11.2.0.2, or later 10.2 or 11.2 patches so that these triggers do not become active on target objects during replication. The Applier attempted to disable target triggers but encountered an OTL error. The Applier logs information about the OTL error in the next log message.
Perform one of the following actions:
  • Ensure that the Oracle target uses patch that supports disabling of triggers. For other target versions, set the apply.disable_target_triggers runtime parameter to 0 in the configuration.
  • Grant administrative privileges to the target database user by running the DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE on Oracle 10.2.0.5 and DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE on Oracle 11.2.0.2 or later.

0 COMMENTS

We’d like to hear from you!