我建了一个oracle数据库到mysql数据库的dblink:
CREATE PUBLIC DATABASE LINK myoa_test
CONNECT TO root
IDENTIFIED BY root1
USING '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.001)(PORT = 3338))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = toptest)
)
)'
显示创建完成了,然后我去查询的时候:
select * from dbo.MESSAGE_CACHE@myoa_test
会报错ora-12569:tns:包校验和失败。
有谁知道是为什么吗?
------解决方案--------------------
我表示我是来拿分的啊,给点吧