oracle goldengate OGG-00665 status = 1482-ORA-01482

gg目标端repfull进程配置文件如下:
GGSCI (rac2) 12> view params repfull
replicat repfull
setenv ( NLS_LANG =  " AMERICAN_AMERICA.ZHS16GBK " )
assumetargetdefs
userid goldengate, password oracleoracle
DBOPTIONS DEFERREFCONST, SUPPRESSTRIGGERS
gettruncates
ALLOWNOOPUPDATES
ddl include mapped
discardfile ./dirrpt/repfull.dsc, append, megabytes 5000
map TEST.*, target TEST.*;


启动repfull进程报错,日志如下:
GGSCI (rac2) 13> info all 
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
REPLICAT    STOPPED     REPFULL     00:00:00      00:24:05


GGSCI (rac2) 13> view report repfull
...
+0x1fa) [0x63acba]]
                          : [/ogg/replicat(OCISESS_context_def::select_start(bool, query_handle*, ggs
::gglib::ggunicode::UString const&, short, ...)+0x11c) [0x63adfc]]
                          : [/ogg/replicat(get_DB_code_point(char*, char*)+0xa9) [0x6199e9]]
                          : [/ogg/replicat(DBUTIL_db_charset(char*, short, char*)+0x142) [0x619cf2]]
                          : [/ogg/replicat(DBUTIL_printCharset(char*)+0x15) [0x5706c5]]
                          : [/ogg/replicat(replicat_main(int, char**)+0x20c) [0x55759c]]
                          : [/ogg/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f) [
0x5fa58f]]
                          : [/ogg/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::
MultiThreading::Thread::ThreadArgs*)+0x104) [0x5fa7e4]]
                          : [/ogg/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0
x8b) [0x5fa8eb]]
                          : [/ogg/replicat(main+0x2c) [0x556c8c]]
                          : [/lib64/libc.so.6(__libc_start_main+0xfd) [0x3855c1ed1d]]
                          : [/ogg/replicat(__gxx_personality_v0+0x33a) [0x4c7b6a]]


2018-01-13 16:07:44  ERROR   OGG-00665  OCI Error describe for query (status = 1482-ORA-01482: unsupp
orted character set), SQL<select dump(convert(chr(128), 'ZHS16GBK', 'ZHS16GBK ')) from dual>.


2018-01-13 16:07:44  ERROR   OGG-01668  PROCESS ABENDING.




修改字符集行内容如下:
GGSCI (rac2) 10> view params repfull
replicat repfull
setenv (NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")
...


再次启动repfull正常
GGSCI (rac2) 5> start repfull, aftercsn 1538957
Sending START request to MANAGER ...
REPLICAT REPFULL starting




GGSCI (rac2) 11> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
REPLICAT    RUNNING     REPFULL     00:00:00      00:00:04    
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值