Re: Connecting to a RAC instance using JDBC:thin driver

  • From: Brent Day <coloradodba@xxxxxxxxx>
  • To: sjwales@xxxxxxxxxxx
  • Date: Wed, 5 Dec 2012 05:42:45 -0700

Steve,

What about installing and using the instant client? If this is
possible, then you can setup a tnsnames.ora file with a connection
alias and appropriate connect string. Then your jdbc url becomes:
jdbc:oracle:thin:@tns_alias. Since I don't know anything about the ERP
system its hard to say if this will work, but we use this often to
keep the jdbc connect url simple and minimize application server
configuration changes related to database connect strings.

If I was in your position I would be concerned with the fact that the
ERP application vendor hasn't considered RAC. This is likely to be the
first of many challenges you will face trying to RACify.

Hope that helps.
Brent



> Is there a way to pass through a connect string to a RAC database, via the
> jdbc thin client without using parentheses in the connect string.
>
> (We have tried escaping the parentheses and using double quotes but the way
> they have their infrastructure built, it just doesn't seem to want to work)
--
//www.freelists.org/webpage/oracle-l


Other related posts: