ORACLE RAC数据库连接方式

方法1：适合中间件等JDBC等连接方法,本示例为thin方式

url="jdbc:oracle:thin:@(DESCRIPTION =

(LOAD_BALANCE = NO)

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

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

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

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

(CONNECT_DATA =

(SERVICE_NAME = srv_kfpb1)

)

)"

同时需要修改/etc/hosts文件，添加如下内容

#VIP

10.4.×.* dtydb3-vip

10.4.×.* dtydb4-vip

10.4.×.* dtydb5-vip

10.4.×.* dtydb6-vip

方法2：一般用于sqlplus、plsql等客户端工具

$ORACLE_HOME/network/admin/tnsnames.ora文件中添加如下内容

tydb_kfpb1 =

(DESCRIPTION =

(LOAD_BALANCE = NO)

(ADDRESS = (PROTOCOL =TCP)(HOST = 10.4.×.*)(PORT = 1521))

(ADDRESS = (PROTOCOL =TCP)(HOST = 10.4.×.*)(PORT = 1521))

(ADDRESS = (PROTOCOL =TCP)(HOST = 10.4.×.*)(PORT = 1521))

(ADDRESS = (PROTOCOL =TCP)(HOST = 10.4.×.*)(PORT = 1521))

(CONNECT_DATA =

(SERVICE_NAME= srv_kfpb1)

)

)

然后直接使用tydb_kfpb1进行连接

备注：黄色部分修改为自己需要的服务名