| Author |
Message
|
| Lex |
 Posted: Tue Aug 19, 2008 3:57 am Post subject: I droped the database of the Broker .... Oooopsss.... |
 |
|
Acolyte
Joined: 14 Nov 2006
Posts: 73
|
Hey,
I just made some mistakes, i deleted my broker database (Oracle DB). I'm working with WMB 6.0 and WMQ 6.0, and the database is Oracle 10G.
I'd like to know what is the best thing to do to recreate properly the broker?
I thought about creating again the database, then create the broker user in the database so that the mqsideletebroker command works, then create the broker again with the mqsicreatebroker command. Is it good or shall I operate differently? |
|
| Back to top |
|
 |
| mqmatt |
| Posted: Tue Aug 19, 2008 4:09 am Post subject: |
|
|
Grand Master
Joined: 04 Aug 2004
Posts: 1213
Location: Hursley, UK
|
|
| Back to top |
|
|
| Lex |
| Posted: Tue Aug 19, 2008 4:18 am Post subject: |
|
|
Acolyte
Joined: 14 Nov 2006
Posts: 73
|
| It won't work, simply cause the mqsideletebroker commands is not working. It's telling me that the broker can't connect to the database, which seems normal because it doesn't exist anymore... |
|
| Back to top |
|
|
| sridhsri |
| Posted: Tue Aug 19, 2008 4:55 am Post subject: |
|
|
Master
Joined: 19 Jun 2008
Posts: 297
|
| You could delete the broker manually (if that is something you want to do). Or you could create another db with the sane name as before and then execute the command to delete the broker. |
|
| Back to top |
|
|
| Lex |
| Posted: Tue Aug 19, 2008 6:32 am Post subject: |
|
|
Acolyte
Joined: 14 Nov 2006
Posts: 73
|
Yes i finally tried this as you explained. I created a DB with the same Oracle Instance Name and i created the broker user on it, then i tried the mqsideletebroker command again and it worked.
Thanks for help folks! |
|
| Back to top |
|
|
| 5zan |
| Posted: Tue Aug 19, 2008 8:53 am Post subject: registry |
|
|
Novice
Joined: 08 Jul 2008
Posts: 24
|
| You could have simply deleted the broker form the registry if you are on windows. |
|
| Back to top |
|
|
|
|
