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

上一篇 / 下一篇 2008-07-15 15:44:01 / 个人分类：数据库高可用性

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

RAC1 =
$TR.@R2f| PV0 (DESCRIPTION =
1o3z$Srn0    (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.221)(PORT = 1521))
x/vkXf*S0    (CONNECT_DATA =
x7b2S/?q%q%Pi0      (SERVER = DEDICATED)ITPUB个人空间7a2F[c^ ^,_
      (SERVICE_NAME = rac.world)ITPUB个人空间\9q C:A4E-S b
      (INSTANCE_NAME = rac1)
PrL9^ZO)At0    )ITPUB个人空间*j!|5JmC-Z%_2Fa%g
)ITPUB个人空间KT?!_4B
RAC2 =
\|k2ly G)cfR0 (DESCRIPTION =ITPUB个人空间9KAt9H*k-\&~e&V;@
    (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.222)(PORT = 1521))ITPUB个人空间n \*~;Ax@1?
    (CONNECT_DATA =
      (SERVER = DEDICATED)ITPUB个人空间QC P.| o']~y/n:~
      (SERVICE_NAME = rac.world)
*G"O[*TB;T(r0      (INSTANCE_NAME = rac2)ITPUB个人空间3v9DxD8\Fo"z
    )ITPUB个人空间:rM'gz"K\"sYY6x
)

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-20ITPUB个人空间+omqE!{1Ysv,[
08 15:41:54

Used parameter files:
0H8i L [y0D:\oracle\ora92\network\admin\sqlnet.ora

ITPUB个人空间c+J%WQ3F-b q$j
Used TNSNAMES adapter to resolve the alias
$uN d zTtg0Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1ITPUB个人空间GEn dx
.221)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = rac.worITPUB个人空间w2RaC-@
ld) (INSTANCE_NAME = rac1)))ITPUB个人空间#r IhY"O'tp0\
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-20ITPUB个人空间J9{1Q&Y'uMH9mf&E
08 15:45:16

Used parameter files:
)y_i^.vV8~(uA^0D:\oracle\ora92\network\admin\sqlnet.ora

ITPUB个人空间Fey5DH8h(d%VqZ
Used TNSNAMES adapter to resolve the alias
GN;]y7@V*~\H0Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1
8^3buH `^|0.222)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = rac.worITPUB个人空间+\(Q3K$uH6s*~
ld) (INSTANCE_NAME = rac2)))
h9AU#Y|O#rg&hD0OK (20 msec)