ORACLE RAC负载均衡与local_listener、remote_listener两个参数的配置关系(三)
epmdb_scan_taf =
(DESCRIPTION =
(LOAD_BALANCE = NO)
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.124.230)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = srv_epm1)
)
)
由于服务只运行于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
sys@EPMDB1(10.4.124.233)> shutdown immediate;
[grid@dtydb3 ~]$ 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
----------------
epmdb2
作者 hijk139