Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: JDBC connection and RAC db

Re: JDBC connection and RAC db

From: Erik Dahle <erikda_at_ifi.uio.no>
Date: Fri, 23 Jun 2006 20:56:11 +0200
Message-ID: <449c38b4$1@news.broadpark.no>


wagen123_at_yahoo.com wrote:
> Hi,
>
> Oracle10g 10.2.0.x (64 bit)
> RHEL AS 4.3 (64 bit)
>
> Our application (java) uses the following to make a connection to a
> non-RAC db.
> ("jdbc:oracle:thin:@<IP
> Address>:1521:<ORACLE_SID>","<username>","<password>");
>
> We just built a 4 node RAC cluster (testing). Can anyone help me with
> the JDBC connection info that should be used. Links to any
> documentation/examples would also be useful.

This might give you some useful information: http://e-docs.bea.com/wls/docs81/jdbc/oracle_rac.html My personal experience is that you should be very careful with load_balance=on. Depending on how your application use the database, it might give problems in certain situations.

--
Erik
Received on Fri Jun 23 2006 - 13:56:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US