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)
)
)
[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 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 -vip 10.1.252.76 -vip 10.1.252.68 rac-scan SQL>
racdb= (DESCRIPTION = (ADDRESS_LIST =
(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>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15187685/viewspace-754216/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15187685/viewspace-754216/