ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 如何配置oracle客户端连接10g rac 数据库

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

原创 Linux操作系统 作者:paulyibinyi 时间:2008-07-15 15:44:01 0 删除 编辑

在客户端 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)

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/7199859/viewspace-401672/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
学习数据库

注册时间:2007-12-11

  • 博文量
    907
  • 访问量
    6894207