?

2.3 配置 tnsnames.ora 文件

myodbc =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = myodbc) #与上面的监听相对应

)

(HS = OK)

)

?

2.4 创建dblink

create database link myodbc connect to "root" identified by "root" using 'myodbc' ;

?

2.5 检查dblink

SQL> select * from dual@myodbc;

?

D

-

X

说明已经完成在linux平台的ORACLE连接MySQL的配置；

另：配置完2.2步骤之后可能数据库本身的监听服务就不见了，这时候可以执行，让系统进行重新注册

alter system set local_listener='(address=(protocol=tcp)(port=1521)(host= hostname))'? scope=both;?