oracle listener.ora配置

最新推荐文章于 2025-11-22 13:32:17 发布

原创最新推荐文章于 2025-11-22 13:32:17 发布 · 7.7k 阅读

2 ·

CC 4.0 BY-SA版权

oracle 专栏收录该内容

6 篇文章

订阅专栏

博客提示修改相关配置后需重启，展示了在Oracle环境下查看当前路径为/u01/app/oracle/product/12/db1/network/admin，列出了该目录下的文件，如listener.ora、sqlnet.ora等，还展示了查看listener.ora文件内容的操作。

改完后别忘了重启
[oracle@OSS-MDT-02 admin] $pwd /u01/app/oracle/product/12/db_1/network/admin [oracle@OSS-MDT-02 admin]$ ls
listener.ora samples shrept.lst sqlnet.ora tnsnames.ora
[oracle@OSS-MDT-02 admin]$ cat listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/12/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (SID_NAME = orcl)
      (ORACLE_HOME = /u01/app/oracle/product/12/db_1)
    )
  )

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