风哥教程

培训 . 交流 . 分享
Make progress together!

oracle goldengate OGG-01264问题处理

[复制链接]
内容发布:paulyi| 发布时间:2014-3-1 16:24:25
oracle goldengate OGG-01264问题处理


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, <extract>.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, <extract>.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, <extract>.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.



上一篇:oracle goldengate恢复过程
下一篇:oracle goldengate在节点之间进行迁移
回复

使用道具 举报

1框架
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

热门文章教程

  • Oracle19c数据库发布与下载地址
  • 风哥Oracle数据库巡检工具V1.0(附2.6网页
  • Oracle Database 12c 数据库100个新特性与
  • Oracle 12cR2 九大新功能全面曝光_详解云数
  • 实战PHP与MySQL权威指南PDF电子书下载
  • 大数据技术与应用入门培训教程(电子版下载
快速回复 返回顶部 返回列表