| Author |
Message
|
| mdncan |
 Posted: Thu May 10, 2007 3:07 pm Post subject: MB V5 mqsicreatebroker fails on AIX 5.3 with oracle9.2.0.7.0 |
 |
|
Acolyte
Joined: 11 May 2005
Posts: 59
Location: US
|
Hello All,
I have MB 5.0.1.9 and the broker database is oracle 9.2.0.7.0: I am trying to create a broker and it fails:
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.
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 '0'; Error Text '[DataDirect][ODBC lib] Specified driver could not be loaded'.
The error has the following diagnostic information: SQL State 'IM003' SQL Native Error Code '0' SQL Error Text '[DataDirect][ODBC lib] Specified driver could not be loaded'
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.
ODBC.ini entry for oracle DB:
[ODBC Data Sources]
MWD1=DataDirect 5.0 Oracle
[MWD1]
Driver=/usr/opt/wmqi/merant/lib/UKor820.so
Description=Oracle9
WorkArounds=536870912
WorkArounds2=2
ServerName=mwd1
LogonID=mqsib
Password=mqsi
EnableDescribeParam=1
OptimizePrepare=1
Broker Service id profile has:
export ORACLE_HOME=/u001/oracle/product/9.2.0
export ORACLE_SID=mwd1
export PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/bin:$PATH
ODBCINI=/var/mqsi/odbc/.odbc.ini
export ODBCINI
LIBPATH=/var/mqsi/lib:/usr/opt/mqsi/merant/lib:/usr/opt/mqsi/lib
PATH=$PATH:/usr/opt/mqsi/bin
MQSI_REGISTRY=/var/mqsi
export MQSI_REGISTRY
export LIBPATH
export PATH
I am able to successfully login to database with sqlplus tool.
I spent good amount of time on this issue, any help on this would really appreciated.
Thanks |
|
| Back to top |
|
 |
| bhupa_sri |
| Posted: Thu May 10, 2007 9:12 pm Post subject: |
|
|
Apprentice
Joined: 30 Dec 2004
Posts: 30
Location: India
|
Hi,
Once check the Oracle driver is suitable for MB version and Data Source Name(DSN) is created proparly or not. If everything is correct then check the port whether it is open or not in AIX. |
|
| Back to top |
|
|
| mdncan |
| Posted: Fri May 11, 2007 3:35 am Post subject: |
|
|
Acolyte
Joined: 11 May 2005
Posts: 59
Location: US
|
Driver which I am using is suitable for this version of the software and the DSN is configured properly, I am able to test the DSN with sqlplus.
I am not sure which port you are talking about? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri May 11, 2007 3:46 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I'd say you either have a permissions problem on the Oracle client libraries, or the mqsi user profile is still not correct...
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mdncan |
| Posted: Fri May 11, 2007 5:31 am Post subject: |
|
|
Acolyte
Joined: 11 May 2005
Posts: 59
Location: US
|
Jeff,
Files/Folders within ORACLE_HOME are the same as another working broker machine.
I noticed one thing, when I run the:
ldd /usr/opt/mqsi/merant/lib/ UKor820.so
I am getting:
Cannot find libUKicu20.a(UKicu20.so)
Cannot find libclntsh.a(shr.o)
all others are found
Any idea on this?
Thnx |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri May 11, 2007 5:45 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| mdncan |
| Posted: Fri May 11, 2007 6:03 am Post subject: |
|
|
Acolyte
Joined: 11 May 2005
Posts: 59
Location: US
|
Jeff,
I ran the mqsi_setupdatabase several times already.
Regards. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri May 11, 2007 6:19 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Did it successfully create the links needed?
For v5, did you run the command as root?
You may need to open a PMR. And go through the v5 Info Center with a fine-toothed comb.
There may be .so files that need to be linked that aren't linked yet.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mdncan |
| Posted: Fri May 11, 2007 6:58 am Post subject: |
|
|
Acolyte
Joined: 11 May 2005
Posts: 59
Location: US
|
It did created successfully. I created with broker service id and as well as root. In both the cases it creates a link, but the ldd commands shows as cannot found error for 2 files. Those files are there, but still can't find it.
Thanks |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri May 11, 2007 7:09 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
It may be that there are dependent libs that aren't linked.
Like I said - open a PMR. I went through a lot of work in this area with v6 and XA on AIX... and I wouldn't have gotten as far as I did without IBM support.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mdncan |
| Posted: Fri May 11, 2007 7:49 am Post subject: Resolved |
|
|
Acolyte
Joined: 11 May 2005
Posts: 59
Location: US
|
Jeff,
Thanks for notes and suggestions. User profile was messed up and it was not loading the ORACLE_HOME/lib32 libraries. I have corrected it and now it's working. I was able to create the broker.
Regards |
|
| Back to top |
|
|
|
|
