MQSeries.net :: View topic - Broker V6 connection to Host Oracle DB Problem

SABCAS · Posted: Mon Mar 31, 2008 6:54 am Post subject:

Hallo
I want to connect via odbc den Broker to a Host Oracle DB hier you can see the odbc.ini File:
[ODBC Data Sources]
I0SIFPAP=IBM DB2 ODBC Driver
WBIMBBK1=IBM DB2 ODBC Driver
WBIMBCM1=IBM DB2 ODBC Driver
NOVISA=DataDirect 5.0 Oracle

[ODBC]
Trace=0
TraceFile=/log/mqsi/odbctrace.out
TraceDll=/opt/IBM/mqsi/6.0/merant/lib/odbctrac.so
InstallDir=/opt/IBM/mqsi/6.0/merant
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

[I0SIFPAP]
Driver=/prod/db2/db2t06i0/sqllib/lib/libdb2.a
Description=SIF MPM Database Configuration 01
Database=I0SIFPAP

[WBIMBBK1]
Driver=/opt/IBM/db2/V9.1/lib64/libdb2.a
Description=Broker Database
Database=WBIMBBK1

[WBIMBCM1]
Driver=/opt/IBM/db2/V9.1/lib64/libdb2.a
Description=ConfigMgr Database
Database=WBIMBCM1

[NOVISA]
Driver=/opt/IBM/mqsi/6.0/merant/lib/UKor820.so
Description=DataDirect 5.0 Oracle
EnableDescribeParam=1
OptimizePrepare=1
ServerName=sbe22734.corproot.net
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
SelectMethod=0
NetworkAddress=10.49.28.182,1521
SelectUserName=1

I have also the Variables LIBPATH and LD_LIBRARY_PATH set:
$LIBPATH
ksh: /opt/IBM/mqsi/6.0/jre/bin:/opt/IBM/mqsi/6.0/jre/bin/classic:/usr/mqm/java/l
ib:/opt/IBM/mqsi/6.0/lib:/opt/IBM/mqsi/6.0/bin:/opt/IBM/mqsi/6.0/merant/lib:/opt
/IBM/mqsi/6.0/xml4c/lib::/usr/lib: not found.
tgdcasa3@/lhome/tgdcasa3> $LD_LIBRARY_PATH
ksh: /opt/IBM/mqsi/6.0/lib:/opt/IBM/mqsi/6.0/bin:/opt/IBM/mqsi/6.0/merant/lib:/o
pt/IBM/mqsi/6.0/xml4c/lib:/opt/IBM/mqsi/6.0/lib:/opt/IBM/mqsi/6.0/bin:/opt/IBM/m
qsi/6.0/merant/lib:/opt/IBM/mqsi/6.0/xml4c/lib::/usr/lib:/usr/lib: not found.

