using Oracle RDS 12.2 database as a GoldenGate REPLICAT target

Question

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.

Answer

known issue in Oracle 12.2 prior to the April 2019 release  
  
1.  use engine version 12.2.0.1.ru-2019-04.rur-2019-09-04.r1  
2. replace DBMS_GOLDENGATE_AUTH with RDSADMIN.RDSADMIN_DBMS_GOLDENGATE_AUTH (with same arguments as DBMS_GOLDENGATE_AUTH)

```
 SQL> BEGIN RDSADMIN.RDSADMIN_DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE (grantee=>'OGGADM',grant_select_privileges=>true, do_grants=>TRUE); end ;
 2  /

PL/SQL procedure successfully completed.
```

using Oracle RDS 12.2 database as a GoldenGate REPLICAT target

Relevant content