ORACLE RAC 配置 LOCAL_LISTENER 问题

客户的数据库服务器升级前是单机模式，本地的tnsname.ora配置如下：

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

升级为RAC热备之后变为两台数据库服务器，本地的tnsname.ora配置如下：

ywdb_online =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.4)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.14)(PORT = 1521))
    (LOAD_BALANCE=yes)
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ywdb)
    )
  )

[color=red]LOAD_BALANCE=yes[/color] 支持负载均衡

但是却总是连接不问题，时儿连上时儿连不上，搞的WEB业务服务器都总是当掉，后来请安装数据库的哥们过来看了一下现象，立刻找出原因，需要配置数据库的LOCAL_LISTENER参数：

[img]http://dl.iteye.com/upload/picture/pic/105672/29567986-8bcc-3aaf-a46a-b1aa1e36c3d3.png[/img]