ORACLE服务器 内网客户端访问正常 外网客户端访问ORA-12541 无监听程序
Oracle服务器名称AAA sid=orcl 局域网IP地址 192.168.0.5 外网IP地址 220.XXX.XXX.XXX 服务器侦听listener.ora
中主机名为服务器名
内网客户端 tnsnames.ora 可以使用 一切正常
orcl_CLIENT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.5)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
外网客户端 tnsnames.ora PL/SQL连接报错 ORA-12541 无监听程序
orcl_CLIENT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 220.XXX.XXX.XXX)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)