远程连接oracle

最新推荐文章于 2024-05-12 22:02:06 发布

林奇lc

最新推荐文章于 2024-05-12 22:02:06 发布

阅读量363

点赞数

CC 4.0 BY-SA版权

分类专栏： Java

本文链接：https://blog.youkuaiyun.com/zlc819240815/article/details/92771593

Java 专栏收录该内容

31 篇文章

订阅专栏

博客介绍了Oracle中listener.ora文件的配置修改，将原本的(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))改为(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))，并给出了listener.ora文件的具体内容。

Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN 下的 listener.ora

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

改为

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

listener.ora内容如下

# listener.ora Network Configuration File: D:\worksoft\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\worksoft\oracle\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\worksoft\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
)
)

ADR_BASE_LISTENER = D:\worksoft\oracle