Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Mandatory Scripts for GoldenGate Configuration

JhilMar 24 2024

Dear Experts,

We want to configure GoldenGate Setup between Oracle to Oracle

Source is Non CDB ( Standard Architecture Database) : 19.22

And Target id PDB (Multitenant) : 19.3

GoldenGate Version is 21c

Do we need to execute following 3 scripts at Source DB and Target DB ? , are these mandatory ?

In my case Target is PDB, Any additional changes are required ?

SQL>@marker_setup.sql;
SQL>@ddl_setuo.sql;
SQL>@role_setup.sql;
SQL> Grant  GGS_GGSUSER_ROLE to ggadmin;
SQL>@ddl_enable.sql;
SQl>@?/rdbms/admin.utlspadv.sql;
SQL> exec DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILIGE (grantee => ‘ggadmin’, privilege_type => ‘capture’,
           grant_optional_privileges => ‘*’); 

Kindly update

Thanks

Comments
Post Details
Added on Mar 24 2024
0 comments
41 views