oracle goldengate報錯解決之OGG-00446

標籤：oracle   ogg   ext1   filename   

OGG測試：無法啟動ext進程，報錯OGG-00446

報錯日誌【截取重要部分】

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.

日誌意思很明顯：在開啟checkpoint file 時缺少檔案名稱

查看參數：

[email protected] dirprm]$ more ext1.prm 

UserId ogg, Password ogg

ExtTrail ./dirdat/eo

GetTruncates

TranLogOptions ExcludeUser ogg 

--DDL Include All

DDL &

INCLUDE MAPPED OBJTYPE ‘table‘ &

INCLUDE MAPPED OBJTYPE ‘index‘ &

EXCLUDE OPTYPE COMMENT

DDLOptions AddTranData Retryop Retrydelay 10 Maxretries 10

Table TMP.test1;

Table TMP.test2;

Table TMP.test3

[[email protected] dirprm]$ more pump1.prm 

Extract pump1

PassThru

RmtHost 192.168.10.61, MgrPort 7809

RmtTrail ./dirdat/go

Table TMP.test1;

Table TMP.test2;

Table TMP.test3;

發現ext1.prm沒有檔案頭名

加上Extract ext1

GGSCI (a-test30 as [email protected]) 27> view params ext1

Extract ext1

UserId ogg, Password ogg

ExtTrail ./dirdat/eo

GetTruncates

TranLogOptions ExcludeUser ogg 

--DDL Include All

DDL &

INCLUDE MAPPED OBJTYPE ‘table‘ &

INCLUDE MAPPED OBJTYPE ‘index‘ &

EXCLUDE OPTYPE COMMENT

DDLOptions AddTranData Retryop Retrydelay 10 Maxretries 10

Table TMP.test1;

Table TMP.test2;

Table TMP.test3;

再去啟動OK了。

本文出自 “lichdiamand” 部落格，請務必保留此出處http://lichdiamond.blog.51cto.com/12111063/1870729

oracle goldengate報錯解決之OGG-00446