c 连接oracle10g,如何配置oracle客户端连接10g rac 数据库

在客户端 tnsnames.ora 文件加入以下内容

RAC1 =

(DESCRIPTION =

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

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = rac.world)

(INSTANCE_NAME = rac1)

)

)

RAC2 =

(DESCRIPTION =

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

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = rac.world)

(INSTANCE_NAME = rac2)

)

)

tnsping 测试

C:\Documents and Settings\Paul Yi>tnsping rac1

TNS Ping Utility for 32-bit Windows: Version 9.2.0.8.0 - Production on 15-JUL-20

08 15:41:54

Copyright (c) 1997, 2006, Oracle Corporation.  All rights reserved.

Used parameter files:

D:\oracle\ora92\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1

.221)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = rac.wor

ld) (INSTANCE_NAME = rac1)))

OK (20 msec)

C:\Documents and Settings\Paul Yi>tnsping rac2

TNS Ping Utility for 32-bit Windows: Version 9.2.0.8.0 - Production on 15-JUL-20

08 15:45:16

Copyright (c) 1997, 2006, Oracle Corporation.  All rights reserved.

Used parameter files:

D:\oracle\ora92\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1

.222)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = rac.wor

ld) (INSTANCE_NAME = rac2)))

OK (20 msec)