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@xxxxxxxxxxx> 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

Other related posts: