17,137
社区成员
发帖
与我相关
我的任务
分享ORA-02019: 未找到远程数据库的连接说明
数据库建立ht的dblink测试出现下列问题
SELECT * FROM AAA@HT;
ORA-02019: 未找到远程数据库的连接说明
02019. 00000 - "connection description for remote database not found"
*Cause:
*Action:
行 2 列 19 出错
SELECT * FROM AAA@HT;
ORA-02019: 未找到远程数据库的连接说明
02019. 00000 - "connection description for remote database not found"
*Cause:
*Action:
行 2 列 19 出错
...全文
请发表友善的回复…
发表回复
lei645237 2015-09-10
- 打赏
- 举报
服务器都是我自己本地的，我做测试。
tnsname.ora 的内容：
# tnsnames.ora Network Configuration File: C:\app\TX\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
HT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
卖水果的net 2015-09-10
- 打赏
- 举报
@HT
检查一下这个 dblink ，看看对方服务器是否有变动。
可以在服务器上，查看一下 tnsname.ora 的内容，并用 sqlplus 测试一下。
