2009年6月9日星期二

Oracle11g RAC use the vip in the address list

[oracle@croracle04 admin]$ sqlplus / as sysdba;

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jun 11 10:53:49 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> show parameter listener

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string
remote_listener string LISTENERS_CRPROD
SQL>!


[oracle@croracle04 admin]$ vi tnsnames.ora

LISTENERS_CRPROD =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = croracledb01)(PORT = 1521)) <--vip
(ADDRESS = (PROTOCOL = TCP)(HOST = croracledb02)(PORT = 1521)) <--vip
(ADDRESS = (PROTOCOL = TCP)(HOST = croracledb03)(PORT = 1521)) <--vip
(ADDRESS = (PROTOCOL = TCP)(HOST = croracledb04)(PORT = 1521)) <--vip
)

CRPROD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = croracledb01)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = croracledb02)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = croracledb03)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = croracledb04)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = crprod)
)
)

CRPROD4 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = croracledb04)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = crprod)
(INSTANCE_NAME = crprod4)
)
)

CRPROD3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = croracledb03)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = crprod)
(INSTANCE_NAME = crprod3)
)
)

CRPROD2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = croracledb02)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = crprod)
(INSTANCE_NAME = crprod2)
)
)
CRPROD1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = croracledb01)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = crprod)
(INSTANCE_NAME = crprod1)
)
)

没有评论:

发表评论