When start the source side extraction process, process terminates abnormally in OGG - 00139 Extract was not built with VAM functionality included errors, someone met or what is the solution?
Specific configuration files and log information is as follows:
GGSCI (LAPTOP - FP90U5DR) & gt; The ADD EXTRACT EXTA TRANLOG, BEGIN NOW
GGSCI (LAPTOP - FP90U5DR) & gt; The ADD EXTTRAIL H: \ \ ogg dirdat \ ex, EXTRACT EXTA
GGSCI (LAPTOP - FP90U5DR) & gt; The view param exta
EXTRACT EXTA
SOURCEDB HR USERID ogg PASSWORD luhengxing
TRANLOGOPTIONS MANAGESECONDARYTRUNCATIONPOINT
EXTTRAIL H: \ \ ogg dirdat \ ex
Table dbo. *;
The log information:
GGSCI (LAPTOP - FP90U5DR) 1 & gt; The view param exta
EXTRACT EXTA
SOURCEDB HR USERID ogg PASSWORD luhengxing
TRANLOGOPTIONS MANAGESECONDARYTRUNCATIONPOINT
EXTTRAIL H: \ \ ogg dirdat \ ex
Table dbo. *;
GGSCI (LAPTOP - FP90U5DR) 2 & gt; The view report exta
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Oracle GoldenGate Capture for SQL Server
The 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 the 2017-06-01 16:27:59
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Operating System Version:
Microsoft Windows 8, on x64
Version 6.2 (Build 9200)
The Process id: 12596
Description:
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * Running with the following parameters * *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
The 2017-06-01 16:27:59 INFO OGG - 03059 Operating system character set identified as GBK.
The 2017-06-01 16:27:59 INFO OGG - 02695 ANSI SQL parameter syntax is 2 for parameter parsing.
EXTRACT EXTA
SOURCEDB HR USERID ogg PASSWORD * * *
The 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.
The 2017-06-01 16:27:59 INFO OGG - 03036 Database character set identified as Windows - 936. The Locale: zh_CN.
The 2017-06-01 16:27:59 Session INFO OGG - 03037 character set identified as GBK.
TRANLOGOPTIONS MANAGESECONDARYTRUNCATIONPOINT
EXTTRAIL H: \ \ ogg dirdat \ ex
Table dbo. *;
The 2017-06-01 16:27:59 INFO OGG - 01851 filecaching started: thread ID: 59745376.
The 2017-06-01 16:27:59 INFO OGG - 01815 Virtual Memory Facilities for: COM
Anon alloc: MapViewOfFile -anon free: UnmapViewOfFile
The file alloc: MapViewOfFile file free: UnmapViewOfFile
Target directories:
H: \ \ ogg dirtmp.
CACHEMGR virtual memory values (have had adjusted)
CACHESIZE: 15.63 G
CACHEPAGEOUTSIZE (default) : 8 m
PROCESS the AVAIL VM FROM OS (min) : 19.63 G
CACHESIZEMAX (strict force to disk) : 17.63 G
The 2017-06-01 16:28:00 CACHESIZE WARNING OGG - 01842 PER DYNAMIC DETERMINATION (15.63 G) LESS THAN it: 64 G (64 - bit system)
The vm found: 19.63 G
Check swap space. It swap/extract: 128 g (64 - bit system.)
The 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
The 2017-06-01 16:28:00 INFO OGG - 01055 Recovery initialization completed for the target file H: \ \ OGG dirdat \ ex000000035, at the RBA 1316.
The 2017-06-01 16:28:00 INFO OGG - 01478 Output file H: \ \ OGG dirdat \ ex is using the format in RELEASE 12.2.
The 2017-06-01 16:28:00 INFO OGG - 01026 Rolling over remote file H: \ \ OGG dirdat \ ex000000035
The 2017-06-01 16:28:00 INFO OGG - 01053 Recovery completed for the target file H: \ \ OGG dirdat \ ex000000036, at the RBA 1316.
The 2017-06-01 16:28:00 INFO OGG - 01057 Recovery completed for all the targets.
The 2017-06-01 16:28:00 VAM INFO OGG - 00182 API running in single - threaded mode.
The 2017-06-01 16:28:00 INFO OGG - 01515 Positioning to the begin time 10:59:51 2017-6-1 morning.
The Source Context:
SourceModule: [vam. Essentially. MSSqlVamStub]
SourceID: [ggmssqlvam/MSSqlVamStub CPP]
SourceFunction: [VAMInitialize]
SourceLine: [40]
ThreadBacktrace: [16] elements
: [h: \ \ ogg gglog. DLL (?? 1 ccontextitem @ @ UEAA @ XZ + 0 x2ab6) x00007ff98830f106 [0]]
: [h: \ \ ogg gglog. DLL (? CreateMessage @ CMessageFactory @ @ QEAAPEAVCMessage @ @ PEAVCSourceContext @ @ IZZ + 0 x561) x00007ff98830f751 [0]]
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull