OracleGoldenGate版本升级时的注意点(二)
e OGG ddl trigger
10. Disconnect all sessions that ever issued DDL. Otherwise the database might generate ORA* errors
11. Run the ddl_setup script as sysdba. You will be prompted for the name of the Oracle GoldenGate
DDL schema.
12. Run the role_setupscript to recreate the Oracle GoldenGate DDL role.
13. Grant the role that you created to all Oracle GoldenGate users under which the
following Oracle GoldenGate processes run:Extract, Replicat, GGSCI, and Manager.
You might need to make multiple grants ifthe processes have different user names.
14. Run the ddl_enable.sqlscript to enable the DDL trigger.
15. Start the OGG process back
16. Resume doing DDL changes to the db.