天搞了点笑话，总结一下：
Oracle® Database Net Services Administrator’s Guide
| Oracle® Database Net Services Reference |
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配置：
[@more@]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参数配置的节点.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30036720/viewspace-1815097/ ，如需转载，请注明出处，否则将追究法律责任。
