本人想通過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:01
Copyright (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: 12596
Description:
***********************************************************************
** 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.63G
2017-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.0000
Driver Information:
SQLSRV32.DLL
Version 10.00.14393
ODBC Version 03.52
2017-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.
uj5u.com熱心網友回復:
這個真不會,沒用過OGG
uj5u.com熱心網友回復:
沒人幫忙看看么?
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/93529.html
標籤:高級技術
上一篇:12C中單步除錯報錯 求大俠幫忙
下一篇:表空間傳輸報錯
