| Author |
Message
|
| siby |
 Posted: Fri Nov 03, 2006 7:03 pm Post subject: mqsicreatebroker command fails on oracle 10G database |
 |
|
Novice
Joined: 21 Sep 2006
Posts: 12
|
Hi all,
I have installed Websphere message broker on windows 2003 standard edition.When i am creating a broker using 'mqsicreatebroker' command with oracle 10g database , i am getting following errors
BIP2321E: Database error: ODBC return code '-1'.
BIP8040E: Unable to connect to the database.
I tested ODBC connectivity successfully.
I just want to know that , Is there any additional setup for creating broker on oracle database?
Pls help me.. |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Fri Nov 03, 2006 8:10 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
If you do a search on the site you should find the additional parm for oracle.
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| PieterV |
| Posted: Mon Nov 06, 2006 6:20 am Post subject: |
|
|
Disciple
Joined: 04 Jan 2006
Posts: 164
Location: Belgium
|
=> mqsi_setupdatabase oracle10 $ORACLE_HOME
(unix) |
|
| Back to top |
|
|
| sr_aguilar |
| Posted: Wed Nov 22, 2006 10:27 am Post subject: |
|
|
Newbie
Joined: 11 Apr 2006
Posts: 4
|
| You need give to the broker's database user grants to create and update tables in his schema too. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Nov 23, 2006 6:02 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
There are a number of pages in the WMB Info Center that talk about creating, connecting and configuring databases. You probably need to go through each of them and verify that you've done everything it says about Oracle in there.
The very very very first thing to make sure is that you are using the MERANT/DataDirect driver for ODBC and not an ORACLE driver.
I don't think mqsi_setupdatabase applies to Windows.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
