Starting at 2017-04-25 14:30:05
***********************************************************************

Operating System Version:
Linux
Version #1 SMP Mon Nov 23 12:55:32 EST 2015, Release 2.6.32-573.12.1.el6.x86_64
Node: localhost.localdomain
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited

Process id: 3844

Description:

***********************************************************************
** Running with the following parameters **
***********************************************************************

2017-04-25 14:30:05 INFO OGG-03059 Operating system character set identified as UTF-8.

2017-04-25 14:30:05 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
EXTRACT EXTR1
DBOPTIONS HOST 127.0.0.1, CONNECTIONPORT 3306
SOURCEDB user, USERID test, PASSWORD 123456
DISCARDFILE ./dirrpt/extr1.DSC, PURGE
TEBLE TEST.TCUSTMER

2017-04-25 14:30:05 WARNING OGG-10143 (extr1.prm) line 5: Parameter [TEBLE] is unrecognized and will be ignored.
No parameter definition with that name could be found.
EXTRACT EXTR1
DBOPTIONS HOST 127.0.0.1, CONNECTIONPORT 3306
SOURCEDB user, USERID test, PASSWORD ***

2017-04-25 14:30:05 WARNING OGG-00769 MySQL Login failed: . SQL error (2002). Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (2).

Source Context :
SourceModule : [ggdb.mysql.dbx]
SourceID : [/scratch/aime/adestore/views/aime_adc4150408/oggcore/OpenSys/src/gglib/ggdbmysql/dbxmy
sql.c]
SourceFunction : [open_data_source]
SourceLine : [1163]
ThreadBacktrace : [13] elements
: [/opt/gg_mysql/libgglog.so(CMessageContext::AddThreadContext()+0x26) [0x7f9132574776]]
: [/opt/gg_mysql/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int
, ...)+0x6a8) [0x7f9132567798]]
: [/opt/gg_mysql/libgglog.so(_MSG_ERR_MYSQL_CONNECT_FAILED(CSourceContext*, char const*,
ggs::gglib::ggapp::CDBObjName<(DBObjType)8> const&, ggs::gglib::ggapp::CDBObjName<(DBObjType)11> const&, int, CMess
ageFactory::MessageDisposition)+0x8f) [0x7f913252511f]]
: [/opt/gg_mysql/extract() [0x77adfd]]
: [/opt/gg_mysql/extract(gl_odbc_param(char const*, char const*, char (&) [2048])+0x634)
[0x77b534]]
: [/opt/gg_mysql/extract(get_infile_params(time_elt_def*, time_elt_def*, char**, ggs::ggl
ib::ggdatasource::DataSourceParams&, ggs::Heartbeat::MapGeneratorParams&)+0x95a7) [0x5c60b7]]
: [/opt/gg_mysql/extract() [0x5fde0c]]
: [/opt/gg_mysql/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x66) [0x75cc
66]]
: [/opt/gg_mysql/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiT
hreading::Thread::ThreadArgs*)+0x147) [0x761097]]
: [/opt/gg_mysql/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x12d)
[0x7616ad]]
: [/opt/gg_mysql/extract(main+0x3b) [0x5ff05b]]
: [/lib64/libc.so.6(__libc_start_main+0xfd) [0x366601ed5d]]
: [/opt/gg_mysql/extract() [0x53a579]]

2017-04-25 14:30:05 ERROR OGG-00770 Failed to connect to MySQL database engine for HOST localhost, DATABASE , U
SER test, PORT 3306.

2017-04-25 14:30:05 ERROR OGG-01668 PROCESS ABENDING.

***********************************************************************
Oracle GoldenGate Capture for MySQL
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401
Linux, x64, 64bit (optimized), MySQL Enterprise on Dec 11 2015 17:40:15

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.


Starting at 2017-04-25 17:48:52
***********************************************************************

Operating System Version:
Linux
Version #1 SMP Mon Nov 23 12:55:32 EST 2015, Release 2.6.32-573.12.1.el6.x86_64
Node: localhost.localdomain
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited

Process id: 4528

Description:

***********************************************************************
** Running with the following parameters **
***********************************************************************

2017-04-25 17:48:52 INFO OGG-03059 Operating system character set identified as UTF-8.

2017-04-25 17:48:52 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
EXTRACT EXTR1
DBOPTIONS HOST 127.0.0.1, CONNECTIONPORT 3306
SOURCEDB test@127.0.0.1, USERID test, PASSWORD ***

2017-04-25 17:48:52 WARNING OGG-00769 MySQL Login failed: . SQL error (1044). Access denied for user 'test'@'loca
lhost' to database 'test'.

Source Context :
SourceModule : [ggdb.mysql.dbx]
SourceID : [/scratch/aime/adestore/views/aime_adc4150408/oggcore/OpenSys/src/gglib/ggdbmysql/dbxmy
sql.c]
SourceFunction : [open_data_source]
SourceLine : [1163]
ThreadBacktrace : [13] elements
: [/opt/gg_mysql/libgglog.so(CMessageContext::AddThreadContext()+0x26) [0x7f176f9ee776]]
: [/opt/gg_mysql/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int
, ...)+0x6a8) [0x7f176f9e1798]]
: [/opt/gg_mysql/libgglog.so(_MSG_ERR_MYSQL_CONNECT_FAILED(CSourceContext*, char const*,
ggs::gglib::ggapp::CDBObjName<(DBObjType)8> const&, ggs::gglib::ggapp::CDBObjName<(DBObjType)11> const&, int, CMess
ageFactory::MessageDisposition)+0x8f) [0x7f176f99f11f]]
: [/opt/gg_mysql/extract() [0x77adfd]]
: [/opt/gg_mysql/extract(gl_odbc_param(char const*, char const*, char (&) [2048])+0x634)
[0x77b534]]
: [/opt/gg_mysql/extract(get_infile_params(time_elt_def*, time_elt_def*, char**, ggs::ggl
ib::ggdatasource::DataSourceParams&, ggs::Heartbeat::MapGeneratorParams&)+0x95a7) [0x5c60b7]]
: [/opt/gg_mysql/extract() [0x5fde0c]]
: [/opt/gg_mysql/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x66) [0x75cc
66]]
: [/opt/gg_mysql/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiT
hreading::Thread::ThreadArgs*)+0x147) [0x761097]]
: [/opt/gg_mysql/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x12d)
[0x7616ad]]
: [/opt/gg_mysql/extract(main+0x3b) [0x5ff05b]]
: [/lib64/libc.so.6(__libc_start_main+0xfd) [0x366601ed5d]]
: [/opt/gg_mysql/extract() [0x53a579]]

2017-04-25 17:48:52 ERROR OGG-00770 Failed to connect to MySQL database engine for HOST 127.0.0.1, DATABASE tes
t, USER test, PORT 3306.

2017-04-25 17:48:52 ERROR OGG-01668 PROCESS ABENDING.

GGSCI (localhost.localdomain) 7> dblogin sourcedb test@127.0.0.1,userid test , password 123456

2017-04-26 08:03:09 WARNING OGG-00769 MySQL Login failed: . SQL error (1044). Access denied for user 'test'@'localhost' to database 'test'.
ERROR: Failed to connect to MySQL database engine for HOST 127.0.0.1, DATABASE test, USER test, PORT 3306.

GGSCI (localhost.localdomain) 8> dblogin sourcedb test@127.0.0.1,userid root , password 1111
Successfully logged into database.

[root@localhost test]# mysql -u test -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 37
Server version: 5.7.18 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

***********************************************************************
Oracle GoldenGate Capture for MySQL
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401
Linux, x64, 64bit (optimized), MySQL Enterprise on Dec 11 2015 17:40:15

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.


Starting at 2017-04-26 08:11:25
***********************************************************************

