两种方式:第一,①安装mysql odbc驱动,配置mysql数据源。
②配置listener.ora和tnsnames.ora,以及%oracle home%/hs/admin下增加对应的init<SID>.ora
在listener.ora中添加如下代码
(SID_DESC =
(GLOBAL_DBNAME =psms)
(SID_NAME = psms)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = hsodbc)
)
在tnsnames.ora中添加如下代码:
psms=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 端口))
)
(CONNECT_DATA =
(SERVICE_NAME = psms)
(SID=psms)
)
)
创建initpsms.ora,内容如下:
HS_FDS_CONNECT_INFO = psms
HS_FDS_TRACE_LEVEL = OFF
③创建dblink
create public database link mysqllink
connect to "用户名" identified by "密码"
using
'psms';
④执行查询 :select * from "m_user"@mysqllink;
报错:
第二,直接创建dblink
create public database link mysqllink
connect to "用户名" identified by "密码"
using
' (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 端口))
)
(CONNECT_DATA =
(SERVER_NAME = psms)
(SID=psms)
)
)';
执行select * from "m_user"@mysqllink;
我的mysql跟oracle(服务)都是装在本机,哪位高手能帮忙解答下吗?还有各处输入的用户名,密码,IP,端口所指代的是mysql的还是oracle的?