oracle failover 区别,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