GoldenGate extract with Mysql
 alienmanNov 28 2010 — edited Dec 22 2011
alienmanNov 28 2010 — edited Dec 22 2011Hi all
I had installed MySQL 5.1.41 on Ubuntu Server + OGG MySQL v11.1.1.0.3
But coud not start extract.
I don't know solve ogg-error 
somebody help me, please 
GGSCI> edit params exta
extract exta
tranlogoptions altlogdest /var/log/mysql
dboptions host 127.0.0.1, connectionport 3306
sourcedb ogg@127.0.0.1:3306, userid sender, password oracle
exttrail ./dirdat/ea
table "sender.test";
GGSCI> add extract exta, vam, begin now
GGSCI> add exttrail ./dirdat/ea, extract exta
GGSCI> view report exta
***********************************************************************
Oracle GoldenGate Capture for MySQL
Version 11.1.1.0.3 Build 001
Linux, x86, 32bit (optimized), MySQL Enterprise on Sep 29 2010 11:53:07
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.
Starting at 2010-11-29 09:58:19
***********************************************************************
Operating System Version:
Linux
Version #32-Ubuntu SMP Fri Apr 16 09:39:35 UTC 2010, Release 2.6.32-21-generic-pae
Node: ubuntu
Machine: i686
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 1232
Description: 
***********************************************************************
** Running with the following parameters **
***********************************************************************
extract exta
tranlogoptions altlogdest /var/log/mysql
dboptions host 127.0.0.1, connectionport 3306
sourcedb ogg@127.0.0.1:3306, userid sender, password ******
exttrail ./dirdat/ea
table "sender.test";
CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 2G
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 2.92G
CACHESIZEMAX (strict force to disk): 2.67G
Database Version:
MySQL
Server Version: 5.1.41-3ubuntu12.7-log
Client Version: 6.0.0
Host Connection: 127.0.0.1 via TCP/IP
Protocol Version: 10
2010-11-29 09:58:19 INFO OGG-01055 Recovery initialization completed for targe
t file ./dirdat/ea000002, at RBA 909.
2010-11-29 09:58:19 INFO OGG-01478 Output file ./dirdat/ea is using format REL
EASE 10.4/11.1.
2010-11-29 09:58:19 INFO OGG-01026 Rolling over remote file ./dirdat/ea000002.
2010-11-29 09:58:19 INFO OGG-01053 Recovery completed for target file ./dirdat
/ea000003, at RBA 909.
2010-11-29 09:58:19 INFO OGG-01057 Recovery completed for all targets.
2010-11-29 09:58:19 INFO OGG-00182 VAM API running in single-threaded mode.
2010-11-29 09:58:19 INFO OGG-01515 Positioning to begin time 2010. 11. 29. 오
전 9:32:55.
Source Context :
SourceModule : [ggvam.gen]
SourceID : [/mnt/ecloud/workspace/Build_OpenSys_r11.1.1.0.3_001_[3
6467]/perforce/src/gglib/ggvam/cvamgen.cpp]
SourceFunction : [vamInitialize]
SourceLine : [418]
ThreadBacktrace : [9] elements
: [/home/sky777a/ogg/extract(CMessageContext::AddThreadCo
ntext()+0x26) [0x83d9396]]
: [/home/sky777a/ogg/extract(CMessageFactory::CreateMessa
ge(CSourceContext*, unsigned int, ...)+0x817) [0x83cfaf7]]
: [/home/sky777a/ogg/extract(_MSG_ERR_VAM_API_ERROR_MSG(C
SourceContext*, char const*, int, char const*, CMessageFactory::MessageDisposition)
+0x8b) [0x83a67ab]]
: [/home/sky777a/ogg/extract(com_goldengate_vam::CVamGen:
:vamInitialize()+0x13c5) [0x834e095]]
: [/home/sky777a/ogg/extract(com_goldengate_vam::CVAMEXT_
initialize()+0x38b) [0x83056db]]
: [home/sky777a/ogg/extract() [0x819d69c]]
: [home/sky777a/ogg/extract(main+0xef1) [0x81c29a1]]
: [/lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe6) [
0xb6428bd6]]
: [/home/sky777a/ogg/extract(__gxx_personality_v0+0x175) 
[0x813b1b1]]
2010-11-29 09:58:19 ERROR OGG-00146 VAM function VAMInitialize returned unexpec
ted result: error 600 - VAM Client Report <CAUSE OF FAILURE : Failed to connect to 
mysql database
WHEN FAILED : While initializing mysql context
WHERE FAILED : MySQLBinLog Reader Module
CONTEXT OF FAILURE : No Information Available!>.
2010-11-29 09:58:19 ERROR OGG-01668 PROCESS ABENDING.