Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Automatic failover of Datasources?

62d9d15c-4467-46c8-901d-c27104d8f27dOct 13 2017 — edited Apr 1 2019

Hi Everyone,

Please Suggest for below scenario

2 Application server- Weblogic 10.3.6

ORACLE Service Bus 11.1.1.1.7

2  Oracle DB 11G machines

===========================================================

1.We have 2 parallel  OSB domain running on 2 machines and pointing to Active DB (Primary DB)

2.On DB side we have active and passive setup with Oracle Data guard in place for data replication.

QUERY:- In case of Primary DB going down HOW Automatic fail over can be achieved  on weblogic server ?

Kindly advice.

Thanks

Comments

davidp 2
Exipred messages will go into the exception queue. When I was working with a similar AQ system, I had a scheduled job to remove the expired jobs, simply by dequeueing them from the exception queue using the normal DBMS_AQ.DEQUEUE or DBMS_AQ.DEQUEUE_ARRAY.

I've changed employers since then, so I'm afraid I can't give an exact example or more detail.

Regards,
David
1 - 1

Post Details

Added on Oct 13 2017
1 comment
197 views