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

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:_at_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)

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