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!

OGG for MySQL 5.7

woson_wangNov 3 2016 — edited Nov 5 2016

Recently when i set up ogg(12.2.0.1.1) for mysql (version:5.7):

When i start  the extract, it shows:

     ERROR OGG-00146  CALL to VAMInitialize returned with error status 600: VAM Client Report <CAUSE OF FAILURE:ERROR NO 13 - Confirm that the log file exists, than the path is correct, and that the correct permissions are set for oracle Goldengate.

Also try specifying the path to the log index file by using the TRANLOGOPTIONS parameter wjth the ALTLOGDEST option. - /mysql/data/NLOG.index>

     WHEN FAILED: While initializing binary log configuration

     WHERE FAILED: MySQLbinlog reader module

   CONTEXT OF FAILTURE : NO Information Available! >

>view params ext_mto

EXTRACT ext_mto

setenv (MYSQL_HOME="/mysql")

soucedb cal@localhost:3306 userid goldengate password abc123

tranlogoptions altlogdest /mysql/data/NLOG.index

exttrail ./dirdat/ex

table cal.repl

and there are some parameters in my my.cnf:

log-bin = /mysql/data/NLOG

binlog-format = ROW

log-bin-index = /mysql/data/NLOG.index

Hope you can help me ,thank you ^~^

This post has been answered by K.Gan on Nov 3 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 3 2016
Added on Nov 3 2016
6 comments
3,068 views