ITPub博客

首页 > Linux操作系统 > Linux操作系统 > How to connect to a system regardless of machine failure ? [akadia]

How to connect to a system regardless of machine failure ? [akadia]

原创 Linux操作系统 作者:jlandzpa 时间:2019-02-04 12:39:06 0 删除 编辑

You can place multiple address entries for a single connection alias in the TNSNAMES.ORA file. This means that you can connect to a database, even if some kind of physical failover occurred. Look at the following example:

ORA1 = (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = Host1))
(ADDRESS =
(PROTOCOL = TCP)
(HOST = Host2)))
(CONNECT_DATA=((SID=ORA1))))

Suppose Host1 is down, then every new NET8 connection using service ORA1 will automatically login to Host2. However, there is one restriction, the SID must be the same on both machines. This feature can provide guaranteed login for application servers and for the Oracle Parallel Server.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/936/viewspace-60584/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2001-10-12

  • 博文量
    268
  • 访问量
    172234