connect oracle database to mysql server

connect oracle database to mysql server

Installing MYSQL ODBC Driver on RedHAt

Installing Oracle Database Gateway for ODBC

i need to query mysql data base from oracle database on other machine.

my machine RHEL linux

#grep MemTotal /proc/meminfo

MemTotal: 16199476 kB

#grep SwapTotal /proc/meminfo

SwapTotal: 16382972 kB

#df -k /tmp

Filesystem 1K-blocks Used Available Use% Mounted on

/dev/sda3 3965120 8348 3752024 1% /tmp

#cat /etc/issue

Linux Server release 6.7

Kernel \r on an \m

#cat /proc/version

Linux version 2.6.32-573.3.1.el6.x86_64

#uname -i

x86_64

#uname -a

Linux lucky 2.6.32-573.3.1.el6.x86_64 #1 SMP Thu Aug 13 10:38:46 PDT 2015 x86_64 x86_64 x86_64 GNU/Linux

i done some steps myself but now i preferd that somebody who has experionce and knowledg aill do this job.

I have done myself but it not working

# yum localinstall [login to view URL]

# yum install mysql-connector-odbc

# yum install unixODBC

# Create [login to view URL]

# fill /etc/[login to view URL]

# fill /etc/[login to view URL]

# Installing Oracle Database Gateway for ODBC

# fill /###/app/oracle/product/[login to view URL]

odbcinst –j

unixODBC 2.2.14

DRIVERS............: /etc/[login to view URL]

SYSTEM DATA SOURCES: /etc/[login to view URL]

FILE DATA SOURCES..: /etc/ODBCDataSources

USER DATA SOURCES..: /root/.[login to view URL]

SQLULEN Size.......: 8

SQLLEN Size........: 8

SQLSETPOSIROW Size.: 8

must be someone who make this job before and know all stages
i forgot to add that the job include oracle data base link to sql query the mysql db

some links:
https://www.pythian.com/blog/how-to-access-mysql-from-oracle-with-odbc-and-sql/
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-walkthrough.html
http://docs.oracle.com/cd/B28359_01/gateways.111/e10311/toc.htm
https://docs.oracle.com/cd/B28359_01/gateways.111/b31042/installodbc.htm#BHCCEAHD

In my opinion those who already know and did this project make the project take half an hour to an hour.
So do not go overboard with price

you should connect my system via team viewer

Administración de bases de datos MySQL Oracle UNIX

Nº del proyecto: #12284074

Sobre el proyecto