2 Replies Latest reply on Dec 10, 2012 11:50 AM by 861120

    Unable to start extract for Mysql DB on windows


      I have installed Mysql database on windows machine, also installed GoldenGate

      and i have edited the my.cnf (C:\Program Files\MySQL\MySQL Server 5.5) file with below entries,

      log-bin="C:\Program Files\MySQL\MySQL Server 5.5\test-bin.log"



      and restarted the mysql service then add the mgr prm and created extract process.

      while trying to connect the mysql db from ggsci getting below error message

      GGSCI (PC) 29> dblogin sourcedb test, userid root

      2012-12-04 15:05:04 WARNING OGG-00769 MySQL Login failed: . SQL error (2003).
      Can't connect to MySQL server on 'localhost' (10061).
      ERROR: Failed to connect to MySQL database engine for HOST localhost, DATABASE t
      est, USER root, PORT 3306.

      also Unable to start the extract process

      edit params exta

      extract exta

      dboptions host localhost, connectionport 3306

      sourcedb test, userid root, password *****

      exttrail E:\ogg_mysql\dirdat\ea

      table test.*;

      tried with exact hostname and localhost also but no luck.

      but i can able to connect the mysql through command prompt

      C:\Users\>mysql -u root test -p

      Enter password: ******

      Welcome to the MySQL monitor. Commands end with ; or \g.
      Your MySQL connection id is 2
      Server version: 5.5.28-log MySQL Community Server (GPL)

      Copyright (c) 2000, 2012, 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

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


      Edited by: 899920 on Dec 4, 2012 1:44 AM
        • 1. Re: Unable to start extract for Mysql DB on windows
          Hi Experts,

          I can able to connect mysql db from GGSCI with dboption test@<ip address>, useris ogg, Password ****


          after configuring extract process and start , getting below error ,

          2012-12-04 23:00:12 ERROR OGG-00146 VAM function VAMInitialize returned unexpected result: error 600 - VAM Client Report <CAUSE OF FAILURE : Failed to conne
          ct to mysql database
          WHEN FAILED : While initializing mysql context
          WHERE FAILED : MySQLBinLog Reader Module
          CONTEXT OF FAILURE : No Information Available!>.

          2012-12-04 23:00:12 ERROR OGG-01668 PROCESS ABENDING.

          please help on this to resolve.
          • 2. Re: Unable to start extract for Mysql DB on windows
            Hi ...

            Please check if the mysql_home variable is ok:

            MYSQL_HOME=<MySQL bin location>

            To locate the configuration file, Extract checks the MYSQL_HOME environment variable: If MYSQL_HOME is set, Extract uses the configuration file in the specified directory. If MYSQL_HOME is not set, Extract queries the information_schema.global_variables table to determine the MySQL installation directory.

            More details: http://docs.oracle.com/cd/E35209_01/doc.1121/e27289.pdf

            Try it and put here your experiences.