oracle服务端和客户端之间的网络监听设置

最新推荐文章于 2021-04-03 02:32:50 发布

qq19398962

最新推荐文章于 2021-04-03 02:32:50 发布

阅读量1k

点赞数

分类专栏： oracle 文章标签： oracle 网络 list service tcp network

本文链接：https://blog.csdn.net/qq19398962/article/details/4201317

版权

oracle 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

oracle服务端和客户端之间的网络监听设置

假如我现在有两个数据库kkman和orcl，现在我想在服务端设立两个监听来处理从客户端发过来的连接请求。

-----------------------------------------------------------------

第一种多端口监听

1.服务端listener.ora配置

# listener.ora Network Configuration File: C:/oracle/product/10.2.0/db_1/NETWORK/ADMIN/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENERORCL =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (SID_NAME = ORCL)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = KKMAN)
      (SID_NAME = KKMAN)
    )
  )


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

2.服务端和客户端tnsnames.ora配置

# tnsnames.ora Network Configuration File: C:/oracle/product/10.2.0/client_1/NETWORK/ADMIN/tnsnames.ora
# Generated by Oracle configuration tools.

KKMAN =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = KKMAN)
    )
)

ORCL =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
)

3.重新启动监听

在服务端打开cmd运行：lsnrctl stop和lsnrctl start

--------------------------------------------------------------------------------

2.多监听单端口