通过plsql远程连接另一台机器的数据库,出现监听错误,修改了被连接机器oracle的LISTENER主机为计算机名后问题解决。
1,
E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = PC-20120913KQNQ)(PORT = 1521))
)
)
2,开始->Net Manager->本地->监听程序->LISTENER
tnsnames.ora文件配置:
SUNYUAN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xx.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)