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

From: Saad Khan <saad4u_at_gmail.com>
Date: Wed, 24 Aug 2011 10:51:41 -0400
Message-ID: <CACqGOPJX=wBJUyow-JBVJu3G5+tgMQDm_TScArTVAzb2wjXPJQ_at_mail.gmail.com>

Thanks guyz. Is there any option in Oracle 10g as well??

On Tue, Aug 23, 2011 at 12:51 PM, D'Hooge Freek <Freek.DHooge_at_uptime.be>wrote:

> Saad,
>
> If you have a working 50 rac node, then call Oracle.
> They will be thrilled to see this ;-)
>
> If you are using 11.2, you can use the single client access name (scan).
> See MOS note 11gR2 Grid Infrastructure Single Client Access Name (SCAN)
> Explained [ID 887522.1] for a detailed explanation.
> In short, SCAN enables you to use a single address line on which you can
> connect multiple ip addresses (scan ip's) in the DNS.
> Typically 3 addresses are used.
>
> Scan listeners are listening on these addresses and will forward you to the
> normal db (listeners, which are using the vip address).
> These will then startup the server process for you.
>
>
> Regards,
>
>
>
> Freek D'Hooge
> Uptime
> Oracle Database Administrator
> email: freek.dhooge_at_uptime.be
> tel +32(0)3 451 23 82
> http://www.uptime.be
> disclaimer: www.uptime.be/disclaimer
> ---
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Saad Khan
> Sent: dinsdag 23 augustus 2011 18:38
> To: oracle-l_at_freelists.org
> Subject: A basic RAC question.. need a quick reply
>
> 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.
>

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

Received on Wed Aug 24 2011 - 09:51:41 CDT