Operating System Version:
Linux
Version #1 SMP Mon Nov 23 12:55:32 EST 2015, Release 2.6.32-573.12.1.el6.x86_64
Node: localhost.localdomain
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited

Process id: 7987

Description:

***********************************************************************
** Running with the following parameters **
***********************************************************************

2017-04-26 08:11:25 INFO OGG-03059 Operating system character set identified as UTF-8.

2017-04-26 08:11:25 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
EXTRACT EXTR1
DBOPTIONS HOST 127.0.0.1, CONNECTIONPORT 3306
SOURCEDB test@127.0.0.1, USERID root, PASSWORD ***
DISCARDFILE ./dirrpt/extr1.DSC, PURGE
EXTTRAIL /opt/goldengate/dirdat/aa FORMAT RELEASE 11.1
TABLE TEST.TCUSTMER;

2017-04-26 08:11:25 INFO OGG-01851 filecaching started: thread ID: 139862213515008.

2017-04-26 08:11:25 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/opt/gg_mysql/dirtmp.

CACHEMGR virtual memory values (may have been adjusted)
CACHEPAGEOUTSIZE (default): 8M
PROCESS VM AVAIL FROM OS (min): 128G
CACHESIZEMAX (strict force to disk): 96G

Database Version:
MySQL
Server Version: 5.7.18
Client Version: 5.6.14
Host Connection: 127.0.0.1 via TCP/IP
Protocol Version: 10

Database Language and Character Set:
CLIENT CHARACTER SET = "utf8mb4"
SERVER CHARACTER SET = "latin1"
DATABASE CHARACTER SET = "cp1251"
LOCALE INFORMATION = "en"
DATABASE COLLATION = "casesensitive"

2017-04-26 08:11:25 INFO OGG-01055 Recovery initialization completed for target file /opt/goldengate/dirdat/aa000000001, at RBA 977.

2017-04-26 08:11:25 INFO OGG-01478 Output file /opt/goldengate/dirdat/aa is using format RELEASE 10.4/11.1.

2017-04-26 08:11:25 INFO OGG-01026 Rolling over remote file /opt/goldengate/dirdat/aa000000001.
2017-04-26 08:15:52 INFO OGG-01053 Recovery completed for target file /opt/goldengate/dirdat/aa000000003, at R
BA 977.

2017-04-26 08:15:52 INFO OGG-01057 Recovery completed for all targets.

2017-04-26 08:15:52 INFO OGG-00182 VAM API running in single-threaded mode.

2017-04-26 08:15:52 INFO OGG-01515 Positioning to begin time 25.04.2017 13:09:17.

Source Context :
SourceModule : [ggvam.gen]
SourceID : [/scratch/aime/adestore/views/aime_adc4150408/oggcore/OpenSys/src/gglib/ggvam/cvamgen.c
pp]
SourceFunction : [vamInitialize]
SourceLine : [539]
ThreadBacktrace : [13] elements
: [/opt/gg_mysql/libgglog.so(CMessageContext::AddThreadContext()+0x26) [0x7fbd8126f776]]
: [/opt/gg_mysql/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int
, ...)+0x6a8) [0x7fbd81262798]]
: [/opt/gg_mysql/libgglog.so(_MSG_ERR_VAM_API_ERROR_MSG(CSourceContext*, char const*, int
, char const*, CMessageFactory::MessageDisposition)+0x58) [0x7fbd8122cc28]]
: [/opt/gg_mysql/extract(com_goldengate_vam::CVamGen::vamInitialize()+0x956) [0x802f66]]
: [/opt/gg_mysql/extract() [0x7b6398]]
: [/opt/gg_mysql/extract(ggs::er::VAMDataSource::finalizeConfiguration()+0x9f) [0x5f8bcf]
]
: [/opt/gg_mysql/extract() [0x5fe313]]
: [/opt/gg_mysql/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x66) [0x75cc
66]]
: [/opt/gg_mysql/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiT
hreading::Thread::ThreadArgs*)+0x147) [0x761097]]
: [/opt/gg_mysql/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x12d)
[0x7616ad]]
: [/opt/gg_mysql/extract(main+0x3b) [0x5ff05b]]
: [/lib64/libc.so.6(__libc_start_main+0xfd) [0x366601ed5d]]
: [/opt/gg_mysql/extract() [0x53a579]]

