client

tnsnames.ora

RACDB=
  (DESCRIPTION =
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.131)(PORT = 1521)) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.132)(PORT = 1521)) 
      (LOAD_BALANCE = on) 
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = db)
    )
  )

1、在服务端查看数据库版本和service_name：

[oracle@rac121 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 26 10:44:24 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

SQL> show parameter service_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      db
SQL>

2、查看服务端数据库RAC配置：

SQL> host cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               localhost.localdomain localhost
::1             localhost6.localdomain6 localhost6
#Public
10.1.252.121            note1
10.1.252.122            note2

#Private
192.168.123.1           note1-priv
192.168.123.2           note2-priv

#Virtual IP
10.1.252.75             note1-vip
10.1.252.76             note2-vip
10.1.252.68             rac-scan

SQL> 

 

3、在客户端配置tnsnames.ora ,添加内容如下：

racdb=
  (DESCRIPTION =
    (ADDRESS_LIST =  
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.131)(PORT = 1521))  
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.132)(PORT = 1521))  
  
      (LOAD_BALANCE = on)  
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = db)
    )
  ) 

 

4、在客户端打开SQLPLUS测试：

     开启第1个sqlplus：

SQL> conn sys/system@racdb as sysdba
已连接。
SQL> show parameter instance_name

NAME            TYPE                VALUE
-------------   --------------      -----------
instance_name   string              db2

 

     开启第2个sqlplus：

SQL> conn sys/system@racdb as sysdba
已连接。
SQL> show parameter instance_name

NAME               TYPE               VALUE
---------------    ---------------    ---------------
instance_name      string             db1
SQL>

 

    开启第3个sqlplus：

SQL> conn sys/system@racdb as sysdba
已连接。
SQL> show parameter instance_name

NAME               TYPE               VALUE
---------------    ---------------    ---------------
instance_name      string             db2
SQL>

 

     开启第4个sqlplus：

SQL> conn sys/system@racdb as sysdba
已连接。
SQL> show parameter instance_name


NAME               TYPE               VALUE
---------------    ---------------    ---------------
instance_name      string             db1
SQL>