给你个参考: 创建oracle访问mysql的数据链路步骤2008-08-08 14:32Microsoft Windows XP [版本 5.1.2600] (C) 版权所有 1985-2001 Microsoft Corp. (1)登陆到mysql C:\Documents and Settings\Administrator>mysql -h localhost -u root -p Enter password: ***** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 69 Server version: 5.0.51a-community-nt MySQL Community Edition (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the buffer. (2)创建数据库 mysql> create database oracle; Query OK, 1 row affected (0.00 sec) (3)创建被访问的mysql用户 mysql> grant all privileges on oracle.* to 'orauser'@'%' identified by 'orauser' with grant option; Query OK, 0 rows affected (0.00 sec)mysql> exit Bye (4)登陆该用户,并测试 C:\Documents and Settings\Administrator>mysql -h localhost -u orauser -p Enter password: ******* Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 70 Server version: 5.0.51a-community-nt MySQL Community Edition (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use oracle; Database changed mysql> create table test(tid integer,tname varchar(20)); Query OK, 0 rows affected (0.06 sec)mysql> insert into test(tid,tname)values(1,'byf'); Query OK, 1 row affected (0.03 sec)mysql> insert into test(tid,tname)values(2,'others'); Query OK, 1 row affected (0.02 sec)mysql> select * from test; +------+--------+ | tid | tname | +------+--------+ | 1 | byf | | 2 | others | +------+--------+ 2 rows in set (0.00 sec)mysql> (5)安装mysql odbc driver 3.51并设置odbc数据源 data source name:mysqlora server:localhost user: orauser password:orauser database:oracle (6)配置初始化参数%ORACLE_HOME%/admin/initmysqlora.ora HS_FDS_CONNECT_INFO =mysqlora HS_FDS_TRACE_LEVEL = on (7)配置%ORACLE_HOME%/newtwork/admin/tnsname.ora mysqlora= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (CONNECT_DATA = ( SID= mysqlora)) (HS=OK) ) (8)配置%ORACLE_HOME%/newtwork/admin/listener.ora LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = oradb) (ORACLE_HOME = D:\oracle) (SID_NAME = oradb) ) (SID_DESC = (PROGRAM = hsodbc) (ORACLE_HOME = D:\oracle\) (SID_NAME = mysqlora) ) ) (9)建立oracle到mysql的数据链路,并测试C:\Documents and Settings\Administrator>sqlplus /nologSQL*Plus: Release 9.2.0.1.0 - Production on 星期五 8月 8 14:17:49 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL> conn byf/1234; 已连接。SQL> create database link mysqlora 2 connect to "orauser" identified by "orauser" using 'mysqlora';数据库链接已创建。SQL> select * from test@mysqlora; tid tname ---------- -------------------- 1 byf 2 othersSQL>
创建oracle访问mysql的数据链路步骤2008-08-08 14:32Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
(1)登陆到mysql
C:\Documents and Settings\Administrator>mysql -h localhost -u root -p
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 69
Server version: 5.0.51a-community-nt MySQL Community Edition (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
(2)创建数据库
mysql> create database oracle;
Query OK, 1 row affected (0.00 sec)
(3)创建被访问的mysql用户
mysql> grant all privileges on oracle.* to 'orauser'@'%' identified by 'orauser'
with grant option;
Query OK, 0 rows affected (0.00 sec)mysql> exit
Bye
(4)登陆该用户,并测试
C:\Documents and Settings\Administrator>mysql -h localhost -u orauser -p
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 70
Server version: 5.0.51a-community-nt MySQL Community Edition (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use oracle;
Database changed
mysql> create table test(tid integer,tname varchar(20));
Query OK, 0 rows affected (0.06 sec)mysql> insert into test(tid,tname)values(1,'byf');
Query OK, 1 row affected (0.03 sec)mysql> insert into test(tid,tname)values(2,'others');
Query OK, 1 row affected (0.02 sec)mysql> select * from test;
+------+--------+
| tid | tname |
+------+--------+
| 1 | byf |
| 2 | others |
+------+--------+
2 rows in set (0.00 sec)mysql>
(5)安装mysql odbc driver 3.51并设置odbc数据源
data source name:mysqlora
server:localhost
user: orauser
password:orauser
database:oracle
(6)配置初始化参数%ORACLE_HOME%/admin/initmysqlora.ora
HS_FDS_CONNECT_INFO =mysqlora
HS_FDS_TRACE_LEVEL = on
(7)配置%ORACLE_HOME%/newtwork/admin/tnsname.ora
mysqlora=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
( SID= mysqlora))
(HS=OK)
)
(8)配置%ORACLE_HOME%/newtwork/admin/listener.ora
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = oradb)
(ORACLE_HOME = D:\oracle)
(SID_NAME = oradb)
)
(SID_DESC =
(PROGRAM = hsodbc)
(ORACLE_HOME = D:\oracle\)
(SID_NAME = mysqlora)
)
)
(9)建立oracle到mysql的数据链路,并测试C:\Documents and Settings\Administrator>sqlplus /nologSQL*Plus: Release 9.2.0.1.0 - Production on 星期五 8月 8 14:17:49 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL> conn byf/1234;
已连接。SQL> create database link mysqlora
2 connect to "orauser" identified by "orauser" using 'mysqlora';数据库链接已创建。SQL> select * from test@mysqlora; tid tname
---------- --------------------
1 byf
2 othersSQL>
%ORACLE_HOME%/hs/admin/initmysqlora.ora
靠