RAC Question
- From: Binh Pham <binhpham15@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>, <oracle-l-bounce@xxxxxxxxxxxxx>
- Date: Fri, 15 Feb 2008 01:00:27 +0000
I’ve just created two node RAC cluster (11.1.0.6).
The installation configured TNSNAMES as followed.
Question: Connecting from SQLPLUS and other products
to the database from my workstation to the RAC alias takes a long time before
established. However, connections to RAC1 and RAC2 alias are instantaneous.
Any idea? Thanks.
RAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST
= oelvip03)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST
= oelvip04)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =
RAC.WORLD)
)
)
RAC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST
= oelvip04)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =
RAC.WORLD)
(INSTANCE_NAME =
RAC2)
)
)
RAC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST
= oelvip03)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =
RAC.WORLD)
(INSTANCE_NAME =
RAC1)
)
)
Regards,
Binh Pham
_________________________________________________________________
Connect and share in new ways with Windows Live.
http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008
Other related posts:
