Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

What to do if goldengate reports OGG-00446 error in oracle

2025-04-01 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

This article mainly introduces the oracle goldengate report OGG-00446 errors in how to do, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

OGG test: unable to start ext process, error OGG-00446

Error log [intercepting important parts]

2016-10-28 16:51:40 ERROR OGG-00446 Missing filename opening checkpoint file.2016-10-28 16:51:40 ERROR OGG-01668 PROCESS ABENDING.

The meaning of the log is clear: the file name is missing when opening checkpoint file

View parameters

Oracle@a-test30 dirprm] $more ext1.prm UserId ogg, Password oggExtTrail. / dirdat/eoGetTruncatesTranLogOptions ExcludeUser ogg-- DDL Include AllDDL & INCLUDE MAPPED OBJTYPE 'table' & INCLUDE MAPPED OBJTYPE' index' & EXCLUDE OPTYPE COMMENTDDLOptions AddTranData Retryop Retrydelay 10 Maxretries 10Table TMP.test1;Table TMP.test2;Table TMP.test3 [oracle@a-test30 dirprm] $more pump1.prm Extract pump1PassThruRmtHost 192.168.10.61, MgrPort 7809RmtTrail. / dirdat/goTable TMP.test1;Table TMP.test2;Table TMP.test3

Found that ext1.prm does not have a file header

Plus Extract ext1

GGSCI (a-test30 as ogg@qatest30) 27 > view params ext1Extract ext1UserId ogg, Password oggExtTrail. / dirdat/eoGetTruncatesTranLogOptions ExcludeUser ogg-- DDL Include AllDDL & INCLUDE MAPPED OBJTYPE 'table' & INCLUDE MAPPED OBJTYPE' index' & EXCLUDE OPTYPE COMMENTDDLOptions AddTranData Retryop Retrydelay 10 Maxretries 10Table TMP.test1;Table TMP.test2;Table TMP.test3

To start OK again.

Thank you for reading this article carefully. I hope the article "what to do about OGG-00446 errors in goldengate newspaper in oracle" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report