Replicat Process Abends With OGG-00869 ORA-01031: Insufficient Privileges (Doc ID 2137555.1)

Last updated on MAY 12, 2016

Applies to:

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

Symptoms

Replicat process abends with below error:

2016-05-10 00:17:36 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, r1inau2l.prm: OCI Error ORA-01031: insufficient privileges (status = 1031), SQL <INSERT INTO "MRISK"."ACCOUNTS_GGE" ("GGE_ID","GGE_DATE","OPTYPE","ERRNUM","ERRMSG","SERVER_NAME","DB_NAME","TRAIL_SEQ","TRAIL_RBA","ID","CREATEDAT","UPDATEDAT","API_KEY","CALLBACK_ENABLED","CALLBACK_URL","DSP_ENABLED","DSP_THRESHOLD","GUID_MAX_AGE","GUID_MAX_DEVICES","NAME","RULE_CONFIG","SITE_KEY","RECIPEID","LOW_RES_RECIPE_ID","RESILIENT_GUID_ENABLED","RETAIN_ONLY_RESGUID_DATA","RESILIENT_GUID_V2_ENABLED","LICENSE_XML","MOBILE_BROWSER_BINDING_ENABLED","GLOBAL_GUID_ENABLED","IP_LOCATION_PROVIDER","CREATED_AT","UPDATED_AT","SITE_ID","REPLICAT_NAME") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8,:a9,:a10,:a11,:a12,:a13,:a14,:a15,:a16,:a17,:a18,:a19,:a20,:a21,:a22,:a23,:a24,:a25,:a26,:a27,:a28,:a29,:a30,:a31,:a32,:a33,:a34)>.

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