| Author |
Message
|
| team |
 Posted: Wed Jun 04, 2008 10:03 pm Post subject: Database restart requires broker to restart ? |
 |
|
Centurion
Joined: 03 Nov 2006
Posts: 108
|
I have a Webshpere Message Broker Application which has its static DB on a remote Oracle Server.
The Oracle Server has a scheduled restart everyday.
Everytime oracle server is restarted , will the broker need to be restarted to reset the DSN connection?
I tried this locally in the development environment and Broker required a restart , just trying to understand of some setting that needs to be done at the Broker / flow level so that this can be avoided.
note :Not using any Pub Sub functionalities
WMB 6.0 , Oracle 9i, Windows platform |
|
| Back to top |
|
 |
| sri_csee1983 |
| Posted: Wed Jun 04, 2008 11:43 pm Post subject: |
|
|
Centurion
Joined: 25 Mar 2008
Posts: 125
Location: Chennai,India
|
Hi Team,
I think if ur broker db is used only during the creation of broker , u no need to stop start the broker if u have restarted ur Database, but if u have used the database in any of the flows, u shud restart the broker to get the new connections. 
_________________
With Cheers,
Sri |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Thu Jun 05, 2008 12:25 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
I believe from MB V6 onwards the connection establishes automatically once you restart the database.
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Thu Jun 05, 2008 12:27 am Post subject: Re: Database restart requires broker to restart ? |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
| team wrote: |
I
The Oracle Server has a scheduled restart everyday.
Everytime oracle server is restarted ,
|
This is not a stable condition, restarting the Database every day.
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| broker_new |
| Posted: Thu Jun 05, 2008 3:19 am Post subject: |
|
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
In your case, a script has to be written such a way that it executes the mqsistop and mqsistart at some particular time.
_________________
IBM ->Let's build a smarter planet |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Jun 05, 2008 3:28 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| broker_new wrote: |
| In your case, a script has to be written such a way that it executes the mqsistop and mqsistart at some particular time. |
No, mqsireload will do just as well.
Or a certain tolerance for "errors being thrown during and after DB restart".
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
