FAQ
We support an ERP application that uses the jdbc thin client to connect to
Oracle Databases.

Historically it's just been done using a single instance of a database and
the connect string looks something like this:

jdbc:oracle:thin:@node1.company.com:1521:orasid1

One customer for this vendor decided that they wanted to use RAC for their
Prod database for the failover protection.

We put together the connect string (which works as a valid connect string
when not used in this app startup scripting) as so:

jdbc:oracle:thin:@(DESCRIPTION=(ENABLE=BROKEN)(ADDRESS_LIST=(ADDRESS=(PROTOC
OL=TCP)(HOST=node1.company.com)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=node
2.company.com)(PORT=1521))(FAILOVER=on)(LOAD_BALANCE=on))(CONNECT_DATA=(SERV
ER=DEDICATED)(SERVICE_NAME=orasid1)))

It's running on a Linux environment.

The wrapper scripting for the startup of the application infrastructure
doesn't support parentheses because no one at the vendor had ever considered
RAC as an option.

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)

Thanks
Steve

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 6 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedDec 4, '12 at 10:58p
activeDec 9, '12 at 11:23a
posts6
users6
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase