RAC环境listener.ora和tnsnames.ora配置总结

RAC环境下面如果LISTENER.ORA和TNSNAMES.ORA没有配置好的话最常见的会出现

ora-12545

异常；

为了达到更好的使用目的，这里做一下总结：

首先，参考书

Oracle? Database Net Services Administrator’s Guide

Oracle? Database Net Services Reference

在6节 Local Naming Parameters (tnsnames.ora)

有一句话比较重要

Do not set the 

GLOBAL_DBNAME

 parameter in the 

SID_LIST_

listener_name

 section of the 

listener.ora

. A statically configured global database name disables connect-time failover.

首先是LISTENER.ORA配置

LISTENER_${LISTENER_NAME} =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = ${VIP})(PORT = 1521)(IP = FIRST))

      (ADDRESS = (PROTOCOL = TCP)(HOST = ${public-IP})(PORT = 1521)(IP = FIRST))

    )

  )

参数:(这里配置的话确保连接不会出现前面提到的情况)

local_listener=’(ADDRESS = (PROTOCOL = TCP)(HOST = ${node1-vip})(PORT = 1521))’ sid=’node1′;

local_listener=’(ADDRESS = (PROTOCOL = TCP)(HOST = ${node2-vip})(PORT = 1521))’ sid=’node2′;

客户端配置:

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = ${NODE1-VIP})(PORT = 1521))

    (ADDRESS = (PROTOCOL = TCP)(HOST = ${NODE2-vip})(PORT = 1521))

 (LOAD_BALANCE = OFF)

 (FAILOVER = ON)

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = ${SERVICE_NAME})

      (FAILOVER_MODE =

        (TYPE = SELECT)

        (METHOD = BASIC)

        (RETRIES = 600)

        (DELAY = 1)

      )

    )

  )

这个客户端的配置，当客户端连接时，首先连接${NODE1-VIP}，然后是选择SERVICE，当SERVICE与本地跑的SID匹配时，就和NODE1建立连接，否则会连接remote_listener参数配置的节点.