Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Can someone please point me to some tutorial or "how to" for configuring Jboss to work along with Oracle Data Guard. Motivation behind this is pretty standard, move some of the users to read from the "stand by" database. As this seems to be de facto industry standard i'm not have been able to find any tutorials and best practices on this.

share|improve this question
    
Asking for a tutorial/how-to is not something we get thrilled about on this site. Have you consulted the documentation for Jboss? –  pauska Dec 14 '12 at 14:46
    
No, i watched twelve episodes of Sopranos in a row and came here to bother you. I did, but i could not find any stuff. Maybe it's not there maybe i lack technical terms to better search into this issue but posting questions here is always my last option. –  tropikalista Dec 14 '12 at 15:21
add comment

1 Answer

up vote 1 down vote accepted

In short all i needed was something like this. Key part here being definition of connection URL:

 <connection-url>
 jdbc:oracle:thin:@(description=(address_list=(load_balance=on)(failover=on)(address=(protocol=tcp)(host=node1-vip)(port=1521))(address=(
 protocol=tcp)(host=node2-vip)(port=1521)))(connect_data=(service_name=myservice.org.mx) (failover_mode=(type=select)(method=basic))))
 </connection-url>

Also in StandBy database there should be links to handle inserts.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.