Details: When starting the MySQL extract process, I get the following error message:
... extract emsq0001 setenv (MYSQL_HOME="/var/lib/mysql") sourcedb ggdemo@localhost,userid root,password *** reportcount every 60 seconds, rate exttrail ./dirdat/em TRANLOGOPTIONS ALTLOGDEST /var/lib/mysql/bin-log.index TABLE ggdemo.tt_custmer; ... 2016-03-21 05:00:55 ERROR OGG-00146 Call to VAMInitialize returned with error sta tus 600: VAM Client Report <CAUSE OF FAILURE : ERROR NO 13 - Confirm that the log fil e exists, that the path is correct, and that the correct permissions are set for Orac le GoldenGate. Also try specifying the path to the log index file by using the TRANLOGOPTIONS parame ter with the ALTLOGDEST option. - /var/lib/mysql/bin-log.index WHEN FAILED : While initializing binary log configuration WHERE FAILED : MySQLBinLog Reader Module CONTEXT OF FAILURE : No Information Available!>.
Can you tell me how to resolve this?
Answer: Please make sure the parameter files setup the correct location of the binlog file. Then, you can check the privilege for GoldenGate to access the file. Make sure the bin-log.index provide the execution right shown as follows and then the extract process should be able to be started.
Answer: Please make sure the parameter files setup the correct location of the binlog file. Then, you can check the privilege for GoldenGate to access the file. Make sure the bin-log.index provide the execution right shown as follows and then the extract process should be able to be started.
[ec2-user@ip-172-30-0-198 mysql]$ ls -l total 116780 -rw-rw---- 1 mysql mysql 56 Mar 17 02:02 auto.cnf -rw-rw---- 1 mysql mysql 204 Mar 21 02:07 bin.000001 -rw-rw---- 1 mysql mysql 13 Mar 20 04:28 bin-log.index drwx------ 2 mysql mysql 4096 Mar 19 23:29 ggdemo -rw-rw---- 1 mysql mysql 18874368 Mar 20 04:28 ibdata1 -rw-rw---- 1 mysql mysql 50331648 Mar 20 04:28 ib_logfile0 -rw-rw---- 1 mysql mysql 50331648 Mar 17 02:02 ib_logfile1 -rw-rw---- 1 mysql mysql 183 Mar 20 05:28 master.info drwx------ 2 mysql mysql 4096 Mar 16 23:35 mysql -rw-rw---- 1 mysql mysql 231 Mar 20 05:25 mysqld-relay-bin.000157 -rw-rw---- 1 mysql mysql 595 Mar 20 05:26 mysqld-relay-bin.000158 -rw-rw---- 1 mysql mysql 52 Mar 20 05:25 mysqld-relay-bin.index srwxrwxrwx 2 mysql mysql 0 Mar 20 04:28 mysql.sock drwx------ 2 mysql mysql 4096 Mar 16 23:35 performance_schema -rw-rw---- 1 mysql mysql 69 Mar 20 05:28 relay-log.info [ec2-user@ip-172-30-0-198 mysql]$ sudo chmod 777 bin-log.index [ec2-user@ip-172-30-0-198 mysql]$ ls -l total 116780 -rw-rw---- 1 mysql mysql 56 Mar 17 02:02 auto.cnf -rw-rw---- 1 mysql mysql 204 Mar 21 02:07 bin.000001 -rwxrwxrwx 1 mysql mysql 13 Mar 20 04:28 bin-log.index drwx------ 2 mysql mysql 4096 Mar 19 23:29 ggdemo -rw-rw---- 1 mysql mysql 18874368 Mar 20 04:28 ibdata1 -rw-rw---- 1 mysql mysql 50331648 Mar 20 04:28 ib_logfile0 -rw-rw---- 1 mysql mysql 50331648 Mar 17 02:02 ib_logfile1 -rw-rw---- 1 mysql mysql 183 Mar 20 05:28 master.info drwx------ 2 mysql mysql 4096 Mar 16 23:35 mysql -rw-rw---- 1 mysql mysql 231 Mar 20 05:25 mysqld-relay-bin.000157 -rw-rw---- 1 mysql mysql 595 Mar 20 05:26 mysqld-relay-bin.000158 -rw-rw---- 1 mysql mysql 52 Mar 20 05:25 mysqld-relay-bin.index srwxrwxrwx 2 mysql mysql 0 Mar 20 04:28 mysql.sock drwx------ 2 mysql mysql 4096 Mar 16 23:35 performance_schema -rw-rw---- 1 mysql mysql 69 Mar 20 05:28 relay-log.info