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 ;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/756652/viewspace-694081/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/756652/viewspace-694081/