| 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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
