oracle_11g_rac 无法实现负载均衡

每次连接实例都只能连接到同一个服务上：

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
vgopsdp1

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
vgopsdp1

SQL> SELECT INSTANCE_NUMBER, INSTANCE_NAME FROM GV$INSTANCE;

INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
1 vgopsdp1
2 vgopsdp2

SQL>

查看服务端上的tnsnames.ora配置

% cat tnsnames.ora
# tnsnames.ora Network Configuration File: /home/oracle/db/product/11.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_VGOPSDP2 =
(ADDRESS = (PROTOCOL = TCP)(HOST = flotip_2)(PORT = 1521))

LISTENER_VGOPSDP1 =
(ADDRESS = (PROTOCOL = TCP)(HOST = flotip_1)(PORT = 1521))

LISTENERS_VGOPSDP =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = flotip_1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = flotip_2)(PORT = 1521))
)

VGOPSDP2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = flotip_2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = vgopsdp)
(INSTANCE_NAME = vgopsdp2)
)
)

VGOPSDP1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = flotip_1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = vgopsdp)
(INSTANCE_NAME = vgopsdp1)
)
)

VGOPSDP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = flotip_1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = flotip_2)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = vgopsdp)
)
)

%

查看listener.ora配置

% cat listener.ora
# listener.ora.sdp_cmcdb01 Network Configuration File: /home/oracle/db/product/11.1.0/db_1/network/admin/listener.ora.sdp_cmcdb01
# Generated by Oracle configuration tools.

LISTENER_SDP_CMCDB01 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = flotip_1)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 133.96.107.8)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)

%

SQL> show parameter listener

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=133.96.107.6)(PORT=1521))
remote_listener string LISTENERS_VGOPSDP
SQL>

主备机配置相同

这样能实现负载均衡吗？

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24945904/viewspace-1041732/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24945904/viewspace-1041732/