Home » Server Options » Replication » DDL synchronisation failed with error (11.2.0.3.9 Linux x86_64, OGG 11.2.1.0.3)
DDL synchronisation failed with error [message #606688] Tue, 28 January 2014 03:56 Go to next message
sanei05
Messages: 104
Registered: September 2008
Senior Member
Hi,
I am implementing DDL synchronization for golden gate between linux(source) and windows box (target) . Version of OGG

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21


As part of configuring DDL synchronization, I was executing ddl_setup script and but it failed. So, I checked for the log file and found it was due to insufficient privileges.

Now, I am trying to give privileges to my gg_admin user, but it fails with below error message.

SQL> grant create any sequence to gg_admin;
grant create any sequence to gg_admin
*
ERROR at line 1:
ORA-04098: trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid and failed re-validation


In ddl_setup_set.txt file, I find the below error messages.

BEGIN "GG_ADMIN" .initial_setup; END;

*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "GG_ADMIN.INITIAL_SETUP", line 477
ORA-06512: at line 1


No errors.

Warning: Package Body created with compilation errors.



Even if I run ddl_Remove.sql command, the trigger will be in INVALID state. Kindly advise how to overcome this error without dropping the gg_Admin user.
Re: DDL synchronisation failed with error [message #606731 is a reply to message #606688] Tue, 28 January 2014 07:02 Go to previous message
sanei05
Messages: 104
Registered: September 2008
Senior Member
Hi,

I followed below steps and it solved the problem.

1. Disable the trigger.
2. Give necessary privileges and
3. Rerun the ddl_setup script again.

Hope my note would help for other guys who may come across such errors .
Thanks
Previous Topic: synchronise data
Next Topic: Introduce index post replication
Goto Forum:
  


Current Time: Thu Mar 28 03:47:20 CDT 2024