会计考友 发表于 2012-8-4 14:06:19

Oracle性能调优:RAC负载的配置关系3

由于服务只运行于epmdb1,因此必定连接epmdb1实例
   
    sqlplus system/oracle@epmdb_scan_taf
   
    SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 6月 14 16:21:42 2012
   
    Copyright (c) 1982, 2005, Oracle. All rights reserved.
   
    连接到:
   
    Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
   
    With the Partitioning, Real Application Clusters, Automatic Storage Management,
   
    OLAP,
   
    Data Mining and Real Application Testing options
   
    SQL> select instance_name from v$instance;
   
    INSTANCE_NAME
   
    ----------------
   
    epmdb1
   
    数据库实例EPMDB1 down后,service发生了切换,再次连接数据库,已经运行于instane 2 .
   
    sys@EPMDB1(10.4.124.233)> shutdown immediate;
   
    $ srvctl status service -d epmdb -s srv_epm1
   
    Service srv_epm1 is running on instance(s) epmdb2
   
    www.2cto.com
   
    SQL> select instance_name from v$instance;
   
    INSTANCE_NAME
   
    ----------------
   
    epmdb1
   
    SQL> /
   
    INSTANCE_NAME
页: [1]
查看完整版本: Oracle性能调优:RAC负载的配置关系3