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
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