GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

how to connect to mysql with goldengate?

edited Apr 2, 2013 4:03AM in GoldenGate, Streams and Distributed Database (MOSC) 5 commentsAnswered
 today, I just want to have a test: connect to mysql with goldengate, but failed.
my step:
1, install gg on with box which have mysql sits on.
2, config gg, like set mgr port, then start mgr, last run dblogin, but failed, error like below:

GGSCI (localhost.localdomain) 12> dblogin SOURCEDB test@localhost:3306,userid root,password abc
ERROR: Unrecognized parameter (SOURCEDB), expected USERID.


from the "help dblogin", 

<database>@&lt;host>:<port> 
 
(MySQL) Specifies a connection string that contains the database name, 
host name, and database port number. Can be used to specify a port 
other than the default that is specified in the database configuration. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center