Java jdbc Oracle error: ORA-12505

最新推荐文章于 2024-09-12 11:08:23 发布

原创最新推荐文章于 2024-09-12 11:08:23 发布 · 545 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #jdbc #java #list #network #file

Oracle 专栏收录该内容

1 篇文章

订阅专栏

本文介绍如何配置Oracle数据库的Listener.ora文件以实现网络监听。具体包括设置SID_LIST_LISTENER中的SID_DESC参数，以及LISTENER中的DESCRIPTION_LIST参数等。

更改oracle Listener 配置：D:/Oracle/moon/product/11.1.0/db_1/NETWORK/ADMIN 目录之下：Listener.ora文件进行配置：

# listener.ora Network Configuration File: d:/Oracle/moon/product/11.1.0/db_1/NETWORK/ADMIN/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:/Oracle/moon/product/11.1.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = D:/Oracle/moon/product/11.1.0/db_1)
      (SID_NAME = orcl)
    )
)

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