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

关于监听

环境介绍：

 

两个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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26735168/viewspace-718761/