Connect Oracle to MySQL on Linux

Connect Oracle to MySQL on Linux

[Preface] The method for connecting Oracle to MySQL on the Windows platform has been introduced. Most of Oracle and MySQL are now on the Linux platform, and this requirement is also available recently, let's record the entire setup process and share it with you.

[Principle] principle of connecting to MySQL through ODBC

[Description] Driver Manager: responsible for managing the communication between applications and drivers. Its main functions include parsing DSN (Data Source Name, ODBC Data Source Name in ODBC. INI file configuration), load and uninstall the driver, process ODBC calls, and pass them to the driver.

Connector/ODBC (MyODBC driver): implements the functions provided by the odbc api. It handles ODBC function calls, submits SQL requests to the MySQL server, and returns the results to the application.

ODBC. INI is an ODBC configuration file that records the driver information and database information required to connect to the server. Driver Manager will use it to determine which Driver to load (using the data source name DSN ). The driver reads the connection Parameters Based on the specified DSN.

[Configuration ideas]

To configure mysql ODBC in Linux, follow these steps:

A) install Driver Manager. In this case, unixODBC is used as the Driver Manager.

B) install the MySQL driver. In this case, Connector/ODBC

C) Configure ODBC. INI

[Environment description]

Operating System: CentOS release 6.5 (Final)

Target Database: ORACLE 11.2.0.3

Source database: mysql5.23

Procedure]

1. ODBC Configuration

1.1 install unixODBC on the target database. Script: yum install unixODBC.

1.2 install mysql-connector-odbc, download link: http://pan.baidu.com/s/1bnuiWCR password: rf98

Decompress the package and change the file name to/usr/local/