Oracle 11g links MySQL through a transparent gateway

Previously reprinted an article installed on Windows, I actually installed on the CentOS. The following are the installation records:

First, operating system environment

II. database environment (log in with Oracle user)

Third, DG4ODBC

In Oracle DB 11g, Oracle Data Gateway is installed with the database by default.

Check if the DG4ODBC driver is installed, run the following command

This prompt indicates that you have installed

Iv. view MySQL version, MySQL environment

View version

Connect MySQL to create a test table

V. To download and install the corresponding ODBC in the Oracle server

(a) If there is a Yum data source it is best to use Yum installation. The installation method is as follows:

Check to see if MySQL CONNECTOR-ODBC is installed

Installing MSYQL-CONNECTOR-ODBC

Installation Complete

(b) If no Yum data source is configured, download the RPM installation on the MySQL official website

http://dev.mysql.com/downloads/connector/odbc/

Uploading the download media to the server for manual installation may require the following dependencies to be resolved.

VI. Configuring ODBC data source names after installation is complete

(a) View Odbc.ini file, default in/etc directory

(b) Configuration Odbc.ini (Note that the server user name, password is connected to the MSYQL database, the databases is the default connection library)

(iii) test with ISQL for configuration

If not configured properly

After the configuration is ready

Seven, start to configure the transparent gateway

Create initial parameter file, default in $oracle_home/hs/admin folder

Switch to Oracle User

Add Initmysql_odbc.ora content as

Create a listener for the transparent gateway and add it to the original listening file (the default path is $oracle_home/network/admin)

Add the following content:

Restart monitoring

Lsnrctl stop

Lsnrctl start

Configure Tnsnames.ora (the default path is $oracle_home/network/admin) and add the following:

Create a database chain, test the database chain

Create Public database link Tomysql connect to "Zen" identified by "zero" using ' conn_mysql ';

This transparent gateway configuration is complete.

Attention:

You need to be aware of the case, the space, and the necessary configuration.

Oracle 11g links MySQL through a transparent gateway