MQSeries.net :: View topic

kevinobyrne · Posted: Tue May 20, 2008 4:49 am Post subject:

Hi All,
I originally had WMB 6.0 installed but I uninstalled it and installed 6.1, and now I'm trying to create a new broker. (Unix)

The command I'm running is:
mqsicreatebroker ESBUAT_BRKR -i mqbrk0 -a password1 -q ESBUAT -n broker_u -u mqbrk0 -p password2

The full error details:
AMQ8110: WebSphere MQ queue manager already exists.
WebSphere MQ queue manager running.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
BIP2321E: Database error: ODBC return code '-1'.
The message broker encountered an error whilst executing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database pertaining to this error.
Use the following messages to determine the cause of the error. This is likely to be such things as incorrect datasource or table names. Then correct either the database or message broker configuration.
BIP2322E: Database error: SQL State ''82''; Native Error Code '0'; Error Text ''523 80''.
The error has the following diagnostic information: SQL State ''82'' SQL Native Error Code '0' SQL Error Text ''523 80''
This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error.

BIP8040E: Unable to connect to the database.
The database cannot be accessed with the userid and password that were specified with the broker.
- Check that the database is running.
- On Windows check that an ODBC connection has been created.
- On systems which use $ODBCINI check that the file pointed to by $ODBCINI has been correctly updated.
- Check that the userid and password pair specified for ODBC connect on the mqsicreate or mqsichangebroker command are capable of being used to connect to the database using an ODBC connection.
- Check that the database has a adequate number of database connections available for use.

I have already created the QM and CM. The database is an oracle10 db running on a different machine. I have set up my .odbc.ini and tnsnames.ora and I can connect to broker_u using sqlplus. The database username and password are correct and have permission to create tables . Originally there was an mqbrk0 schema in the database, which was deleted, and a new one was created with no tables. I have run mqsi_setupdatabase.

I've read through all of the threads that mention anything like this here but I can't find any suggestions that work. It's extremely frustrating that the database error is "Database error: SQL State ''82''; Native Error Code '0'; Error Text ''523 80''.", there's not much to take from that.

Does anyone have any suggestions or solutions? I'm ready to provide any more information, thanks.