ORA-12801 AND ORA-01031 ONLY WHEN OGG DDL TRIGGER IS ENABLED [ID 1280235.1]

前兩天部署了套golden gate環境，源庫的一個批量居然報錯了，內容是create table as select /*+paralle*/，當時給使用者授權“grant alter session to xxx”問題解決。今天開發人員要問題原因，查了下metalink，是由於golden gate bug導致。解決方法就是授於alter session許可權或者 alter trigger sys.GGS_DDL_TRIGGER_BEFORE disable;

 

golden gate版本：

Oracle GoldenGate v11.1.1.0.0 for Oracle 11g on Linux x86-64 (61 MB)

In this Document
  Symptoms
  Cause
  Solution
  References

---

Applies to:

Oracle GoldenGate - Version: 11.1.1.0.4 and later   [Release: 11.1.1 and later ]
Information in this document applies to any platform.

Symptoms

create index DDL, called from a procedure, failed with error:

ORA-12801: error signaled in parallel query server P001
ORA-01031: insufficient privileges

After disabling the ogg trigger, the DDL runs successfully.
The schema that issues the command has DBA privilege.

Cause

This is OGG bug 10364074.

Solution

Bug 10364074 is fixed in 11.1.1.0.13 and later. When applying the patch DDL trigger needs to be recompiled with NORMAL.

Workaround:  grant alter session to ;