首页 > 数据库技术 > 详细

ogg在oracle database 11.2.0.3上还是谨慎使用集成捕捉模式

时间:2016-04-29 19:45:24      阅读:282      评论:0      收藏:0      [点我收藏+]

原因:
OGG Integrated Extract abend with ORA-01341: LogMiner out-of-memory (文档 ID 1640076.1)

 

APPLIES TO:

Oracle GoldenGate - Version 11.2.1.0.0 and later
Information in this document applies to any platform.

SYMPTOMS

 

The integrated extract abend with the following error
ERROR OGG-02077 Extract encountered a read error in the asyncronous reader thread and is abending: Error code 1341, error message: ORA-01341: LogMiner out-of-memory.

CAUSE

The problem is often encountered after the database was upgraded to 11.2.0.3. 

The issue is due to database bug 16747736

SOLUTION

 

No workarounds available
Increasing the max_sga_size to a high value will delay the time of getting hit with the issue but won‘t totally fix it.

The database bug fix is included in the 11.2.0.4 database patch set.
Please reach RDBMS team in case if you want to get a one off for 11.2.0.3 db version.

REFERENCES

BUG:16747736 - ORA-1341: LOGMINER OUT-OF-MEMORY AFTER UPGRADE TO 11.2.0.3 + PATCH 16

ogg在oracle database 11.2.0.3上还是谨慎使用集成捕捉模式

原文:http://blog.csdn.net/msdnchina/article/details/51224508

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!