64-bit Linux system Oracle 10 Gb heterogeneous MySQL query setup process

1. Introduction to system environment

Oracle Database Server Operating System: RHEL4.8 64-bit, IP: 192.168.12.242

Oracle Database Version: oracle 10g

Mysql database server operating system: RHEL 4.8 32-bit, IP: 192.168.5.186

Mysql database version: mysql-5.1.47

Ii. install required software packages:

MySQL-client-5.1.50-1.glibc23.i386.rpm

Http://gd.tuwien.ac.at/db/mysql/Downloads/MySQL-5.1/MySQL-client-5.1.50-1.glibc23.i386.rpm

MySQL-client-5.1.50-1.glibc23.x86_64.rpm

Http://gd.tuwien.ac.at/db/mysql/Downloads/MySQL-5.1/MySQL-client-5.1.50-1.glibc23.x86_64.rpm

Mysql-connector-odbc-3.51.27-0.i386.rpm

Http://mysql.borsen.dk/Downloads/Connector-ODBC/3.51/mysql-connector-odbc-3.51.27-0.i386.rpm

Mysql-connector-odbc-3.51.27-0.x86_64.rpm

Http://mysql.borsen.dk/Downloads/Connector-ODBC/3.51/mysql-connector-odbc-3.51.27-0.x86_64.rpm

Iii. Installation Process

1. Install the mysql client on the Oracle database server (skip this step if it has already been installed)

Rpm-ivh MySQL-client-5.1.50-1.glibc23.i386.rpm

Rpm-ivh MySQL-client-5.1.50-1.glibc23.x86_64.rpm

If a conflict is reported like file/usr/bin/msql2mysql from install of MySQL-client-5.1.50-1.glibc23 conflicts with file from package mysql-4.1.22-2.el4 during installation, You Need To uninstall the mysql-4.1.22-2.el4 and then reinstall it. However, I encountered the following problems during the installation process:

[Root @ myora ~] # Rpm e mysql-4.1.22-2.el4

Error: Failed dependencies:

Libmysqlclient. so.14 is needed by (installed) cyrus-sasl-sql-2.1.19-14.i386

Libmysqlclient. so.14 (libmysqlclient_14) is needed by (installed) cyrus-sasl-sql-2.1.19-14.i386

The way to handle such errors is, of course, to uninstall the cyrus-sasl-sql-2.1.19-14.i386, after uninstalling the mysql-4.1.22-2.el4.

Test whether the mysql database can be connected:

Mysql-h 192.168.5.186-uuser-ppassword

2. Install mysql-connector-odbc

Rpm-ivh mysql-connector-odbc-3.51.27-0.i386.rpm

Rpm-ivh mysql-connector-odbc-3.51.27-0.x86_64.rpm

In fact, for the above package, you only need to install a 32-bit package, but for the sake of security, I still install the 64-bit package.

Now all the software has been installed, isn't it easy? But the author in the previous test process took a lot of detours, such as the installation of mysql-connector-odbc-5.1.7-0.x86_64.rpm and mysql-connector-odbc-5.1.7-0.i386.rpm. Some problems are caused. The discount in the middle zone is really a lot of money. In fact, only after installing What You Need Can you find that you are very close to the real purpose. Sometimes you only need to take a step back.

1 2 Next Page