ITPub博客

首页 > Linux操作系统 > Linux操作系统 > windows环境连接linux oracle10g rac 时tsname.ora配置

windows环境连接linux oracle10g rac 时tsname.ora配置

原创 Linux操作系统 作者:5功啊 时间:2012-03-16 15:23:41 0 删除 编辑

关于监听

环境介绍:

 

两个rac节点

rhel5.4 linux操作系统,oracle10g

两个节点的配置如下

#public

192.168.0.10 rac1

192.168.0.20 rac2

#priv

10.0.0.10       rac1-priv

10.0.0.20       rac2-priv

#vip

192.168.0.100   rac1-vip

192.168.0.200   rac2-vip

 

现在环境已经搭好

问题:

需要从远程win7操作系统配置sqlplus连接

win7操作系统需要做哪些配置

sqlplus如何配置?

*******************************************************************************

oracle 10g

 客户端 tnsnames.ora配置

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora

# Generated by Oracle configuration tools.

 

RAC2 =

  (DESCRIPTION =

    (ADDRESS_LIST =

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

    )

    (CONNECT_DATA =

      (SERVICE_NAME = rac)

    )

  )

 

RAC1 =

  (DESCRIPTION =

    (ADDRESS_LIST =

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

    )

    (CONNECT_DATA =

      (SERVICE_NAME = rac)

    )

  )

 

 

rac=

 (DESCRIPTION=

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

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

          (LOAD_BALANCE = yes )

          (CONNECT_DATA =

                  (SERVER = DEDICATED)

                  (SERVICE_NAME = rac)

          )

         )

        

LISTENERS_TPC =

 (ADDRESS_LIST =

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

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

  )

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

上一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2016-07-07

  • 博文量
    38
  • 访问量
    21237