Re: A basic RAC question.. need a quick reply

From: Ram Srinivasan <srinivasanram2004_at_gmail.com>
Date: Wed, 24 Aug 2011 11:33:39 -0400
Message-ID: <CAKgSvf9U6oDdXqmzm2BpWstFRfPiSHE-yp1B-Pd_MnNYrhjMZQ_at_mail.gmail.com>

You can use thick clients or OCI instead of thin clients. I have sent you some papers on thick clients separately by email.

I fainted after reading the statement "50 node" RAC cluster, for example.

Thanks.
Ram Srinivasan

On Tue, Aug 23, 2011 at 12:38 PM, Saad Khan <saad4u_at_gmail.com> wrote:

> Hi,
>
> I'm new to RAC, and have a basic question. I'll appreciate if someone can
> help.
>
>
> We have got a requirement from a customer to have support for Oracle RAC. I
> need some help on this.
>
> In our product we basically read the DB URL connection string, parse it to
> get the required things done.
>
> For Standard alone database using thin driver type the format of the
> connection URL is "jdbc:oracle:thin:_at_<hostname>:<port>:<sid>".
>
> For clustered environment like Oracle RAC setup, one of the db URL
> connection string for two node environment is as listed below:
>
> jdbc:oracle:thin:_at_(DESCRIPTION=(LOAD_BALANCE=on)
> (ADDRESS=(PROTOCOL=TCP)(HOST=IP1)(PORT=P1))
>
> (ADDRESS=(PROTOCOL=TCP)
> (HOST=IP2)(PORT=P2))(CONNECT_DATA=(SERVICE_NAME=RAC.WORLD)))
>
> If the supported nodes in the environment are more than two say for example
> 50 nodes then it will be weird to have all the nodes listed in the
> connection URL. Is there any other way we can represent the connection URL.
>
>
>
> Thanks in advance.
>
> Sid.
>

-- 
Sincerely
Ram Srinivasan

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

Received on Wed Aug 24 2011 - 10:33:39 CDT