Oracle多实例时需要listener.ora静态注册实例

最新推荐文章于 2021-04-10 22:17:28 发布

二叉平衡木

最新推荐文章于 2021-04-10 22:17:28 发布

阅读量334

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/weixin_42193415/article/details/103366984

版权

oracle 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

/u01/app/oracle/product/12.2.0/db_1/network/admin

[oracle@oracle admin]$ cat listener.ora

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

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
)
SID_LIST_LISTENER =
(SID_LIST =
  (SID_DESC =
  (GLOBAL_DBNAME = orcl)
  (SID_NAME = orcl)
  )
  (SID_DESC =
  (GLOBAL_DBNAME = interlib)
  (SID_NAME = interlib)
  )
)

[oracle@oracle admin]$ cat tnsnames.ora

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

LISTENER_INTERLIB =
  (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))


LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))


ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
INTERLIB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = interlib)
    )
  )