查看rac节点hosts文件,scan配置实用hosts文件,没有使用dns解析

tnsnames文件配置如下,SAP为全局实例名，SAP1和SAP2为各节点的实例名，安装RAC的时候自动指定的，

其他的信基本都是hosts文件里的，其中注意的是SAP1和SAP2host名字都是用是vip

[root@rac01 admin]# cat tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

SAP =

(DESCRIPTION =

(LOAD_BALANCE = OFF)

(FAILOVER = ON)

(ADDRESS_LIST =

(ADDRESS=(PROTOCOL = TCP)(HOST = rac)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = sap)

(GLOBAL_NAME = sap)

(FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC))

)

)

SAP1 =

(DESCRIPTION =

(LOAD_BALANCE = OFF)

(FAILOVER = ON)

(ADDRESS_LIST =

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

)

(CONNECT_DATA =

(SERVICE_NAME = sap1)

(FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC))

)

)

SAP2 =

(DESCRIPTION =

(LOAD_BALANCE = OFF)

(FAILOVER = ON)

(ADDRESS_LIST =

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

)

(CONNECT_DATA =

(SERVICE_NAME = sap2)

(FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC))

)

)

配置client

本例使用windows上Oracle Database Instant Client测试，可以在官网下载对应版本

安装完后，编辑本地tnsnames.ora文件

将里面添加和服务器端一样的配置

最后配置本地hosts文件，添加如下

配置完成，测试连接，

连接成功。

强制停掉一个节点rac02测试。

[root@rac01 admin]# crsctl status resource -t

--------------------------------------------------------------------------------

NAME TARGET STATE SERVER STATE_DETAILS

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.DATA.dg

ONLINE ONLINE rac01

ora.LISTENER.lsnr

ONLINE ONLINE rac01

ora.OCR.dg

ONLINE ONLINE rac01

ora.asm

ONLINE ONLINE rac01

ora.eons

ONLINE ONLINE rac01

ora.gsd

OFFLINE OFFLINE rac01

ora.net1.network

ONLINE ONLINE rac01

ora.ons

ONLINE ONLINE rac01

ora.registry.acfs

ONLINE ONLINE rac01

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE rac01

ora.oc4j

1 ONLINE ONLINE rac01

ora.rac01.vip

1 ONLINE ONLINE rac01

ora.rac02.vip

1 ONLINE INTERMEDIATE rac01 FAILED OVER

ora.sap.db

1 ONLINE ONLINE rac01

2 ONLINE OFFLINE

ora.scan1.vip

1 ONLINE ONLINE rac01

连接依然正常，这样就达到高可用的效果了。