Has anyone had experience or encountered problems with using Oracle RDS 12.2 database as a GoldenGate REPLICAT target?
While configuring the GoldenGate user on the target system, I am unable to complete the user privileges setup with DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE.
Executed as the database master account user:
SQL> begin
2 DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE (grantee=>'OGGADM',privilege_type=>'apply', grant_select_privileges=>true, do_grants=>TRUE);
3 end ;
4 /
begin
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_XSTREAM_AUTH_IVK", line 3666
ORA-06512: at "SYS.DBMS_XSTREAM_AUTH_IVK", line 93
ORA-06512: at "SYS.DBMS_XSTREAM_AUTH_IVK", line 84
ORA-06512: at "SYS.DBMS_XSTREAM_AUTH_IVK", line 123
ORA-06512: at "SYS.DBMS_XSTREAM_AUTH_IVK", line 3649
ORA-06512: at "SYS.DBMS_GOLDENGATE_AUTH", line 49
ORA-06512: at line 2
SQL> select version from v$instance ;
VERSION
-----------------
12.2.0.1.0
SQL>
This completes successfully in AWS RDS 12.1.