OraFAQ Forum: RAC & Failsafe » Is there a way to define a DB connection URL for two different SID names in a single URL?

Home » Server Options » RAC & Failsafe » Is there a way to define a DB connection URL for two different SID names in a single URL? (Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Is there a way to define a DB connection URL for two different SID names in a single URL? [message #549725]

Tue, 03 April 2012 05:50

alperozdamar
Messages: 1
Registered: April 2012
Location: Ankara

Junior Member

Hello,

As you see in the following MY_DB_URL there are two hosts for one SID. This is works perfectly for oracle driver. When one of them is gone down, connection establishes with the other.

MY_DB_URL = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xx.104.18)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xx.104.19)(PORT= 1521))(FAILOVER=true)(LOAD_BALANCE=false)(CONNECT_DATA=(SERVER=DEDICATED)(SID=SIDNAME_1)))

But i have a problem. Our partner uses Golden Gate product, and they said that they must install two different oracle with two different SID names. (For Example one of them is SIDNAME_1 the other is SIDNAME_2) So i can't use this URL in my application.

Is there a way to define a DB connection URL for two different SID names in a single URL???

Best Regards,

Alper Ozdamar

Ankara-Istanbul
Argela Technologies

[Updated on: Tue, 03 April 2012 05:59]

Report message to a moderator