ORA-04098: trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid and failed re-validation

运行OGG DDL @ddl_setup.sql 时报错，提示以下信息：

DDL TRIGGER RUNNING STATUS
----------------------------------------------------------------------
ENABLED
FROM "OGG" ."GGS_SETUP"
            *
ERROR at line 2:
ORA-00942: table or view does not exist

FROM "OGG" ."GGS_SETUP"
            *
ERROR at line 2:
ORA-00942: table or view does not exist

FROM "OGG" ."GGS_SETUP"
            *
ERROR at line 2:
ORA-00942: table or view does not exist

运行grant GGS_GGSUSER_ROLE to ogg;
提示如下错误：

 

SQL> grant GGS_GGSUSER_ROLE to ogg
  2  ;
grant GGS_GGSUSER_ROLE to ogg
*
ERROR at line 1:
ORA-04098: trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid and failed re-validation

解决方法：
查看资料说是权限问题，但是给ogg 用户赋予dba 权限了，后来知道即使有dba 权限但是ogg 用户权限是要单独赋予的。

 

先执行下面脚本
SQL> @ddl_disable.sql

Trigger altered.
然后运行后面的脚本正常。
SQL> @ddl_setup.sql

SQL> GRANT CREATE TABLE,CREATE SEQUENCE TO OGG;

Grant succeeded.

提示创建ogg 用户时赋予以下权限：

grant connect,resource,dba,create table,create sequence to ogg;