Oracle性能调优：RAC负载的配置关系2
当我们连接时tydb_srv_epm1,由于顺序关系，会连接到epmdb1实例sqlplus system/oracle@tydb_srv_epm1
SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 6月 14 16:10:21 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;
www.2cto.com
INSTANCE_NAME
----------------
epmdb1
SQL> exit
连接scan IP时，由于scan listener了注册了各个数据库实例，负载均衡的效果就产生了
>sqlplus system/oracle@epmdb_scan
SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 6月 14 16:11:26 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
SQL> exit
从 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 断开
sqlplus system/oracle@epmdb_scan
Oracle性能调优：RAC负载的配置关系2
SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 6月 14 16:12:57 2012Copyright （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
----------------
epmdb3
SQL>
3,10gr2版本以上，TAF主要是通过service的配置来实现。已如下已配置的service srv_epm1为例
$ srvctl config service -d epmdb -s srv_epm1
Service name: srv_epm1
Service is enabled
Server pool: epmdb_srv_epm1
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: SELECT
Failover method: BASIC
TAF failover retries: 180
TAF failover delay: 5
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: BASIC
Edition:
Preferred instances: epmdb1
Available instances: epmdb2
tnsnames.ora的连接配置如下
epmdb_scan_taf =
（DESCRIPTION =
（LOAD_BALANCE = NO）
（ADDRESS = （PROTOCOL = TCP）（HOST = 10.4.124.230）（PORT = 1521））
（CONNECT_DATA =
（SERVICE_NAME = srv_epm1）
）
）
页:
[1]