GoldenGate Replicat Abend with OGG-00519 ORA-01031 Insufficient Privileges Trying to Execute Alter Synonym (Doc ID 1403026.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Oracle GoldenGate - Version 9.5.0.4 and later
Information in this document applies to any platform.

Symptoms

Oracle GoldenGate (OGG) replicat abends with the following errors in the report file:

ORA-01031: insufficient privileges : trying to execute ALTER SYNONYM



The ggserr.log may show the following error:

ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, RFTNDP11.prm: Fatal error executing DDL replication: error [Error code [1031], ORA-01031: insufficient privileges, SQL ALTER SYNONYM "APPREAD"."PRCGETMERCHANTINFO_MERCHANTID" COMPILE /* GOLDENGATE_DDL_REPLICATION */], no error handler present.
ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, RFTNDP11.prm: PROCESS ABENDING



SQL> show user
USER is "GGATE"
SQL> SELECT db.name, i.instance_name, i.version FROM v$database db, v$instance i;

NAME INSTANCE_NAME VERSION
--------- ---------------- -----------------
FRONTEND FRONTEND1 11.1.0.7.0

SQL> ALTER SYNONYM "APPREAD"."PRCINSERTTMERCHANTINFO" COMPILE ;
ALTER SYNONYM "APPREAD"."PRCINSERTTMERCHANTINFO" COMPILE
ERROR at line 1:
ORA-01031: insufficient privileges

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms