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

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:583

如何配置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)

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】