Oracle使用plsql本地可正常连接,远程机器连接时报错:
查看Oracle配置文件 listener.ora:
配置文件路径可通过Oracle服务的属性来查看:
listener.ora配置原始内容:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\app\***.*****
listener.ora是Oracle监听程序所读取的文件,要让其他机器从局域网连接Oracle数据库,需要写上本机在网络中的ip:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.*.***)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\app\***.*****
保存后重新启动Oracle监听服务OracleOraDb11g_home1TNSListener:
再次远程连接成功。
关于listener.ora和tnsnames.ora的作用可参考:Oracle数据库中的listener.ora和tnsnames.ora的作用