oracle failover tnsname 的一个注意点

错误的failover配置,使用时可正常连接,但不会起到FAILOVER的效果

racdbtaf =
(DESCRIPTION =
(ADDRESS_LIST =(LOAD_BALANCE=off) (FAILOVER=ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.203)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.204)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = racdb)
)
(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(retries=6)(delay=1))
)

sqlplus dbmt/dbmt@racdbtaf

SQL> select instance_name,sid,FAILOVER_TYPE,FAILOVER_METHOD,FAILED_OVER from v$instance a,v$session b where username='DBMT';

INSTANCE_NAME           SID FAILOVER_TYPE FAILOVER_M FAI
---------------- ---------- ------------- ---------- ---
racdb1                   87 NONE          NONE       NO


节点1 shutdown abort
SQL> shutdown abort
ORACLE instance shut down.

SQL> select instance_name,sid,FAILOVER_TYPE,FAILOVER_METHOD,FAILED_OVER from v$instance a,v$session b where username='DBMT';
ERROR:
ORA-03114: 未连接到 ORACLE

正确的FAILOVER配置

racdbtaf =
(DESCRIPTION =
(ADDRESS_LIST =(LOAD_BALANCE=off) (FAILOVER=ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.203)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.204)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = racdb)
(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(retries=6)(delay=1))
)
)

sqlplus dbmt/dbmt@racdbtaf

SQL> select instance_name,sid,FAILOVER_TYPE,FAILOVER_METHOD,FAILED_OVER from v$instance a,v$session b where username='DBMT';

INSTANCE_NAME           SID FAILOVER_TYPE FAILOVER_M FAI
---------------- ---------- ------------- ---------- ---
racdb1                   87 SELECT        BASIC      NO

节点1 shutdown abort
SQL> shutdown abort
ORACLE instance shut down.

SQL> select instance_name,sid,FAILOVER_TYPE,FAILOVER_METHOD,FAILED_OVER from v$instance a,v$session b where username='DBMT';

INSTANCE_NAME           SID FAILOVER_TYPE FAILOVER_M FAI
---------------- ---------- ------------- ---------- ---
racdb2                   19 SELECT        BASIC      YES