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.

Rakesh Reddy · Answer

Hello Customer,

You can use below command to grant the privileges required for Goldengate on Target DB. Same has been documented in AWS document(https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.OracleGoldenGate.setting-up.html#Appendix.OracleGoldenGate.Target.Privileges)

```
EXEC rdsadmin.rdsadmin_dbms_goldengate_auth.grant_admin_privilege (
    grantee                 => 'OGGADM1',
    privilege_type          => 'apply',
    grant_select_privileges => true, 
    do_grants               => TRUE);
```
Note: replace OGGADM1 with your actual GOLDENGATE user.
To revoke privileges, use the procedure revoke_admin_privilege in the same package.

swells · 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

Add your answer

Relevant content