2017-04-26 08:15:53 ERROR OGG-00146 Call to VAMInitialize returned with error status 600: VAM Client Report <CA
USE OF FAILURE : NEITHER log-bin specified in my.ini/cnf NOR Index file path specified in param file
WHEN FAILED : While initializing binary log configuration
WHERE FAILED : MySQLBinLog Reader Module
CONTEXT OF FAILURE : No Information Available!>.

2017-04-26 08:15:53 ERROR OGG-01668 PROCESS ABENDING.

CREATE TABLE `TCUSTMER` (
`CUST_CODE` varchar(4) COLLATE cp1251_bin NOT NULL,
`NAME` varchar(30) COLLATE cp1251_bin DEFAULT NULL,
`CITY` varchar(20) COLLATE cp1251_bin DEFAULT NULL,
`STATE` char(2) COLLATE cp1251_bin DEFAULT NULL,
PRIMARY KEY (`CUST_CODE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin

Oracle GoldenGate Command Interpreter for MySQL
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401
Linux, x64, 64bit (optimized), MySQL Enterprise on Dec 11 2015 16:23:51
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

EXTRACT EXTR1
DBOPTIONS HOST 127.0.0.1, CONNECTIONPORT 3306
SOURCEDB test, USERID test, PASSWORD 123456
TRANLOGOPTIONS ALTLOGDEST /tmp/mysql.index
DISCARDFILE ./dirrpt/extr1.DSC, PURGE
EXTTRAIL /opt/goldengate/dirdat/aa FORMAT RELEASE 11.1
TABLE TEST.TCUSTMER;

[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
[mysqld]
character-set-server=cp1251
socket = /tmp/mysql.sock
datadir=/var/lib/mysql
symbolic-links=0
log-bin=/tmp/mysql
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

***********************************************************************
Oracle GoldenGate Capture for MySQL
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401
Linux, x64, 64bit (optimized), MySQL Enterprise on Dec 11 2015 17:40:15

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.


Starting at 2017-04-26 15:38:51
***********************************************************************

Operating System Version:
Linux
Version #1 SMP Mon Nov 23 12:55:32 EST 2015, Release 2.6.32-573.12.1.el6.x86_64
Node: localhost.localdomain
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited

Process id: 4691

Description:

***********************************************************************
** Running with the following parameters **
***********************************************************************

2017-04-26 15:38:51 INFO OGG-03059 Operating system character set identified as UTF-8.

2017-04-26 15:38:51 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
EXTRACT EXTR1
DBOPTIONS HOST 127.0.0.1, CONNECTIONPORT 3306
SOURCEDB test, USERID test, PASSWORD ***
TRANLOGOPTIONS ALTLOGDEST /tmp/mysql.index
DISCARDFILE ./dirrpt/extr1.DSC, PURGE
EXTTRAIL /opt/goldengate/dirdat/aa FORMAT RELEASE 11.1
TABLE TEST.TCUSTMER;

2017-04-26 15:38:51 INFO OGG-01851 filecaching started: thread ID: 139798624855808.

2017-04-26 15:38:51 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/opt/gg_mysql/dirtmp.

CACHEMGR virtual memory values (may have been adjusted)
CACHEPAGEOUTSIZE (default): 8M
PROCESS VM AVAIL FROM OS (min): 128G
CACHESIZEMAX (strict force to disk): 96G

Database Version:
MySQL
Server Version: 5.6.36-log
Client Version: 5.6.14
Host Connection: Localhost via UNIX socket
Protocol Version: 10

Database Language and Character Set:
CLIENT CHARACTER SET = "utf8mb4"
SERVER CHARACTER SET = "cp1251"
DATABASE CHARACTER SET = "cp1251"
LOCALE INFORMATION = "en"
DATABASE COLLATION = "casesensitive"

2017-04-26 15:38:51 INFO OGG-01055 Recovery initialization completed for target file /opt/goldengate/dirdat/aa
000000012, at RBA 986.

2017-04-26 15:38:51 INFO OGG-01478 Output file /opt/goldengate/dirdat/aa is using format RELEASE 10.4/11.1.

2017-04-26 15:38:51 INFO OGG-01026 Rolling over remote file /opt/goldengate/dirdat/aa000000012.

2017-04-26 15:38:51 INFO OGG-01053 Recovery completed for target file /opt/goldengate/dirdat/aa000000013, at R
BA 986.

2017-04-26 15:38:51 INFO OGG-01057 Recovery completed for all targets.

2017-04-26 15:38:51 INFO OGG-00182 VAM API running in single-threaded mode.

2017-04-26 15:38:51 INFO OGG-01515 Positioning to begin time 25.04.2017 13:09:17.

Source Context :
SourceModule : [ggvam.gen]
SourceID : [/scratch/aime/adestore/views/aime_adc4150408/oggcore/OpenSys/src/gglib/ggvam/cvamgen.c
pp]
SourceFunction : [vamInitialize]
SourceLine : [539]
ThreadBacktrace : [13] elements
: [/opt/gg_mysql/libgglog.so(CMessageContext::AddThreadContext()+0x26) [0x7f257acb3776]]
: [/opt/gg_mysql/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int
, ...)+0x6a8) [0x7f257aca6798]]
: [/opt/gg_mysql/libgglog.so(_MSG_ERR_VAM_API_ERROR_MSG(CSourceContext*, char const*, int
, char const*, CMessageFactory::MessageDisposition)+0x58) [0x7f257ac70c28]]
: [/opt/gg_mysql/extract(com_goldengate_vam::CVamGen::vamInitialize()+0x956) [0x802f66]]
: [/opt/gg_mysql/extract() [0x7b6398]]
: [/opt/gg_mysql/extract(ggs::er::VAMDataSource::finalizeConfiguration()+0x9f) [0x5f8bcf]
]
: [/opt/gg_mysql/extract() [0x5fe313]]
: [/opt/gg_mysql/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x66) [0x75cc
66]]
: [/opt/gg_mysql/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiT
hreading::Thread::ThreadArgs*)+0x147) [0x761097]]
: [/opt/gg_mysql/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x12d)
[0x7616ad]]
: [/opt/gg_mysql/extract(main+0x3b) [0x5ff05b]]
: [/lib64/libc.so.6(__libc_start_main+0xfd) [0x366601ed5d]]
: [/opt/gg_mysql/extract() [0x53a579]]

2017-04-26 15:38:51 ERROR OGG-00146 Call to VAMInitialize returned with error status 600: VAM Client Report <CA
USE OF FAILURE : ERROR NO 13 - Confirm that the log file exists, that the path is correct, and that the correct per
missions are set for Oracle GoldenGate.
Also try specifying the path to the log index file by using the TRANLOGOPTIONS parameter with the ALTLOGDEST option
. - /tmp/mysql.index
WHEN FAILED : While initializing binary log configuration
WHERE FAILED : MySQLBinLog Reader Module
CONTEXT OF FAILURE : No Information Available!>.

2017-04-26 15:38:51 ERROR OGG-01668 PROCESS ABENDING.

ll /tmp/mysql.index
-rw-rw---- 1 mysql mysql 18 Апр 26 15:36 /tmp/mysql.index

GGSCI (localhost.localdomain) 11> stats extr1

Sending STATS request to EXTRACT EXTR1 ...

No active extraction maps.


GGSCI (localhost.localdomain) 12> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING EXTR1 00:00:00 00:00:06
REPLICAT RUNNING REP1 00:00:00 00:00:07