oracle goldengate OGG-01264問題處理

  OGG Extract Abend With OGG-01264 in Process_lob()
In this Document
  Symptoms
  Cause
  Solution
  References

Applies to:
Oracle GoldenGate - Version: 10.4.0.0 and later   [Release: 10.4.0 and later ]
Information in this document applies to any platform.
Symptoms
Oracle GoldenGate (OGG) Extract abends intermittently while processing LOB data.
Below are few sample ERROR messages related to this issue:

ERROR OGG-01264 Oracle GoldenGate Capture for Oracle, .prm: The call to the FM_tran_delete() function from line 3365 in process_lob() returned an unexpected value.

ERROR OGG-01264 Oracle GoldenGate Capture for Oracle, .prm: The call to the FM_tran_delete() function from line 3321 in process_lob() returned an unexpected value.

ERROR OGG-01264 Oracle GoldenGate Capture for Oracle, .prm: The call to the CM_obj_free_sec_id() function from line 3388 in process_lob() returned an unexpected value.

ERROR OGG-01082 The call to the FM_tran_delete function from RTC_delete_tran(mempool_t *, memtran_t *) failed with return code 0
Cause
This is due to Bug 12373128 while processing LOB data.
Solution
Restarting of the extract should be a valid workaround. The bug is a racing condition when processing LOB data.  When restarting, the race condition from the previous run doesn't exist anymore.

To automate the restart when Extract abends, please use the manager parameter "AUTORESTART". For more information on this parameter , please refer to the "Oracle GoldenGate Reference Guide".

The permanent fix is planned in OGG v11.2.1. For prior versions, patches has been released to fix this bug as given below. Please apply the same.

For OGG v11.1.1.0.X : The patch 12801882 needs to be applied.
For OGG v11.1.1.1     : The patch 12871116 needs to be applied.

Please check the corresponding patch is available for your platform. and rdbms version. If not , please request the oracle support for the same.