sachin_dba
asked on
Database link between Oracle and MY SQL
We need to use data from My SQL database which are hosted on Windows 2003 server in Oracle 11g (Linux).
Please suggest how to start.
Please suggest how to start.
ASKER
As Oracle Heterogeneous Services was not supported for 64bit Linux, I am trying to accomplish this using Oracle 11g Database Gateway for ODBC.
Can you please share some step by step document for same?
Sachin
Can you please share some step by step document for same?
Sachin
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
just a side note from my site: I had the dblink to a mssql server already, and mssql server had a linked server to the MySQL I was then interested ... not a very nice design, but worked (a view in mssql to return the data from the mysql table, and oracle querying the mssql server view ...)
ASKER
Do we need to make some changes on MYSql as well?
The user that you are configuring to establish the link needs to exist on the mysql with the rights to the database of interest to you.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok i will look and get back
ASKER
Thanks
Make sure to adjust the ORACLE_HOME variable from the above example to match your linux ORACLE_HOME variable.
http://database.itags.org/oracle/50220/