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.