| Author |
Message
|
| rkford11 |
 Posted: Tue Jan 31, 2006 3:30 pm Post subject: broker database creation error |
 |
|
Partisan
Joined: 06 Jun 2004
Posts: 316
|
We have installed WBIMB 6.0 and oracle 10g on windows 2003. when we try to create the broker from the command console it gives us the following error
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 ''HYC00''; Native Error Code '0'; Error Text
''[Oracle][ODBC]Optional feature not implemented.''.
The error has the following diagnostic information: SQL State ''
HYC00'' SQL Native Error Code '0' SQL Error Text ''[Oracle][ODBC]
Optional feature not implemented.''
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.
I have tested the ODBC connection and it is successful, still it gives me the same error. Please guide me through this
Thanks |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Jan 31, 2006 8:27 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Are you using the right ODBC driver?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Tue Jan 31, 2006 9:02 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi rkford11,
What is the broker creation command that u are using.
What is the userid and password used for the database ?
Regards. |
|
| Back to top |
|
|
| mgk |
| Posted: Wed Feb 01, 2006 1:09 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
As Jeff Says, you are using the Oracle Driver, when you should be using the DataDirect driver provided with WMB.
In this error, the bit in bold is the Driver Provider.
[Oracle][ODBC]Optional feature not implemented
Regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| rkford11 |
| Posted: Wed Feb 01, 2006 6:41 am Post subject: |
|
|
Partisan
Joined: 06 Jun 2004
Posts: 316
|
Thanks for your replies.
my mistake was that i had been using oracle driver. |
|
| Back to top |
|
|
| wmqiadmin |
| Posted: Tue Nov 28, 2006 7:31 am Post subject: |
|
|
Disciple
Joined: 19 Jun 2005
Posts: 163
Location: epping UK
|
Hi Guys,
I have installed Broker V6 on AIX trying to setup the envt.
We have broker on Server 2 and Oracle10g on server 3, can some buddy please help me how to setup mqsi_setupdatabase command for remote Oracle database.
mqsi_setupdatabase database_type <database_install_directory>
what will be the database install directory?
Thanks
wmqiadmin |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Nov 28, 2006 7:40 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
It's the directory on the machine you're running the command on.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| wmqiadmin |
| Posted: Tue Nov 28, 2006 8:04 am Post subject: |
|
|
Disciple
Joined: 19 Jun 2005
Posts: 163
Location: epping UK
|
Hi I ran the following command and the response is:
| Quote: |
$ mqsi_setupdatabase oracle10 /opt/IBM/mqsi/6.0/bin
Creating links for oracle10 needed for WMQ.
----------------------------------------------
Creating link /var/mqm/exits/libclntsh.a to /opt/IBM/mqsi/6.0/bin/lib32/libclntsh.a
Creating link /var/mqm/exits64/libclntsh.a to /opt/IBM/mqsi/6.0/bin/lib/libclntsh.a |
| Quote: |
As per BrianR
Had you tried running
ldd /opt/ibm/mqsi/6.0/merant/lib/UKor820.so
to check all required files can be found? |
$ cd /opt/IBM/mqsi/6.0/merant/lib
$ ldd UKor820.so
UKor820.so needs:
/usr/lib/libc.a(shr.o)
Cannot find /usr/lib/libpthreads.a(shr_xpg5.o)
/usr/lib/libC.a(shr.o)
/usr/lib/libC.a(ansi_32.o)
Cannot find /usr/lib/libdl.a(shr.o)
/unix
/usr/lib/libcrypt.a(shr.o)
/usr/lib/libpthreads.a(shr_comm.o)
/usr/lib/libc_r.a(shr.o)
/usr/lib/libC.a(ansicore_32.o)
/usr/lib/libC.a(shrcore.o)
/usr/lib/libC.a(shr2.o)
/usr/lib/libC.a(shr3.o)
Can you please help? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Nov 28, 2006 8:06 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Why would you think it was the WMB product directory?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| wmqiadmin |
| Posted: Tue Nov 28, 2006 8:28 am Post subject: |
|
|
Disciple
Joined: 19 Jun 2005
Posts: 163
Location: epping UK
|
| jefflowrey wrote: |
| Why would you think it was the WMB product directory? |
As you mention where I am running the cmd so i guessed, can you please help me where should i run this cmd? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Nov 28, 2006 8:34 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Nov 28, 2006 8:36 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Also, I am sorry to say.
If you are having trouble with this, you are probably going to have a LOT more trouble.
You may want to find someone more experienced to help you.
And you certainly need to spend a lot more time reviewing the entire section on Configuring Databases in the Info Center.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| wmqiadmin |
| Posted: Tue Nov 28, 2006 8:51 am Post subject: |
|
|
Disciple
Joined: 19 Jun 2005
Posts: 163
Location: epping UK
|
Hi Jeff,
As i said, Broker is on seperate machine where i ran the command, and Database was already install and its on seperate server. So should I give ip address and port number in the install directory or should it be the Oracle client file information? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Nov 28, 2006 8:52 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
It takes a path.
It does not take an IP address.
You are in way over your head.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| wmqiadmin |
| Posted: Tue Nov 28, 2006 10:21 am Post subject: |
|
|
Disciple
Joined: 19 Jun 2005
Posts: 163
Location: epping UK
|
Hi,
I tried all the instruction and now its giving me the following error...
$ mqsicreatebroker MY_BROKER -i mqm -a *** -q MY_QMG -n ORIG01D -u WSUSER -p *******
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.
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 ''08001''; Native Error Code '12154'; Error Text ''[DataDirect][ODBC Oracle driver][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified ''.
The error has the following diagnostic information: SQL State '' 08001'' SQL Native Error Code '12154' SQL Error Text ''[DataDirec t][ODBC Oracle driver][Oracle]ORA-12154: TNS:could not resolve the connect ident ifier specified ''
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.
Can any buddy please help me.
Thanks
wmqiadmin |
|
| Back to top |
|
|
|
|
