RAC Question

From: Binh Pham <binhpham15_at_hotmail.com>
Date: Fri, 15 Feb 2008 01:00:27 +0000
Message-ID: <BLU130-W321F6D27A65F7F1D1A6B28D2260@phx.gbl>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 14 2008 - 19:00:27 CST