Goldengate: Error ORA-28100: Policy Function Schema APPS Is Invalid (status = 28100)
(Doc ID 2425487.1)
Last updated on AUGUST 23, 2021
Applies to:
Oracle GoldenGate - Version 12.2.0.1.0 and laterInformation in this document applies to any platform.
Symptoms
Replicat was getting below error:
2018-07-17 14:52:32 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, <replicat name>.prm: SQL error 28100 mapping SRC.TBL to TRG.TBL OCI Error ORA-28100: policy function schema APPS is invalid (status = 28100), SQL <INSERT /*+ RESTRICT_ALL_REF_CONS */ INTO "<schema name>"."<table name>" ("<col1>"....".
2018-07-17 14:52:32 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, <replicat name>.prm: Error mapping from SRC.TBL to TRG.TBL.
2018-07-17 14:52:32 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, <replicat name>.prm: PROCESS ABENDING.
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 |
References |