Re: RAC Question

Hi,
Maybe because you have load balancing on it takes a long time to decide which node/instance to use?
I hope not, because I am setting up this scenario for a production system. Is there much of a difference in the result of a tnsping to the different aliases?

Regards

Pete

On Feb 15, 2008 1:00 AM, Binh Pham <binhpham15_at_hotmail.com> wrote:

> 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. Get it now!<http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008>
>

-- 
Regards

Pete

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