本人想通过OGG实现从SQL SERVER 2014 同步到ORACLE 11.2.0.3,OGG版本为12.2.0.1。
在启动源端抽取进程时,进程异常终止出现OGG-00139 Extract was not built with VAM functionality included错误。有人碰到过或者有什么解决方案么?具体的配置文件和日志信息如下:
GGSCI (LAPTOP-FP90U5DR)> ADD EXTRACT EXTA, TRANLOG, BEGIN NOW
GGSCI (LAPTOP-FP90U5DR)> ADD EXTTRAIL H:\ogg\dirdat\ex, EXTRACT EXTA
GGSCI (LAPTOP-FP90U5DR)> view param exta
EXTRACT EXTA
SOURCEDB HR USERID ogg PASSWORD luhengxing
TRANLOGOPTIONS MANAGESECONDARYTRUNCATIONPOINT
EXTTRAIL H:\ogg\dirdat\ex
table dbo.*;日志信息:GGSCI (LAPTOP-FP90U5DR) 1> view param exta
EXTRACT EXTA
SOURCEDB HR USERID ogg PASSWORD luhengxing
TRANLOGOPTIONS MANAGESECONDARYTRUNCATIONPOINT
EXTTRAIL H:\ogg\dirdat\ex
table dbo.*;
GGSCI (LAPTOP-FP90U5DR) 2> view report exta***********************************************************************
Oracle GoldenGate Capture for SQL Server
Capture Method: None
Version 12.2.0.1.160823 24575038
Windows x64 (optimized), Microsoft SQL Server on Oct 28 2016 13:27:01Copyright (C) 1995, 2016, Oracle and/or its affiliates. All rights reserved.
Starting at 2017-06-01 16:27:59
***********************************************************************Operating System Version:
Microsoft Windows 8 , on x64
Version 6.2 (Build 9200)Process id: 12596Description:***********************************************************************
** Running with the following parameters **
***********************************************************************2017-06-01 16:27:59 INFO OGG-03059 Operating system character set identified as GBK.2017-06-01 16:27:59 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
EXTRACT EXTA
SOURCEDB HR USERID ogg PASSWORD ***2017-06-01 16:27:59 WARNING OGG-05236 ODBC Warning: The specified DSN 'HR' uses a client driver that may be incompatible with the database server. Microsoft SQL Server 2014 requires SQLNCLI11.DLL,MSODBCSQL11.DLL or a more recent version.2017-06-01 16:27:59 INFO OGG-03036 Database character set identified as windows-936. Locale: zh_CN.2017-06-01 16:27:59 INFO OGG-03037 Session character set identified as GBK.
TRANLOGOPTIONS MANAGESECONDARYTRUNCATIONPOINT
EXTTRAIL H:\ogg\dirdat\ex
table dbo.*;2017-06-01 16:27:59 INFO OGG-01851 filecaching started: thread ID: 59745376.2017-06-01 16:27:59 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: MapViewOfFile anon free: UnmapViewOfFile
file alloc: MapViewOfFile file free: UnmapViewOfFile
target directories:
h:\ogg\dirtmp.CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 15.63G
CACHEPAGEOUTSIZE (default): 8M
PROCESS VM AVAIL FROM OS (min): 19.63G
CACHESIZEMAX (strict force to disk): 17.63G2017-06-01 16:28:00 WARNING OGG-01842 CACHESIZE PER DYNAMIC DETERMINATION (15.63G) LESS THAN RECOMMENDED: 64G (64bit system)
vm found: 19.63G
Check swap space. Recommended swap/extract: 128G (64bit system).Database Version:
Microsoft SQL Server
Version 12.00.2000
ODBC Version 03.80.0000Driver Information:
SQLSRV32.DLL
Version 10.00.14393
ODBC Version 03.522017-06-01 16:28:00 INFO OGG-01055 Recovery initialization completed for target file H:\ogg\dirdat\ex000000035, at RBA 1316.2017-06-01 16:28:00 INFO OGG-01478 Output file H:\ogg\dirdat\ex is using format RELEASE 12.2.2017-06-01 16:28:00 INFO OGG-01026 Rolling over remote file H:\ogg\dirdat\ex000000035.2017-06-01 16:28:00 INFO OGG-01053 Recovery completed for target file H:\ogg\dirdat\ex000000036, at RBA 1316.2017-06-01 16:28:00 INFO OGG-01057 Recovery completed for all targets.2017-06-01 16:28:00 INFO OGG-00182 VAM API running in single-threaded mode.2017-06-01 16:28:00 INFO OGG-01515 Positioning to begin time 2017-6-1 上午10:59:51.Source Context :
SourceModule : [vam.sqlserver.MSSqlVamStub]
SourceID : [ggmssqlvam/MSSqlVamStub.cpp]
SourceFunction : [VAMInitialize]
SourceLine : [40]
ThreadBacktrace : [16] elements
: [h:\ogg\gglog.dll(??1CContextItem@@UEAA@XZ+0x2ab6) [0x00007FF98830F106]]
: [h:\ogg\gglog.dll(?CreateMessage@CMessageFactory@@QEAAPEAVCMessage@@PEAVCSourceContext@@IZZ+0x561) [0x00007FF98830F751]]
: [h:\ogg\gglog.dll(?_MSG_ERR_VAM_NOT_SUPPORTED@@YAPEAVCMessage@@PEAVCSourceContext@@W4MessageDisposition@CMessageFactory@@@Z+0x31) [0x00007FF988298BD1]]
: [h:\ogg\extract.exe(VAMInitialize+0x45) [0x00007FF600D11F85]]
: [h:\ogg\extract.exe(GGDataBufferGetNextChunk+0x3b906) [0x00007FF600C8D836]]
: [h:\ogg\extract.exe(GGDataBufferGetNextChunk+0xddc) [0x00007FF600C52D0C]]
: [h:\ogg\extract.exe(GGDataBufferGetNextChunk+0x59b) [0x00007FF600C524CB]]
: [h:\ogg\extract.exe(ERCALLBACK+0x3e81c) [0x00007FF600B4897C]]
: [h:\ogg\extract.exe(ERCALLBACK+0x45075) [0x00007FF600B4F1D5]]
: [h:\ogg\extract.exe(_ggTryDebugHook+0x8443) [0x00007FF600C1C7F3]]
: [h:\ogg\extract.exe(_ggTryDebugHook+0x782b) [0x00007FF600C1BBDB]]
: [h:\ogg\extract.exe(_ggTryDebugHook+0x82e3) [0x00007FF600C1C693]]
: [h:\ogg\extract.exe(ERCALLBACK+0x451db) [0x00007FF600B4F33B]]
: [h:\ogg\extract.exe(VAMControl+0x6e42) [0x00007FF600D18E72]]
: [C:\windows\System32\KERNEL32.DLL(BaseThreadInitThunk+0x14) [0x00007FF9DB498364]]
: [C:\windows\SYSTEM32\ntdll.dll(RtlUserThreadStart+0x21) [0x00007FF9DC0670D1]]2017-06-01 16:28:00 ERROR OGG-00139 Extract was not built with VAM functionality included.2017-06-01 16:28:00 ERROR OGG-01668 PROCESS ABENDING.
在启动源端抽取进程时,进程异常终止出现OGG-00139 Extract was not built with VAM functionality included错误。有人碰到过或者有什么解决方案么?具体的配置文件和日志信息如下:
GGSCI (LAPTOP-FP90U5DR)> ADD EXTRACT EXTA, TRANLOG, BEGIN NOW
GGSCI (LAPTOP-FP90U5DR)> ADD EXTTRAIL H:\ogg\dirdat\ex, EXTRACT EXTA
GGSCI (LAPTOP-FP90U5DR)> view param exta
EXTRACT EXTA
SOURCEDB HR USERID ogg PASSWORD luhengxing
TRANLOGOPTIONS MANAGESECONDARYTRUNCATIONPOINT
EXTTRAIL H:\ogg\dirdat\ex
table dbo.*;日志信息:GGSCI (LAPTOP-FP90U5DR) 1> view param exta
EXTRACT EXTA
SOURCEDB HR USERID ogg PASSWORD luhengxing
TRANLOGOPTIONS MANAGESECONDARYTRUNCATIONPOINT
EXTTRAIL H:\ogg\dirdat\ex
table dbo.*;
GGSCI (LAPTOP-FP90U5DR) 2> view report exta***********************************************************************
Oracle GoldenGate Capture for SQL Server
Capture Method: None
Version 12.2.0.1.160823 24575038
Windows x64 (optimized), Microsoft SQL Server on Oct 28 2016 13:27:01Copyright (C) 1995, 2016, Oracle and/or its affiliates. All rights reserved.
Starting at 2017-06-01 16:27:59
***********************************************************************Operating System Version:
Microsoft Windows 8 , on x64
Version 6.2 (Build 9200)Process id: 12596Description:***********************************************************************
** Running with the following parameters **
***********************************************************************2017-06-01 16:27:59 INFO OGG-03059 Operating system character set identified as GBK.2017-06-01 16:27:59 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
EXTRACT EXTA
SOURCEDB HR USERID ogg PASSWORD ***2017-06-01 16:27:59 WARNING OGG-05236 ODBC Warning: The specified DSN 'HR' uses a client driver that may be incompatible with the database server. Microsoft SQL Server 2014 requires SQLNCLI11.DLL,MSODBCSQL11.DLL or a more recent version.2017-06-01 16:27:59 INFO OGG-03036 Database character set identified as windows-936. Locale: zh_CN.2017-06-01 16:27:59 INFO OGG-03037 Session character set identified as GBK.
TRANLOGOPTIONS MANAGESECONDARYTRUNCATIONPOINT
EXTTRAIL H:\ogg\dirdat\ex
table dbo.*;2017-06-01 16:27:59 INFO OGG-01851 filecaching started: thread ID: 59745376.2017-06-01 16:27:59 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: MapViewOfFile anon free: UnmapViewOfFile
file alloc: MapViewOfFile file free: UnmapViewOfFile
target directories:
h:\ogg\dirtmp.CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 15.63G
CACHEPAGEOUTSIZE (default): 8M
PROCESS VM AVAIL FROM OS (min): 19.63G
CACHESIZEMAX (strict force to disk): 17.63G2017-06-01 16:28:00 WARNING OGG-01842 CACHESIZE PER DYNAMIC DETERMINATION (15.63G) LESS THAN RECOMMENDED: 64G (64bit system)
vm found: 19.63G
Check swap space. Recommended swap/extract: 128G (64bit system).Database Version:
Microsoft SQL Server
Version 12.00.2000
ODBC Version 03.80.0000Driver Information:
SQLSRV32.DLL
Version 10.00.14393
ODBC Version 03.522017-06-01 16:28:00 INFO OGG-01055 Recovery initialization completed for target file H:\ogg\dirdat\ex000000035, at RBA 1316.2017-06-01 16:28:00 INFO OGG-01478 Output file H:\ogg\dirdat\ex is using format RELEASE 12.2.2017-06-01 16:28:00 INFO OGG-01026 Rolling over remote file H:\ogg\dirdat\ex000000035.2017-06-01 16:28:00 INFO OGG-01053 Recovery completed for target file H:\ogg\dirdat\ex000000036, at RBA 1316.2017-06-01 16:28:00 INFO OGG-01057 Recovery completed for all targets.2017-06-01 16:28:00 INFO OGG-00182 VAM API running in single-threaded mode.2017-06-01 16:28:00 INFO OGG-01515 Positioning to begin time 2017-6-1 上午10:59:51.Source Context :
SourceModule : [vam.sqlserver.MSSqlVamStub]
SourceID : [ggmssqlvam/MSSqlVamStub.cpp]
SourceFunction : [VAMInitialize]
SourceLine : [40]
ThreadBacktrace : [16] elements
: [h:\ogg\gglog.dll(??1CContextItem@@UEAA@XZ+0x2ab6) [0x00007FF98830F106]]
: [h:\ogg\gglog.dll(?CreateMessage@CMessageFactory@@QEAAPEAVCMessage@@PEAVCSourceContext@@IZZ+0x561) [0x00007FF98830F751]]
: [h:\ogg\gglog.dll(?_MSG_ERR_VAM_NOT_SUPPORTED@@YAPEAVCMessage@@PEAVCSourceContext@@W4MessageDisposition@CMessageFactory@@@Z+0x31) [0x00007FF988298BD1]]
: [h:\ogg\extract.exe(VAMInitialize+0x45) [0x00007FF600D11F85]]
: [h:\ogg\extract.exe(GGDataBufferGetNextChunk+0x3b906) [0x00007FF600C8D836]]
: [h:\ogg\extract.exe(GGDataBufferGetNextChunk+0xddc) [0x00007FF600C52D0C]]
: [h:\ogg\extract.exe(GGDataBufferGetNextChunk+0x59b) [0x00007FF600C524CB]]
: [h:\ogg\extract.exe(ERCALLBACK+0x3e81c) [0x00007FF600B4897C]]
: [h:\ogg\extract.exe(ERCALLBACK+0x45075) [0x00007FF600B4F1D5]]
: [h:\ogg\extract.exe(_ggTryDebugHook+0x8443) [0x00007FF600C1C7F3]]
: [h:\ogg\extract.exe(_ggTryDebugHook+0x782b) [0x00007FF600C1BBDB]]
: [h:\ogg\extract.exe(_ggTryDebugHook+0x82e3) [0x00007FF600C1C693]]
: [h:\ogg\extract.exe(ERCALLBACK+0x451db) [0x00007FF600B4F33B]]
: [h:\ogg\extract.exe(VAMControl+0x6e42) [0x00007FF600D18E72]]
: [C:\windows\System32\KERNEL32.DLL(BaseThreadInitThunk+0x14) [0x00007FF9DB498364]]
: [C:\windows\SYSTEM32\ntdll.dll(RtlUserThreadStart+0x21) [0x00007FF9DC0670D1]]2017-06-01 16:28:00 ERROR OGG-00139 Extract was not built with VAM functionality included.2017-06-01 16:28:00 ERROR OGG-01668 PROCESS ABENDING.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货