Oracle12c只能用127.0.0.1地址连接，不能远程访问问题

最新推荐文章于 2025-11-13 08:56:32 发布

原创最新推荐文章于 2025-11-13 08:56:32 发布 · 3.1w 阅读

1 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

本文介绍如何在Oracle中配置监听程序以监听局域网IP地址，并通过修改tnsnames.ora文件来添加新的服务条目。包括具体配置示例及服务重启步骤。

1.该问题需要在listener中添加局域网ip地址的监听

2.手动修改tnsnames.ora文件

仿照原有：

PDBORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PDBORCL)
)

)

LISTENER_ORCL =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)

)

本地配置添加新的配置如下：

LISTENER_ORCL2 =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.30.44)(PORT = 1521))

ORCL2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.30.44)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

PDBORCL2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.30.44)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PDBORCL)
)