Replicat Process Abends With OGG-00869 ORA-01031: Insufficient Privileges
(Doc ID 2137555.1)
Last updated on JANUARY 12, 2020
Applies to:
Oracle GoldenGate - Version 11.2.1.0.1 and laterInformation 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 "SCHEMA"."TABLE_NAME" ("ID","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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |