| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| BIP2322E :: Linux Oracle Connection |
« View previous topic :: View next topic » |
| Author |
Message
|
| rbvenancio |
 Posted: Tue Sep 27, 2005 9:30 am Post subject: BIP2322E :: Linux Oracle Connection |
 |
|
Newbie
Joined: 13 Dec 2004
Posts: 8
|
Hello,
My Environment:
[SERVER]
LINUX REDHAT AS 3
WBIMB 5 CSD6 - WMQ 5.3 CSD10 - DB2 8.1.2
[CONFIG MANAGER / DEVELOPMENT]
WIN 2000
WBIMB 5 CSD6 - WMQ 5.3 CSD 10 - DB2 8.1.2
MESSAGE BROKER TOOLKIT for WSADIE 5.1.1 CDS 6
My environment is set up for use DB2 as broker database and it's working fine,
but now I want to use Oracle 8.1.7 as an aplication database, using a messageflow with ESQL...
I have the following error :
Sep 27 13:18:40 tdbtst02 MQSIv500[17947]: (LINBROKER.default)[393240]BIP2321E: Database error: ODBC return code '-1'.
: LINBROKER.012a0085-0601-0000-0080-f3aca6c03900: /build/S500_P/src/DataFlowEngine/ImbOdbc.cpp: 213: ImbOdbcHandle::checkRcInner: :
Sep 27 13:18:40 tdbtst02 MQSIv500[17947]: (LINBROKER.default)[393240]BIP2322E: Database error: SQL State '08001';
Native Error Code '0'; Error Text '[DataDirect][ODBC Oracle driver]Client unable to establish connection.'. : LINBROKER.012a0085-0601-0000-0080-f3aca6c03900: /build/S500_P/src/DataFlowEngine/ImbOdbc.cpp
My .odbc.ini
BROKER=BROKER IBM DB2 ODBC Driver
TDBSBC14=TDBSBC14 AS400 IBM DB2 ODBC Driver
EP800TST=EP800TST DataDirect 5.0 Oracle
[BROKER]
Driver=/home/db2inst1/sqllib/lib/libdb2.so
Description=BROKER DB2 ODBC Database
Database=BROKER
[TDBSBC14]
Driver=/home/db2inst1/sqllib/lib/libdb2.so
Description=TDBSBC14 DB2 ODBC Database
Database=TDBSBC14
[EP800TST]
Driver=/opt/wmqi/merant/lib/UKor820.so
Description= TOYOTA ORACLE DB
EnableDescribeParam=1
OptimizePrepare=1
ServerName=EP800TST
WorkArounds=536870912
WorkArounds2=2
[ODBC]
Trace=1
TraceFile=/var/mqsi/odbc/odbctrace.out
TraceDll=/opt/mqsi/merant/lib/odbctrac.so
InstallDir=/opt/mqsi/merant
UseCursorLib=0
IANAAppCodePage=4
Have set up the symbolic link :
ln -s /opt/ora/9.2/lib/libclntsh.so.9.0 /usr/lib/libclntsh.so
.. and mqsisetdbparms
mqsisetdbparms LINBROKER -n EP800TST -u SYSADM -p SECRET
Questions :
1) For applications databases I have to run the mqsi_setupdatabase ?
2) What's the best way to debbug this situation?
Please any help will be appreciated
Thanks VNX
Last edited by rbvenancio on Tue Sep 27, 2005 2:24 pm; edited 1 time in total |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Sep 27, 2005 9:34 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Can you establish a connection to the Oracle database outside of Broker?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| wschutz |
| Posted: Tue Sep 27, 2005 9:44 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
and isn't there something about setting $ORAHOME in the broker's environment? Is that done?
_________________
-wayne |
|
| Back to top |
|
|
| JT |
| Posted: Tue Sep 27, 2005 12:22 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Post the contents of tnsnames.ora |
|
| Back to top |
|
|
| rbvenancio |
| Posted: Tue Sep 27, 2005 1:11 pm Post subject: |
|
|
Newbie
Joined: 13 Dec 2004
Posts: 8
|
| SOLVED ... ORACLE_SID was not properly set ... Thanks |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
