[Oracle] Oracle10g通过DBLink访问MySQL示例

rpm -qa |grep mysql 
mysql-5.0.45-7.el5 
mysql-5.0.45-7.el5

yum install mysql 
yum install mysql.i386

mysql -h 192.168.1.1 -u root -p mysql

rpm -qa |grep mysql-connect

wget ftp://mirror.switch.ch/pool/3/mirror/centos/5.2/os/i386/CentO S/mysql-connector-odbc-3.51.12-2.2.i386.rpm

rpm -ivh mysql-connector-odbc-3.51.12-2.2.i386.rpm

libltdl.so.3 is needed by mysql-connector-odbc-3.51.12-2.2.i386 ，发现需要安装libtool的i386版本，因此通过如下命令安装libtool-ltdl.i386： 
yum list *.i386|grep libtool 
yum install libtool-ltdl.i386

vi /etc/odbc.ini

[test] 
Driver=/usr/lib64/libmyodbc3.so 
Description=MySQL 
Server=192.168.1.1(MySQL Server IP) 
Port=3306 
User= (MySQL Username)
UID= (MySQL Username）
Password= (MySQL PWD)
Database= (MySQL Database Name)
Option=3 
Socket=

isql -v test
quit

HS_FDS_CONNECT_INFO = test
HS_FDS_TRACE_LEVEL = on（正式使用后，不需要排错的时候应设为off） 
HS_FDS_TRACE_FILE_NAME = test.trc 
HS_FDS_SHAREABLE_NAME=/usr/lib/libmyodbc3.so 
set ODBCINI=/etc/odbc.ini

(SID_DESC =
   (SID_NAME = test) 
   (ORACLE_HOME = /ora10g) 
   (PROGRAM = hsodbc) 
   (ENVS=LD_LIBRARY_PATH=/ora10g/lib32:/usr/lib64:/ora10g/lib) 
)

SID_LIST_LISTENER = (
   SID_LIST = 
    (SID_DESC = 
       (ORACLE_HOME = /ora10g) 
       (PROGRAM = extproc) 
       (GLOBAL_DBNAME=prod) 
       (SID_NAME=prod) 
     ) 
    (SID_DESC = 
          (SID_NAME = test) 
          (ORACLE_HOME = /ora10g) 
          (PROGRAM = hsodbc) 
          (ENVS=LD_LIBRARY_PATH=/ora10g/lib32:/usr/lib64:/ora10g/lib) 
       )
) 
LISTENER = (
   DESCRIPTION_LIST = 
    (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
                 (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521)) ) 
)

su – oracle 
lsnrctl reload 
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 09-FEB-2009 13:59:38 Copyright (c) 1991, 2007, Oracle. 
All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) 
The command completed successfully 
lsnrctl status 
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 12-FEB-2009 08:56:00
Copyright (c) 1991, 2007, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias           LISTENER
Version           TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date        03-JAN-2009 03:47:39
Uptime          40 days 5 hr. 8 min. 20 sec
Trace Level         off
Security          ON: Local OS Authentication
SNMP            OFF
Listener Parameter File   /ora10g/network/admin/listener.ora
Listener Log File     /ora10g/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
  Instance "test", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

vi /ora10g/network/admin/tnsnames.ora 
test =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
  (CONNECT_DATA =
    (SID = test)
  )
    (HS = OK)
  )

create public database link MYSQL 
connect to "mysql username" identified by "mysql pwd" 
using '(DESCRIPTION = 
        (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT =1521) ) 
        (CONNECT_DATA = (SID= test) ) 
        (HS=OK) 
       )';

select * from "tablename"@test