Operating System - HP-UX
1748177 Members
4386 Online
108758 Solutions
New Discussion юеВ

Dabase link Oracle(UNIX) to MySQL(Linux)

 
SOLVED
Go to solution
Marty Metras
Super Advisor

Dabase link Oracle(UNIX) to MySQL(Linux)

I want to link an Oracle9i database running on UNIX to a MySQL database running on Linux. 2 different servers.
Linking 2 Oracle databases you just create a link and make sure the Listener is running.
Under MS Windows you can use the ODBC for Oracle and MySQL. I want to use the UNIX OS to do this.

How do you get MySQL(Linux) to let Oracle(Unix) know it is there so link records to get data from MySQL.
I would like to use Oracle's SQL in a UNIX.
Maybe it is the Listener on the Linux I need. Not sure.

Can you help?
Marty
The only thing that always remain the same are the changes.
2 REPLIES 2
TwoProc
Honored Contributor
Solution

Re: Dabase link Oracle(UNIX) to MySQL(Linux)

Oracle refers to these products as "gateways". If you want to *internally* let Oracle get to MySQL (that is, the Oracle database itself can get to MySQL data, not necessarily just your application) - then you need to see if Oracle offers a gateway product/extension for MySQL.
Check out http://www.oracle.com
We are the people our parents warned us about --Jimmy Buffett
Marty Metras
Super Advisor

Re: Dabase link Oracle(UNIX) to MySQL(Linux)

Thanks John,
I got some goot Docs from Oracle's side.
Note:260981.1 looks like what I need.

Marty
The only thing that always remain the same are the changes.