ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Message Broker 6.1 compatibility on AIX with Oracle 10.2.0.3

Post new topic  Reply to topic
 Message Broker 6.1 compatibility on AIX with Oracle 10.2.0.3 « View previous topic :: View next topic » 
Author Message
rajn27
PostPosted: Tue Oct 28, 2008 1:57 pm    Post subject: Message Broker 6.1 compatibility on AIX with Oracle 10.2.0.3 Reply with quote

Newbie

Joined: 28 Oct 2008
Posts: 7
Is Message Broker 6.1 compatibility on AIX with Oracle 10.2.0.3

here is the abend i get after broker tries to process a message

abend record for pid 1781916 tid 6940 time in seconds since 01/01/1970: 1225228457
File: /build/S610_P/src/CommonServices/Unix/ImbAbend.cpp
Line: 921
Function: signal received
---- Inserts ----
11
@(#) 1.33.1.52 CommonServices/Unix/ImbAbend.cpp, CommonServices, S610, S610-CLONE 07/11/16 21:34:58 [11/29/07 15:08:26]
340406320
-----------------
----------------------------- Stack dump for current thread ( 6940)
(0x00000000) <invalid code address>
(0x0480db3c+0x00000000) <no name available> [/usr/opt/mqsi/ODBC64/V5.2/lib/libodbc.a(odbc.so)]
(0x0480d350+0x00000000) <no name available> [/usr/opt/mqsi/ODBC64/V5.2/lib/libodbc.a(odbc.so)]
(0x0480d478+0x00000000) <no name available> [/usr/opt/mqsi/ODBC64/V5.2/lib/libodbc.a(odbc.so)]
(0x0480cd00+0x00000000) <no name available> [/usr/opt/mqsi/ODBC64/V5.2/lib/libodbc.a(odbc.so)]
(0x047842c4+0x00000000) <no name available> [/usr/opt/mqsi/ODBC64/V5.2/lib/libodbc.a(odbc.so)]
(0x04783c88+0x00000000) <no name available> [/usr/opt/mqsi/ODBC64/V5.2/lib/libodbc.a(odbc.so)]
(0x04784c4c+0x00000000) <no name available> [/usr/opt/mqsi/ODBC64/V5.2/lib/libodbc.a(odbc.so)]
(0x04790424+0x00000000) <no name available> [/usr/opt/mqsi/ODBC64/V5.2/lib/libodbc.a(odbc.so)]
(0x0378fe38+0x00000124) connectNonCoordinated__17ImbOdbcConnectionFRC13ImbStringBaseXTcTQ2_3std11char_traitsXTc_TUcSP37_N21 [/csapps
/websphere/wmb61/lib/libMessageServices64.a(libMessageServices64.a.so)]
(0x0378d2f8+0x000003dc) connect__17ImbOdbcConnectionFRC10ImbWstringT1bP18ImbOdbcParticipantP29ImbDatabaseTransactionContext [/csapps
/websphere/wmb61/lib/libMessageServices64.a(libMessageServices64.a.so)]
(0x035a6948+0x000004cc) getConnection__18ImbDatabaseManagerFP16ImbThreadContextRC10ImbWstringN22bP18ImbOdbcParticipanti [/csapps/web
sphere/wmb61/lib/libMessageServices64.a(libMessageServices64.a.so)]
(0x0359aba8+0x00000634) getConnection__18ImbDatabaseManagerFP16ImbThreadContextRC10ImbWstringbP18ImbOdbcParticipanti [/csapps/websph
ere/wmb61/lib/libMessageServices64.a(libMessageServices64.a.so)]
(0x0623bb30+0x00000178) generateRuntimeObjects__19SqlComputeInterfaceFv [/usr/opt/mqsi/lib/libImbRdl64.a(libImbRdl64.a.so)
]
(0x06241310+0x00000408) evaluate__19SqlComputeInterfaceFRC18ImbMessageAssemblyR18ImbMessageAssembly [/usr/opt/mqsi/lib/lib
ImbRdl64.a(libImbRdl64.a.so)]
(0x07bfb6c0+0x00000280) evaluate__14ImbComputeNodeFRC18ImbMessageAssemblyPC19ImbDataFlowTerminal [/usr/opt/mqsi/lil/imbdfs
ql64.lil]
(0x036fc680+0x00000148) evaluate__19ImbDataFlowTerminalFRC18ImbMessageAssembly [/usr/opt/mqsi/lib/libMessageServices64.a(l
ibMessageServices64.a.so)]
(0x036fbf90+0x000000fc) propagateInner__19ImbDataFlowTerminalFRC18ImbMessageAssemblyP19ImbDataFlowTerminal [/usr/opt/mqsi/
lib/libMessageServices64.a(libMessageServices64.a.so)]
(0x03958d28+0x000000f0) propagate__19ImbDataFlowTerminalFRC18ImbMessageAssembly [/usr/opt/mqsi/lib/libMessageServices64.a(
libMessageServices64.a.so)]
(0x07c29ee0+0x00000590) evaluate__13ImbFilterNodeFRC18ImbMessageAssemblyPC19ImbDataFlowTerminal [/usr/opt/mqsi/lil/imbdfsq
l64.lil]
(0x036fc680+0x00000148) evaluate__19ImbDataFlowTerminalFRC18ImbMessageAssembly [/usr/opt/mqsi/lib/libMessageServices64.a(l
ibMessageServices64.a.so)]
(0x036fbf90+0x000000fc) propagateInner__19ImbDataFlowTerminalFRC18ImbMessageAssemblyP19ImbDataFlowTerminal [/usr/opt/mqsi/
lib/libMessageServices64.a(libMessageServices64.a.so)]
(0x03958d28+0x000000f0) propagate__19ImbDataFlowTerminalFRC18ImbMessageAssembly [/usr/opt/mqsi/lib/libMessageServices64.a(
libMessageServices64.a.so)]
(0x07bfb6c0+0x00000858) evaluate__14ImbComputeNodeFRC18ImbMessageAssemblyPC19ImbDataFlowTerminal [/usr/opt/mqsi/lil/imbdfs
ql64.lil]
(0x036fc680+0x00000148) evaluate__19ImbDataFlowTerminalFRC18ImbMessageAssembly [/usr/opt/mqsi/lib/libMessageServices64.a(l
ibMessageServices64.a.so)]
(0x036fbf90+0x000000fc) propagateInner__19ImbDataFlowTerminalFRC18ImbMessageAssemblyP19ImbDataFlowTerminal [/usr/opt/mqsi/
lib/libMessageServices64.a(libMessageServices64.a.so)]
(0x03958d28+0x000000f0) propagate__19ImbDataFlowTerminalFRC18ImbMessageAssembly [/usr/opt/mqsi/lib/libMessageServices64.a(
libMessageServices64.a.so)]
(0x07c29ee0+0x00000680) evaluate__13ImbFilterNodeFRC18ImbMessageAssemblyPC19ImbDataFlowTerminal [/usr/opt/mqsi/lil/imbdfsq
l64.lil]
(0x036fc680+0x00000148) evaluate__19ImbDataFlowTerminalFRC18ImbMessageAssembly [/usr/opt/mqsi/lib/libMessageServices64.a(l
ibMessageServices64.a.so)]
(0x036fbf90+0x000000fc) propagateInner__19ImbDataFlowTerminalFRC18ImbMessageAssemblyP19ImbDataFlowTerminal [/usr/opt/mqsi/
lib/libMessageServices64.a(libMessageServices64.a.so)]
(0x03958d28+0x000000f0) propagate__19ImbDataFlowTerminalFRC18ImbMessageAssembly [/usr/opt/mqsi/lib/libMessageServices64.a(
libMessageServices64.a.so)]
(0x07c29ee0+0x00000590) evaluate__13ImbFilterNodeFRC18ImbMessageAssemblyPC19ImbDataFlowTerminal [/usr/opt/mqsi/lil/imbdfsq
l64.lil]
(0x036fc680+0x00000148) evaluate__19ImbDataFlowTerminalFRC18ImbMessageAssembly [/usr/opt/mqsi/lib/libMessageServices64.a(l
ibMessageServices64.a.so)]
(0x036fbf90+0x000000fc) propagateInner__19ImbDataFlowTerminalFRC18ImbMessageAssemblyP19ImbDataFlowTerminal [/usr/opt/mqsi/
lib/libMessageServices64.a(libMessageServices64.a.so)]
(0x03958d28+0x000000f0) propagate__19ImbDataFlowTerminalFRC18ImbMessageAssembly [/usr/opt/mqsi/lib/libMessageServices64.a(
libMessageServices64.a.so)]
(0x07c29ee0+0x00000680) evaluate__13ImbFilterNodeFRC18ImbMessageAssemblyPC19ImbDataFlowTerminal [/usr/opt/mqsi/lil/imbdfsq
l64.lil]
(0x036fc680+0x00000148) evaluate__19ImbDataFlowTerminalFRC18ImbMessageAssembly [/usr/opt/mqsi/lib/libMessageServices64.a(l
ibMessageServices64.a.so)]
(0x036fbf90+0x000000fc) propagateInner__19ImbDataFlowTerminalFRC18ImbMessageAssemblyP19ImbDataFlowTerminal [/usr/opt/mqsi/
lib/libMessageServices64.a(libMessageServices64.a.so)]
(0x03958d28+0x000000f0) propagate__19ImbDataFlowTerminalFRC18ImbMessageAssembly [/usr/opt/mqsi/lib/libMessageServices64.a(
libMessageServices64.a.so)]
(0x027e0138+0x000000dc) evaluate__15ImbTryCatchNodeFRC18ImbMessageAssemblyPC19ImbDataFlowTerminal [/usr/opt/mqsi/lil/imbdf
bas64.lil]
(0x036fc680+0x00000148) evaluate__19ImbDataFlowTerminalFRC18ImbMessageAssembly [/usr/opt/mqsi/lib/libMessageServices64.a(l
ibMessageServices64.a.so)]
(0x036fbf90+0x000000fc) propagateInner__19ImbDataFlowTerminalFRC18ImbMessageAssemblyP19ImbDataFlowTerminal [/usr/opt/mqsi/
lib/libMessageServices64.a(libMessageServices64.a.so)]
(0x03958d28+0x000000f0) propagate__19ImbDataFlowTerminalFRC18ImbMessageAssembly [/usr/opt/mqsi/lib/libMessageServices64.a(
libMessageServices64.a.so)]
(0x07bfb6c0+0x00000858) evaluate__14ImbComputeNodeFRC18ImbMessageAssemblyPC19ImbDataFlowTerminal [/usr/opt/mqsi/lil/imbdfs
ql64.lil]
(0x036fc680+0x00000148) evaluate__19ImbDataFlowTerminalFRC18ImbMessageAssembly [/usr/opt/mqsi/lib/libMessageServices64.a(l
ibMessageServices64.a.so)]
(0x036fbf90+0x000000fc) propagateInner__19ImbDataFlowTerminalFRC18ImbMessageAssemblyP19ImbDataFlowTerminal [/usr/opt/mqsi/
lib/libMessageServices64.a(libMessageServices64.a.so)]
(0x03958d28+0x000000f0) propagate__19ImbDataFlowTerminalFRC18ImbMessageAssembly [/usr/opt/mqsi/lib/libMessageServices64.a(
libMessageServices64.a.so)]
(0x07bfb6c0+0x00000858) evaluate__14ImbComputeNodeFRC18ImbMessageAssemblyPC19ImbDataFlowTerminal [/usr/opt/mqsi/lil/imbdfs
ql64.lil]
(0x036fc680+0x00000148) evaluate__19ImbDataFlowTerminalFRC18ImbMessageAssembly [/usr/opt/mqsi/lib/libMessageServices64.a(l
ibMessageServices64.a.so)]
(0x036fbf90+0x000000fc) propagateInner__19ImbDataFlowTerminalFRC18ImbMessageAssemblyP19ImbDataFlowTerminal [/usr/opt/mqsi/
lib/libMessageServices64.a(libMessageServices64.a.so)]
(0x03958d28+0x000000f0) propagate__19ImbDataFlowTerminalFRC18ImbMessageAssembly [/usr/opt/mqsi/lib/libMessageServices64.a(
libMessageServices64.a.so)]
(0x0769f8e8+0x0000374c) readQueue__14ImbWSInputNodeFP11ImbOsThread [/usr/opt/mqsi/lib/libWSLibrary64.a(libWSLibrary64.a.so
)]
(0x076cadb0+0x00000040) run__Q2_14ImbWSInputNode10ParametersFP11ImbOsThread [/usr/opt/mqsi/lib/libWSLibrary64.a(libWSLibra
ry64.a.so)]
(0x02b94170+0x00000078) run__27ImbThreadPoolThreadFunctionFP11ImbOsThread [/usr/opt/mqsi/lib/libCommonServices64.a(libComm
onServices64.a.so)]
(0x02b8c0d0+0x00000080) threadRun__11ImbOsThreadFv [/usr/opt/mqsi/lib/libCommonServices64.a(libCommonServices64.a.so)]
(0x02b44ce8+0x000000ec) threadBootStrap__11ImbOsThreadFPv [/usr/opt/mqsi/lib/libCommonServices64.a(libCommonServices64.a.s
o)]
(0x007d4368+0x000000e0) _pthread_body [/usr/lib/libpthreads.a(shr_xpg5_64.o)]
(0x00000000) <invalid code address>
Back to top
View user's profile Send private message
Gaya3
PostPosted: Tue Oct 28, 2008 9:16 pm    Post subject: Reply with quote

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
Request you to have a look of this (system Requirements)

http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27010512

>Oracle 10g Release 2 (only that version) requires the fix for AIX APAR IY89080.

and tag this to your most favorite list
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die
Back to top
View user's profile Send private message
rajn27
PostPosted: Wed Oct 29, 2008 6:35 am    Post subject: Reply with quote

Newbie

Joined: 28 Oct 2008
Posts: 7
Thanks for the reply

I have Broker 6.1 version working with Oracle 10.2.0.2 without using the fix.

Is the APAR for aix only required for 10.2.0.3 and higher ?
Back to top
View user's profile Send private message
rajn27
PostPosted: Wed Oct 29, 2008 7:17 am    Post subject: Reply with quote

Newbie

Joined: 28 Oct 2008
Posts: 7
The above APAR is installed
Back to top
View user's profile Send private message
rajn27
PostPosted: Wed Oct 29, 2008 11:11 am    Post subject: Reply with quote

Newbie

Joined: 28 Oct 2008
Posts: 7
The issue was there were "#" in odbc.ini file. After you remove those hashes it works perfectly fine
Back to top
View user's profile Send private message
Gemz
PostPosted: Wed Nov 26, 2008 11:05 am    Post subject: Reply with quote

Centurion

Joined: 14 Jan 2008
Posts: 124
Hi,

I am using MB V 6.1 in AIX with DB2 database for broker components.

I am trying to access Oracle database (10G Release 2) and I am not able to access the oracles database.

I have done the required changes in odbc64.ini file.

odbc64.ini file

[DSNName]
Driver=/opt/IBM/mqsi/6.1/ODBC64/V5.2/lib/UKora22.so
Description=DataDirect 5.2 64bit Oracle Wire Protocol
HostName=[IPAddress]
PortNumber=1521
SID=dev
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Message Broker 6.1 compatibility on AIX with Oracle 10.2.0.3
Jump to:  



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
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.