Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

GoldenGate configuration new setup

JhilMay 6 2024

Dear Experts,

We've done Installation of Oracle GoldenGate Version 21.
Source and Target - Both are Standalone PDBs. (19c) and configured on ASM Storage.

We want to complete the configuration for 19c Oracle Database.

>> Do i want to run following all commands at CDB Level
===================================
exec dbms_goldengate_auth.grant_admin_privilege('C##GGS_ADMIN','*', container => 'ALL');

SQL> EXEC dbms_goldengate_auth.grant_admin_privilege('ggadmin');

SQL> exec DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE (grantee=>'C##GGS_ADMIN', privilege_type=>'capture',grant_select_privileges=>true, do_grants=>TRUE);

SQL> exec DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE (grantee=>'C##GGS_ADMIN', privilege_type=>'apply',grant_select_privileges=>true, do_grants=>TRUE);

SQL> exec DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE (grantee=>'C##GGS_ADMIN',
privilege_type=>'*',grant_select_privileges=>true, do_grants=>TRUE);

Thanks.

Comments
Post Details
Added on May 6 2024
1 comment
146 views