Re: A basic RAC question.. need a quick reply
- From: Ram Srinivasan <srinivasanram2004@xxxxxxxxx>
- To: saad4u@xxxxxxxxx
- Date: Wed, 24 Aug 2011 11:33:39 -0400
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@xxxxxxxxx> 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:@<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:@(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
Other related posts:
