oracle 10g failover,配置Oracle 10g RAC为客户端LOADBALANCE+FAILOVER模式

cd /u01/app/oracle/product/10.2.0/db_1/network/admin

vim tnsnames.ora

服务名如下：

BDATA =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = c1-vip)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = c2-vip)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = c3-vip)(PORT = 1521))

(LOAD_BALANCE = yes)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = bdata)

(FAILOVER_MODE =

(TYPE = session)

(METHOD = basic)

(RETRIES = 180)

(DELAY = 5)

)

)

)

保存退出

sqlplus /nolog

反复执行：

connect sys/xxxx@bdata as sysdba;

select instance_name from v$instance;

如果出现三个不同的实例轮换(c1-vip, c2-vip, c3-vip各自的实例)，那就是配置成功了。