GG version 10. support Oracle database 11r2. database user is GGUSER. where DDL replication installed.
Now i have New version of GG.
GG version 11r2 also support same DB. so when i install DDL_SETUP.sql for GGADMIN user
it error out like below.
Oracle GoldenGate DDL Replication setup:
* INITIALSETUP used, but DDLREPLICATION package exists under different schema (GGSUSER). Please use ddl_remove.sql to
remove DDL installation from that schema first
ORA-06512: at line 26
can anybody help on it.
DDL script is specific to each OGG version.
You need to follow-up upgrade guide. Basically, this would be removing the old DDL trigger tables running ddl_remove.sql in 10g and install the new trigger.