| Author |
Message
|
| vignesh.gopal |
 Posted: Fri Jul 25, 2003 7:51 pm Post subject: WMQIB(cannot create broker on oracl9i(9.2.0.1)) |
 |
|
Novice
Joined: 23 Dec 2002
Posts: 24
|
Hi All,
I have a set of products and Operating Systems
On windowsNT 4.0 i have WMQIB configuration manager with DB2 7.2
and also Websphere MQ 5.3 and also a broker.
On Solaris 8 i have WMQIB ,CSD04 and Oracle9i(9.2.0.1).
I am trying to create a broker and it is giving me a database error."-1"
i have done the following
1)run the "mqsi_setupdatabase" and it has created the links.
2)changed values in /var/wmqi/odbc/.odbc.ini pointing to my "DSN" which is up and running
3)i have a user "wmqi" which is part of mqm,mqbrkrs and also it has been granted "connect,resource and create table " access for the database.
4)
/**********************/
ORACLEDB=MERANT 3.70 Oracle 8 Driver
[ORACLEDB]
Driver=/opt/wmqi/merant/lib/UKor818.so
WorkArounds=536870912
WorkArounds2=2
Description=Oracle8
ServerName=ebiz
LogonID=wmqi
Password=wmqi
EnableDescribeParam=1
OptimizePrepare=1
/**********************/
Can anyone help me .
As i have being trying to search the net ,and not able to find any support for this version of oracle and also wht could have actually gone wrong.
Thanking in anticipation
regards
Vignesh
 |
|
| Back to top |
|
 |
| EddieA |
| Posted: Sat Jul 26, 2003 7:38 pm Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
Please post all the messages related to the error. The "-1" return code is very generic. It's the other parts of the message that really tell you what's gone wrong.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| vignesh.gopal |
| Posted: Sun Jul 27, 2003 7:18 pm Post subject: clarification |
|
|
Novice
Joined: 23 Dec 2002
Posts: 24
|
# mqsicreatebroker WMQI_ORACLE_BRK8 -i wmqi -a wmqi -q WMQI_ORACLE_BRK8 -n ORACLEDB -u dbid -p dbp
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.
BIP2321E: Database error: ODBC return code '-1'.
The message broker encountered an error whilst executing a database operation. T
he ODBC return code was '-1'. See the following messages for information obtaine
d from the database pertaining to this error.
Use the following messages to determine the cause of the error. This is likely t
o be such things as incorrect datasource or table names. Then correct either the
database or message broker configuration.
BIP2322E: Database error: SQL State 'IM004'; Native Error Code '0'; Error Text '
[MERANT][ODBC lib] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed'.
The error has the following diagnostic information: SQL State 'I
M004' SQL Native Error Code '0' SQL Error Text '[MERANT][ODBC lib
] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed'
This message may be accompanied by other messages describing the effect on the m
essage broker itself. Use the reason identified in this message with the accomp
anying 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 conne
ction. Also ensure that the database has a adequate number of database connectio
ns available for use. |
|
| Back to top |
|
|
| kirani |
| Posted: Sun Jul 27, 2003 8:11 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Are you able to connect to this DB from command prompt?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| vignesh.gopal |
| Posted: Sun Jul 27, 2003 8:21 pm Post subject: |
|
|
Novice
Joined: 23 Dec 2002
Posts: 24
|
yes,thro' sql*net i am able to connect to the database.
I am also using an oracle client on a Win2k system to connect to the Oracle server on the Solaris Machine
Thanks for responding
regards
Vignesh |
|
| Back to top |
|
|
| kirani |
| Posted: Mon Jul 28, 2003 1:50 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
The DB user-id and pwd mentioned in your .odbc.ini file and mqsicreatebroker command is not matching.
You might want to this thread also,
http://www.mqseries.net/phpBB2/viewtopic.php?t=9025&highlight=oracle9
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| vignesh.gopal |
| Posted: Mon Jul 28, 2003 7:46 pm Post subject: please help |
|
|
Novice
Joined: 23 Dec 2002
Posts: 24
|
As per the link which u had given me i changed some parameters.
For DB2 ,i have directly given
[WMQIBKDB]
Driver=/export/db2inst2/sqllib/lib/libdb2_36.so
Description=WMQIBKDB DB2 ODBC Database
Database=WMQIBKDB
LogonID=DB2INST2
Password=DB2INST2
and it works.
For oracle ,i have created soft links in the /var/wmqi/lib/
libclntsh.so -> /export/oracle/oracle9i/product/9.2.0.1/lib/libclntsh.so
libwtc9.so -> /export/oracle/oracle9i/product/9.2.0.1/lib/libwtc9.so
and also changed some values in the .odbc.ini file to ....
[ORACLEDB]
Driver=/var/wmqi/lib/libclntsh.so
WorkArounds=536870912
WorkArounds2=2
Description=Oracle8
ServerName=BrokerDB
LogonID=dbid
Password=dbpw
EnableDescribeParam=1
OptimizePrepare=1
...after the above settings for oracle it still gives me the error.
mqsicreatebroker WMQI_ORACLE_BRK1 -i wmqi -a wmqi -q WMQI_ORACLE_BRK1 -n ORACLEDB -u dbid -p dbpw
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.
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 'IM003'; Native Error Code '80'; Error Text'Specified driver could not be loaded'.The error has the following diagnostic information: SQL State 'I
M003' SQL Native Error Code '80' SQL Error Text 'Specified driver could not be loaded'
This message may be accompanied by other messages describing the effect on the m
essage 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 mqsicreatecommand 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.
any help would be appreciated...
looking forward to get a couple of concrete steps which will help me resolve the problem ASAP...
Otherwise my job would be at stake...
regards
Vignesh |
|
| Back to top |
|
|
| kirani |
| Posted: Mon Jul 28, 2003 9:24 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Sorry, I couldn't be of much help here.
I'd recommend that you open a case with IBM for this problem. I also looked into WMQI Supported Software page and I don't see Oracle 9.2.0.1 there, not sure if WMQI supports this version of Oracle db.
http://www-3.ibm.com/software/integration/mqfamily/platforms/supported/wsmq_integ_for_solaris_2_1.html
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| gobi_nathan |
| Posted: Tue Jun 22, 2004 12:21 pm Post subject: |
|
|
Acolyte
Joined: 08 Jan 2003
Posts: 69
|
Hi Vignesh,
Did you solved this issue ? If so, can you hellp me how you solved this , i am facing the same problem.
Thanks in advance
Regards,
-Gobi |
|
| Back to top |
|
|
| fjcarretero |
| Posted: Tue Jun 22, 2004 11:59 pm Post subject: |
|
|
Voyager
Joined: 13 Oct 2003
Posts: 88
|
Vignesh,
I had the same problem in windows and it was a problem of permissions. I have to change the permissions of the <oracle_install>/bin directory to add mqbrkrs group with full control.
Hope this helps.
Cheers
Felipe |
|
| Back to top |
|
|
|
|
