步骤:
1.在oracle 数据库服务器上安装odbc 驱动。
2.配置odbc
注意,需要配置 system dsn ,否则,后面会出现找不到数据源的错误
选驱动:ansi驱动,否则,有时会出现乱码。
3.设置$ORACLE_HOME/hs/admin/下面 initmysqltest.ora,内容为:
HS_FDS_CONNECT_INFO = mysql HS_FDS_TRACE_LEVEL = user
4.设置监听和网络服务别名:
listener.ora
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\oracle\product\11.2.0\db_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\product\11.2.0\db_1\bin\oraclr11.dll") )
(SID_DESC= (SID_NAME=mysqltest) (ORACLE_HOME=D:\oracle\product\11.2.0\db_1) (PROGRAM=dg4odbc) --11g,为 dg4odbc,11g以前为 hsodbc ) )
网络服务别名:
mysqltest = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)) (CONNECT_DATA=(SID=mysqltest)) (HS=OK) )
5.建立dblink
create public database link mysql connect to "root" identified by "mysql" using 'mysqltest';
6.进行验证
sql>select count(*) from ttt@mysql;
sql>select "tid","tname" from "ttt"@mysql;
到此,oracle访问mysql搞定
以上为win7上oracle访问本地mysql。
|