主机：

SQL>  show parameter listener

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

local_listener                       string      (ADDRESS=(PROTOCOL=TCP)(HOST=1

33.96.107.6)(PORT=1521))

remote_listener                      string      LISTENERS_VGOPSDP

备机：

SQL> show parameter listener

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

local_listener                       string      (ADDRESS=(PROTOCOL=TCP)(HOST=1

33.96.107.7)(PORT=1521))

remote_listener                      string      LISTENERS_VGOPSDP

主机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)

)

)

%

备机tnsnames.ora

% cat tnsnames.ora

# tnsnames.ora.sdp_cmcdb02 Network Configuration File: /home/oracle/db/product/11.1.0/db_1/network/admin/tnsnames.ora.sdp_cmcdb02

# 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)

)

)

%

每次连接都会连接到备机实例上，这是不是没有实现负载均衡呢

SQL> conn

Connected.

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

vgopsdp2

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

vgopsdp2

SQL> conn

Connected.

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

vgopsdp2

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

vgopsdp2

SQL>