GoldenGate Extract Warning OGG-00869 Failed to Retrieve Column List Handle for Table

Applies to:

Oracle GoldenGate - Version: 9.5.1.9 and later   [Release: 9.5.1 and later ]

Information in this document applies to any platform.

Symptoms

Oracle GoldenGate (OGG) Extract shows following errors in report file:

WARNING OGG-00869 Failed to retrieve column list handle for table CTAS.LOCAL_PERMIT_T. ERROR OGG-00199 Table CTAS.LOCAL_PERMIT_T does not exist in target database.

Cause

Cursor count in the Oracle DB might be too low (open_cursors set to 50, what is very low, recommended value is 1000 or more)

Solution

Increase  the cursor count in the Oracle DB (open_cursors)

References

NOTE:1059710.1 - GoldenGate Extract/Replicat Errors in Oracle-Unix Environment