Grouper Users - Open Discussion List

[Peter Schober <>]

* Peter DiCamillo 
<>
 [2011-06-09 20:33]:
> Thanks for the information. Sorry for the premature request-- it
> turns out that our DBAs don't have RAC installed, but use Oracle
> Data Guard. So I'll be investigating that, and would be interested
> in any information regarding use of it with Grouper.

(Not Grouper, but...)
We're using our Shibboleth IdP with a DB in a Data Guard setup (via a
container managed connection pool, not by the application) and it
works well. All that's necessary is to supply the complete
tnsnames.ora for the service in the connection string, very similar to
what Chris just posted:

url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=db.example.org)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=otherdb.example.org)(PORT=1521))(LOAD_BALANCE=
 off)(FAILOVER = on))(CONNECT_DATA=(SERVICE_NAME=FOO)))"

There's a paper availabe from Oracle, IIRC, for what database clients
can do, depending on the technology, to enable switchover and failover.
-peter