Tried several online tutorials, eventually will quote this mistake, don't know how to solve

CodePudding user response:

CodePudding user response:

EXTRACT INITLOD1

DBOPTIONS HOST 127.0.0.1, CONNECTIONPORT 3306
SOURCEDB test, USERID root @ localhost, PASSWORD 123
RMTHOST 127.0.0.1, MGRPORT 7809
RMTFILE./dirdat el1. Dat, PURGE
The TABLE test. *;

CodePudding user response:

IP port has been measured these network environment?

CodePudding user response:

I now is to configure the source database, start at the wrong

CodePudding user response:

Do you have a look at your log in bread what mistake

CodePudding user response:

reference 5 floor baidu_36457652 reply:

what bread in a look at your log error

The 2018-05-07 T08:53:48. 093 + 0800-01085 Oracle GoldenGate INFO OGG Manager for MySQL, MGR. Also: MGR received the window closed event.
The 2018-05-07 T08:53:54. 047 + 0800-00987 Oracle GoldenGate INFO OGG Command Interpreter for MySQL: GGSCI Command (admin) : start MGR.
The 2018-05-07 T08:53:54. 220 + 0800-01877 WARNING OGG Oracle GoldenGate Manager for MySQL, MGR. Also: Missing explicit accessrule for server collector.
The 2018-05-07 T08:53:54. 220 + 0800-00983 Oracle GoldenGate INFO OGG Manager for MySQL, MGR. Also: Manager started (port 7809).
The 2018-05-07 T08:53:59. 711 + 0800-00987 Oracle GoldenGate INFO OGG Command Interpreter for MySQL: GGSCI Command (admin) : start initlod1.
The 2018-05-07 T08:53:59. 720 + 0800-00963 Oracle GoldenGate INFO OGG Manager for MySQL, MGR. Also: the Command received from GGSCI on host [FE80: : 4055:95 d5:777 a: ED26] : 58049 (START EXTRACT INITLOD1).
The 2018-05-07 T08:53:59. 724 + 0800-00975 Oracle GoldenGate INFO OGG Manager for MySQL, MGR. Also: EXTRACT INITLOD1 starting.
The 2018-05-07 T08:53:59. 861 + 0800-01017 Oracle GoldenGate INFO OGG Capture for MySQL, INITLOD1. Also: Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is 2.
The 2018-05-07 T08:53:59. 861 + 0800-00992 Oracle GoldenGate INFO OGG Capture for MySQL, INITLOD1. Also: EXTRACT INITLOD1 starting.
The 2018-05-07 T08:53:59. 868 + 0800-03059 Oracle GoldenGate INFO OGG Capture for MySQL, INITLOD1. Also: Operating system character set identified as GBK.
The 2018-05-07 T08:53:59. 873 + 0800-02695 Oracle GoldenGate INFO OGG Capture for MySQL, INITLOD1. Also: the ANSI SQL parameter syntax is 2 for parameter parsing.
2018-05-07 T08:53:59. 885 + 0800-01360 Oracle GoldenGate INFO OGG Capture for MySQL, INITLOD1. Also: EXTRACT is running in the Initial Load mode.
The 2018-05-07 T08:53:59. 926 + 0800-01889 Oracle GoldenGate INFO OGG Capture for MySQL, INITLOD1. Also: Flush the size (Max message size) is set to 27985.
The 2018-05-07 T08:54:00. 075 + 0800-01851 Oracle GoldenGate INFO OGG Capture for MySQL, INITLOD1. Also: filecaching started: thread ID: 46113040.
The 2018-05-07 T08:54:00. 083 + 0800-01815 Oracle GoldenGate INFO OGG Capture for MySQL, INITLOD1. Also: Virtual Memory Facilities for: COM
Anon alloc: MapViewOfFile -anon free: UnmapViewOfFile
The file alloc: MapViewOfFile file free: UnmapViewOfFile
Target directories:
D: \ \ ogg dirtmp.
The 2018-05-07 T08:54:00. 095 + 0800-01842 WARNING OGG Oracle GoldenGate Capture for MySQL, INITLOD1. Also: CACHESIZE PER DYNAMIC DETERMINATION (2 g) LESS THAN it: 64 g (64 - bit system)
The vm found: 3.44 G
Check swap space. It swap/extract: 128 g (64 - bit system.)
The 2018-05-07 T08:54:00. 112 + 0800-06508 Oracle GoldenGate INFO OGG Capture for MySQL, INITLOD1. Also: Wildcard MAP (TABLE) resolved (entry test. *) : TABLE "test". "test1".
The 2018-05-07 T08:54:00. 127 + 0800-06509 Oracle GoldenGate INFO OGG Capture for MySQL, INITLOD1. Also: Using the following key columns for the source table test. The test1: name, age.
The 2018-05-07 T08:54:00. 127 + 0800-00993 Oracle GoldenGate INFO OGG Capture for MySQL, INITLOD1. Also: EXTRACT INITLOD1 started.
The 2018-05-07 T08:54:00. 118 + 0800-00963 Oracle GoldenGate INFO OGG Manager for MySQL, MGR. Also: the Command received from the EXTRACT on the host (127.0.0.1) : 58051 (VERSION).
The 2018-05-07 T08:54:00. 118 + 0800-00960 Oracle GoldenGate INFO OGG Manager for MySQL, MGR. Also: the Access granted (rule # 1).
The 2018-05-07 T08:54:00. 118 + 0800-00963 Oracle GoldenGate INFO OGG Manager for MySQL, MGR. Also: the Command received from the EXTRACT on the host (127.0.0.1) : 58052 (START SERVER TIMEOUT PRI CPU - 1-1 300 PARAMS).
The 2018-05-07 T08:54:00. 279 + 0800-01880 WARNING OGG Oracle GoldenGate Collector for MySQL: ALLOWOUTPUTDIR D: \ \ OGG is the same directory where this GoldenGate instance is installed.
The 2018-05-07 T08:54:00. 286 + 0800-01888 Oracle GoldenGate INFO OGG Collector for MySQL: TCP network is configured as

OS DEFAULT SPECIFIED ACTUAL VALUE
IP_DSCP N/A N/A N/A
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull