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

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@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
---
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Saad Khan
Sent: dinsdag 23 augustus 2011 18:38
To: oracle-l@xxxxxxxxxxxxx
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:@<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.
--
http://www.freelists.org/webpage/oracle-l

Other related posts: