| DDL synchronisation failed with error [message #606688] |
Tue, 28 January 2014 03:56  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
