oracle11g监听的两种方式

滴答~

于 2022-03-08 13:39:05 发布

阅读量588

点赞数

分类专栏：运维 oracle Linux 文章标签：运维 ssh

本文链接：https://blog.csdn.net/weixin_44245976/article/details/123351613

版权

Linux 同时被 3 个专栏收录

39 篇文章 1 订阅

订阅专栏

运维

23 篇文章 0 订阅

订阅专栏

oracle

6 篇文章 3 订阅

订阅专栏

动态注册:进程

lsnrctl status--查看监听的当前状态ip

LISTENER =
  (DESCRIPTION_LIST=
    (DESCRIPTION=
      (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))
      (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.13.141)(PORT= 1521))#host等于虚拟机ip地址，port端口默认等于1521
    )
  )
ADR_BASE_LISTENER=/data/oracle  

静态注册：
SID_LIST_LISTENER = 
  (SID_LIST = 
    (SID_DESC = 
      (GLOBAL_DBNAME = orcl) 
      (ORACLE_HOME = /data/oracle/product/11.2.0/dbhome_1) 
      (SID_NAME = orcl) 
    ) 
  )
LISTENER =
  (DESCRIPTION_LIST=
    (DESCRIPTION=
      (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))
      (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.13.141)(PORT= 1521))
    )
  )
ADR_BASE_LISTENER=/data/oracle