oracle监听连接超时转移配置实例

最新推荐文章于 2023-10-13 22:00:34 发布

liuy5277

最新推荐文章于 2023-10-13 22:00:34 发布

阅读量2.7k

点赞数

分类专栏： Oracle 文章标签： oracle network tcp list file service

本文链接：https://blog.csdn.net/liuy5277/article/details/6068686

版权

Oracle 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

oracle --> cat listener.ora
# listener.ora Network Configuration File: /u01/oracle/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = liuyang)
      (ORACLE_HOME = /u01/oracle)
      (SID_NAME = liuyang)
    )
)

L1 =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.71)(PORT = 1521))
)

L2 =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.70)(PORT = 1521))
)
oracle --> cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/oracle/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LIUYANG =
(DESCRIPTION =
    (ADDRESS_LIST =
    (LOAD_BALANCE = off)
    (FAILOVER = on)
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.71)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.70)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = liuyang)
    )
)

oracle -->