OGG报错：ERROR OGG-00204 Missing TARGET specification.

xuchao2012 · 发表于 2012-2-23 19:12

本帖最后由 xuchao2012 于 2014-1-20 10:29 编辑

目标端是不是应该改成：
GGSCI (localhost.localdomain) 2> edit params REP-EDS
replicat REP-EDS
SETENV (NLS_LANG =AMERICAN_AMERICA.ZHS16GBK)
userid 123456,password 123456
discardfile /opt/OGG/discard/rep-eds.txt, append, megabytes 100
MAP test2012.DETAIL （源）, TARGET test2012.DETAIL（目标） , KEYCOLS (USER_ID);

xuchao2012 · 发表于 2012-2-24 09:56

本帖最后由 xuchao2012 于 2014-1-20 10:33 编辑

源端和目标端的配置如下：
GGSCI (localhost.localdomain) 32> edit params EXT-test

extract ext-test
SETENV (NLS_LANG =AMERICAN_AMERICA.ZHS16GBK)
userid 123456,password 123456
exttrail /opt/OGG/dirdat/test/EXTTRAIL/su
discardfile /opt/OGG/discard/ext-test.txt, append, megabytes 100
table test12012.DETAIL ,  KEYCOLS (USER_ID);
table test12012.USERS ,  KEYCOLS (USER_ID);
table test12012.COMPANY, KEYCOLS (COMPANY_ID);
table test12012.COMPANY_DETAIL, KEYCOLS (COMPANY_ID);

GGSCI (localhost.localdomain) 34> edit params REP-test
replicat  REP-test
SETENV (NLS_LANG =AMERICAN_AMERICA.ZHS16GBK)
userid 123456,password 123456
discardfile /opt/OGG/discard/rep-test.txt, append, megabytes 100
MAP test12012.DETAIL, target test.DETAIL, KEYCOLS (USER_ID);
MAP test12012.USERS,       target test.USERS, KEYCOLS (USER_ID);
MAP test12012.COMPANY,       target test.COMPANY, KEYCOLS (COMPANY_ID);
MAP test12012.COMPANY_DETAIL, target test.COMPANY_DETAIL, KEYCOLS (COMPANY_ID)
大哥帮忙看下，系统提示：
2012-02-24 09:51:33  ERROR OGG-00268  Parameter unterminated.

2012-02-24 09:51:34  ERROR OGG-01668  PROCESS ABENDING.

饼干lr · 发表于 2012-2-24 13:17

你源端跟目标端的表是不是只有一个列啊？
如果是的话：
source：
table test12012.TAB_UUM_USER_DETAIL ,  KEYCOLS (USER_ID);
table test12012.TAB_UUM_USERS ,  KEYCOLS (USER_ID);
table test12012.TAB_UUM_COMPANY, KEYCOLS (COMPANY_ID);
table test12012.TAB_UUM_COMPANY_DETAIL, KEYCOLS (COMPANY_ID);

change to==>
table test12012.TAB_UUM_USERS;
table test12012.TAB_UUM_COMPANY;
table test12012.TAB_UUM_COMPANY_DETAIL;

target:
MAP test12012.TAB_UUM_USER_DETAIL, target testmoa2012.TAB_UUM_USER_DETAIL, KEYCOLS (USER_ID);
MAP test12012.TAB_UUM_USERS,       target testmoa2012.TAB_UUM_USERS, KEYCOLS (USER_ID);
MAP test12012.TAB_UUM_COMPANY,       target testmoa2012.TAB_UUM_COMPANY, KEYCOLS (COMPANY_ID);
MAP test12012.TAB_UUM_COMPANY_DETAIL, target testmoa2012.TAB_UUM_COMPANY_DETAIL, KEYCOLS (COMPANY_ID);

change to ==>
HandleCollisions
AssumeTargetDefs
MAP test12012.TAB_UUM_USER_DETAIL, target testmoa2012.TAB_UUM_USER_DETAIL;
MAP test12012.TAB_UUM_USERS,       target testmoa2012.TAB_UUM_USERS;
MAP test12012.TAB_UUM_COMPANY,       target testmoa2012.TAB_UUM_COMPANY;
MAP test12012.TAB_UUM_COMPANY_DETAIL, target testmoa2012.TAB_UUM_COMPANY_DETAIL;

xuchao2012 · 发表于 2012-2-24 13:58

系统提示：2012-02-24 13:41:34 ERROR OGG-00268 Parameter unterminated.

2012-02-24 13:41:34 ERROR OGG-01668 PROCESS ABENDING.

Toms_zhang · 发表于 2012-2-24 18:07

语法问题！