| Author |
Message
|
| ydsk |
 Posted: Tue Aug 29, 2006 9:01 pm Post subject: URGENT: getting ODBC error on Solaris v6-broker |
 |
|
Chevalier
Joined: 23 May 2005
Posts: 410
|
We have a v6 broker on each of the 2 Solaris boxes. They are on 2 clustered WMQ v5.3 qmgrs, and both are running well EXCEPT that we have a problem in connecting to a user database( Oracle 9i database running on a third Unix box different from the 2 broker boxes ) from ONE of the 2 brokers.
We are getting an ODBC error when we try to connect from one of the broker boxes while we are able to connect successfully from the other broker box ( using the same msgflow/bar file deployed onto both the broker boxes - the msgflow works well on one broker BUT gives an ODBC error on the other)
We checked the TNSNAMES.ORA, .odbc.ini, etc on both the boxes and they are identical and correct. We are able to connect to the user database using SQLPlus from both the broker boxes.
DBAs confirmed that a 'TNS Ping' is successful from both the broker boxes. DBAs also apparently made their entries correctly and identically on Oracle database server side for both the broker boxes.
We followed the same steps on both the broker boxes to setup things ( like issuing mqsi_setup database, mqsisetdbparms, etc).
I am clueless as to what the problem could be and where it could be. It's driving me nuts.
Appreciate any help/hints from your experiences.
Thank you.
ydsk. |
|
| Back to top |
|
 |
| jbanoop |
| Posted: Tue Aug 29, 2006 9:58 pm Post subject: |
|
|
Chevalier
Joined: 17 Sep 2005
Posts: 401
Location: SC
|
what is the error you are getting ?
just a check , are you sure you have run mqsisetdbparms with the correct username n pwd (i mean typos or anything), would be better if you do it again.. just a thought and maybe you have tried all this ..
Regards,
Anoop |
|
| Back to top |
|
|
| PieterV |
| Posted: Wed Aug 30, 2006 3:48 am Post subject: |
|
|
Disciple
Joined: 04 Jan 2006
Posts: 164
Location: Belgium
|
is the environment variable ORACLE_HOME known to the userid of the broker?
is the oracle lib directory in LD_LIBRARY_PATH?
make sure the following is the same on both machines:
.odbc.ini
.profile
TNSNAMES.ORA
and please post the error you get. |
|
| Back to top |
|
|
| ydsk |
| Posted: Wed Aug 30, 2006 7:34 am Post subject: |
|
|
Chevalier
Joined: 23 May 2005
Posts: 410
|
Thanks everyone.
Here is the error I am getting:
BIP2321E: Database error: ODBC return code '-1'. : /build/S600_P/src/DataFlowEngine/ImbOdbc.cpp: 227: ImbOdbcHandle::checkRcInner: : BIP2322E: Database error: SQL State ''IM002''; Native Error Code '0'; Error Text ''[DataDirect][ODBC lib] Data source name not found and no default driver specified''. : /build/S600_P/src/DataFlowEngine/ImbOdbc.cpp: 355: ImbOdbcHandle::checkRcInner: : |
|
| Back to top |
|
|
| ydsk |
| Posted: Wed Aug 30, 2006 8:22 am Post subject: |
|
|
Chevalier
Joined: 23 May 2005
Posts: 410
|
The env variable ODBCINI was pointing to a wrong location, and it was changed.
The issue is resolved now.
Thank you all.
ydsk. |
|
| Back to top |
|
|
|
|
