【练习】创建监听

最新推荐文章于 2025-08-22 14:25:18 发布

weixin_30835923

最新推荐文章于 2025-08-22 14:25:18 发布

阅读量100

点赞数

CC 4.0 BY-SA版权

文章标签：网络数据库

原文链接：http://www.cnblogs.com/tomatoes-/p/6142587.html

本文介绍Oracle数据库中监听器LISTENER及LSNR2的配置方法，包括静态注册和动态注册，并创建了使用1526端口连接到ENMOEDU数据库的连接串。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

任务一：

1）静态注册LISTENER 1521
2）动态注册LSNR2 1526

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = enmo)(PORT = 1521))
    )
  )

SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=
      (GLOBAL_DBNAME=ENMOEDU)
      (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME=ENMOEDU))
  )



LSNR2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = enmo)(PORT = 1526))
    )
  )

任务二：创建enmoedu连接串，利用1526端口可连接到数据库
--用于动态注册LSNR2监听

LSNR2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = enmo)(PORT = 1526))
    )
  )


ENMOEDU =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = enmo)(PORT = 1526))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ENMOEDU)
    )
  )