goldengate配置完成后,在源端做操作日志
REPLICAT RUNNING REP1 00:00:00 00:00:05
这进程总是莫名挂掉
用view param rep1查看,日志中报错
Database Language and Character Set:
NLS_LANG environment variable specified has invalid format, default value will b
e used.
NLS_LANG environment variable not set, using default value AMERICAN_AMERICA.US7A
SCII.
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "ZHS16GBK"
Warning: your NLS_LANG setting does not match database server language setting.
Please refer to user manual for more information.
***********************************************************************
** Run Time Messages **
***********************************************************************
Opened trail file f:\goldendate\dds\dirdat\rr000000 at 2013-03-17 18:17:03
MAP resolved (entry GGS.TCUSTORD):
map GGS.TCUSTORD, ggt.tcustord;
Source Context :
SourceModule : [er.main]
SourceID : [er/rep.c]
SourceFunction : [get_map_entry]
SourceLine : [8776]
ThreadBacktrace : [4] elements
: [C:\Windows\WinSxS\x86_microsoft.vc80.crt_1fc8b3b9a1
e18e3b_8.0.50727.6195_none_d09154e044272b9a\MSVCR80.dll(free+0xcd) [0x710C4C39]]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlAllocateHeap+0x211
) [0x77D12136]]
: [F:\goldendate\dds\replicat.exe(releaseCProcessManag
erInstance+0xab508b) [0x0100C9BB]]
: [(<eleaseCProcessManagerInstance+0xab508b) [0xFFEEFF
EE]]
2013-03-17 18:20:16 ERROR OGG-00212 Invalid option for MAP: ggt.tcustord.
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Reading f:\goldendate\dds\dirdat\rr000000, current RBA 934, 0 records
Report at 2013-03-17 18:20:16 (activity since 2013-03-17 18:17:02)
No records were replicated.
Last log location read:
FILE: f:\goldendate\dds\dirdat\rr000000
SEQNO: 0
RBA: 934
TIMESTAMP: 2013-03-17 18:20:09.000000
EOF: NO
READERR: 0
2013-03-17 18:20:16 ERROR OGG-01668 PROCESS ABENDING.
CACHE OBJECT MANAGER statistics
CACHE MANAGER VM USAGE
vm current = 0 vm anon queues = 0
vm anon in use = 0 vm file = 0
vm used max = 0 ==> CACHE BALANCED
CACHE CONFIGURATION
cache size = 512M cache force paging = 881M
buffer min = 64K buffer highwater = 4M
pageout eligible size = 4M
================================================================================
RUNTIME STATS FOR SUPERPOOL
CACHE Transaction Stats
trans active = 0 max concurrent = 0
non-zero total = 0 trans total = 0
CACHE File Caching
disk current = 0 disk total = 0
disk caching = 0 file cached = 0
file retrieves = 0
CACHE MANAGEMENT
buffer links = 0 anon gets = 0
forced unmaps = 0 cnnbl try = 0
cached out = 0 force out = 0
原来是由于rep1文件中写的映射关系有问题,在","和TARGET之间必须要有个空格