MQSeries.net :: View topic - Errors running mqsicreatebroker on AIX5.3 Oracle 9.2.0.4 db

vefranco · Posted: Tue Jul 19, 2005 7:12 pm Post subject:

Working with our SA and trying to create the message broker.

The command she is running is:
mqsicreatebroker BRKRDEV1 -i mqm -a mqm -q DEVSERV301 -n brkrdev1 -u mqsystem -p *******

The errors we receive are:
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 '08001'; Native Error Code '0';
Error Text '[DataDirect][ODBC Oracle driver]Client unable to establish
connection.'.The error has the following diagnostic information: SQL State '08001' SQL Native Error Code '0' SQL Error Text
'[DataDirect][ODBC Oracle driver]Client unable to establish connection.'
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 when the broker was created.
Check that the database is running, that an ODBC connection has been
created and that the userid and password pair specified for ODBC connect
on the mqsicreate command are capable of being used to connect to the
database using an ODBC connection. Also ensure that the database has a
adequate number of database connections available for use.

the odbc.ini file is:
[ODBC Data Sources]
MQSIBKDB=IBM DB2 ODBC Driver
MYDB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 410 Oracle 8 Driver
SYBASEDB=DataDirect 410 Sybase ASE Driver
[MQSIBKDB]
Driver=/u/db2inst1/sqllib/lib/libdb2.a
Description=MQSIBKDB DB2 ODBC Database
Database=MQSIBKDB
[MYDB]
Driver=/u/db2inst1/sqllib/lib/libdb2.a
Description=MYDB DB2 ODBC Database
Database=MYDB
[ORACLEDB]
Driver=/usr/opt/wmqi/merant/lib/UKor818.so
WorkArounds=536870912
WorkArounds2=2
Description=Oracle8
ServerName=brkrdev1
EnableDescribeParam=1
OptimizePrepare=1
[SYBASEDB]
Driver=/usr/opt/wmqi/merant/lib/UKase18.so
Description=Sybase11
Database=sybasedb
ServerName=YourServerName
WorkstationID=id
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=10.30.14.72,5000
SelectUserName=1
[ODBC]
Trace=0
TraceFile=/var/wmqi/odbc/odbctrace.out
TraceDll=/usr/opt/wmqi/merant/lib/odbctrac.so
InstallDir=/usr/opt/wmqi/merant

the tnsnames.ora file is:
BRKRDEV1.HOFFMAN.ARMY.MIL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = devserv3)(PORT = 1532))
)
(CONNECT_DATA =
(SERVICE_NAME = brkrdev1)
)
)

A few other things to note:
1. user running command is "mqm", and has ORACLE_HOME and LD_LIBRARY_PATH set in its profile
2. the setupdatabase command was run
3. the userid and password used in the mscreatebroker command above has full permissions in Oracle, also I connect via SQL*Plus
4. the symbolic link was created

I tried to look at similar posts with the same 3 error messages and have exhausted what else to check.

Thanks in advance for any help.

Valerie