Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

GoldenGate extract with Mysql

alienmanNov 28 2010 — edited Dec 22 2011
Hi 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 19 2012
Added on Nov 28 2010
9 comments
1,633 views