But I receive always the error message :
<ERROR><SOURCE>SifUnityDBSender</SOURCE><TIME>2008-03-31 16:37:58.471073</TIME><PROPERTIES><MessageSet></MessageSet><MessageType></MessageType><MessageFormat></MessageFormat><Encoding>273</Encoding><CodedCharSetId>819</CodedCharSetId><Transactional>TRUE</Transactional><Persistence>FALSE</Persistence><CreationTime>2008-03-31 14:37:58.420</CreationTime><ExpirationTime>-1</ExpirationTime><Priority>0</Priority><ReplyIdentifier>000000000000000000000000000000000000000000000000</ReplyIdentifier><ReplyProtocol>MQ</ReplyProtocol><Topic></Topic><ContentType></ContentType></PROPERTIES><MQMD><SourceQueue>SIF.UNITYDB.RECEIVE.A</SourceQueue><Transactional>TRUE</Transactional><Encoding>273</Encoding><CodedCharSetId>819</CodedCharSetId><Format>MQSTR </Format><Version>2</Version><Report>0</Report><MsgType>8</MsgType><Expiry>-1</Expiry><Feedback>0</Feedback><Priority>0</Priority><Persistence>0</Persistence><MsgId>414d51204d512e534245313738392e4147f0f3fc20022202</MsgId><CorrelId>000000000000000000000000000000000000000000000000</CorrelId><BackoutCount>0</BackoutCount><ReplyToQ> </ReplyToQ><ReplyToQMgr>MQ.SBE1789.AIX.D </ReplyToQMgr><UserIdentifier>mqm </UserIdentifier><AccountingToken>0000000000000000000000000000000000000000000000000000000000000000</AccountingToken><ApplIdentityData> </ApplIdentityData><PutApplType>28</PutApplType><PutApplName>MQSeries Client for Java </PutApplName><PutDate>2008-03-31</PutDate><PutTime>14:37:58.420</PutTime><ApplOriginData> </ApplOriginData><GroupId>000000000000000000000000000000000000000000000000</GroupId><MsgSeqNumber>1</MsgSeqNumber><Offset>0</Offset><MsgFlags>0</MsgFlags><OriginalLength>-1</OriginalLength></MQMD><MSG xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="I_SubscriberNotify-SIFM.xsd">
.<Header id="npa000001">
..<Requester>
...<ApplicationID bo="" application="com.swisscom.spt.unidb"/>
..</Requester>
..<BSR revision="1" function="SubscriberNotify">
...<ApplicationID bo="" application="com.swisscom.unidb.spt"/>
..</BSR>
..<Environment opCode="" language="de" testFlag="no" prefix="">
...<Timestamp>2001-12-17T09:30:47.0Z</Timestamp>
..</Environment>
..<FunctionHeader functionType="Datagramm" responseType="onExecution" priorityType="medium" returnCode="success"/>
.</Header>
.<SubscriberNotify>
..<MsgId>1</MsgId>
..<VLineId>1234567890</VLineId>
..<PoolType>pool1</PoolType>
..<TerminationType>ISP</TerminationType>
..<UpstreamSpeed>500</UpstreamSpeed>
..<DownstreamSpeed>5000</DownstreamSpeed>
..<FixedIP>85.5.85.100</FixedIP>
..<DhcpSessionState>activated</DhcpSessionState>
..<BrasName>ipc-bpa640-r-br-01</BrasName>
..<BrasPort>GE 1/1.1234</BrasPort>
.</SubscriberNotify>
</MSG><EXEPTLIST><RecoverableException><File>/build/S600_P/src/DataFlowEngine/ImbComputeNode.cpp</File><Line>464</Line><Function>ImbComputeNode::evaluate</Function><Type>ComIbmComputeNode</Type><Name>SifUnityDBSender#FCMComposite_1_4</Name><Label>SifUnityDBSender.CALL_STORE_PROCEDURES</Label><Catalog>BIPv600</Catalog><Severity>3</Severity><Number>2230</Number><Text>Caught exception and rethrowing</Text><DatabaseException><File>/build/S600_P/src/DataFlowEngine/ImbOdbc.cpp</File><Line>228</Line><Function>ImbOdbcHandle::checkRcInner</Function><Type></Type><Name></Name><Label></Label><Catalog>BIPv600</Catalog><Severity>3</Severity><Number>2321</Number><Text>Root SQL exception</Text><Insert><Type>2</Type><Text>-1</Text></Insert><DatabaseException><File>/build/S600_P/src/DataFlowEngine/ImbOdbc.cpp</File><Line>357</Line><Function>ImbOdbcHandle::checkRcInner</Function><Type></Type><Name></Name><Label></Label><Catalog>BIPv600</Catalog><Severity>3</Severity><Number>2322</Number><Text>Child SQL exception</Text><Insert><Type>5</Type><Text>IM003</Text></Insert><Insert><Type>2</Type><Text>0</Text></Insert><Insert><Type>5</Type><Text>[DataDirect][ODBC lib] Specified driver could not be loaded</Text></Insert></DatabaseException></DatabaseException></RecoverableException></EXEPTLIST></ERROR>

The Broker is on AIX 5.3 and WMB is version 6.0.0.6

Thanks a lot for your Help
Ciao
Sabato