| Author |
Message
|
| Gralgrathor |
 Posted: Wed Mar 24, 2010 11:29 am Post subject: Wmb6.1-32b/Oracle n00b request [solved] |
 |
|
Master
Joined: 23 Jul 2009
Posts: 297
|
Hi.
Does anyone have a comprehensive howto for installing a 6.1 32bit broker using an Oracle 10g xe database on a remote host (meaning there's *no* ORACLE_HOME to point to)?
The howto's I've had sofar keep resulting in messages like
| Code: |
| BIP2322E: Database error: SQL State ''IM003''; Native Error Code '0'; Error Text ''[DataDirect][ODBC lib] Specified driver could not be loaded''. |
or
| Code: |
| BIP2322E: Database error: SQL State ''82''; Native Error Code '0'; Error Text ''523 80''. |
depending on how I formulate the oracle db stanza in my odbc32.ini...
Thanks in advance.
Gr
EDIT
Some additional info:
I was trying to set up a rig consisting of three images, all Debian 32 bits machines. One image should contain the Oracle XE broker config database, another the broker itself, and the third the toolkit. The broker should access its database through ODBC.
Last edited by Gralgrathor on Fri Mar 26, 2010 1:51 am; edited 2 times in total |
|
| Back to top |
|
 |
| Vitor |
| Posted: Wed Mar 24, 2010 12:04 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Have you installed the Oracle drivers that come with WMB locally?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Mar 24, 2010 12:29 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| You have to install the Oracle client in order to use the 32bit ODBC drivers. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Mar 24, 2010 12:53 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqjeff wrote: |
| You have to install the Oracle client in order to use the 32bit ODBC drivers. |
Now that's something I didn't know! 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| Gralgrathor |
| Posted: Wed Mar 24, 2010 1:18 pm Post subject: |
|
|
Master
Joined: 23 Jul 2009
Posts: 297
|
| mqjeff wrote: |
| You have to install the Oracle client in order to use the 32bit ODBC drivers. |
Blast. How embarrassingly elementary. The first howto I read mentioned I would have no need of local installs when using odbc and the drivers that were provided. Ah, well... On with it. Thanks!
Gr |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Wed Mar 24, 2010 2:26 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
if you have the DB installed locally then you should have all the connectivity bits you need if the DBA/SysAdmin has done a 'normal' install. This is true AFAIK for DB2, SQL Server & Oracle on Windoze, Linux & Solaris platformas at least.
Never had the need to use the other supported DB's.
(Yeah, that is a big IF. How many DBA's/Sysadmins are 'normal' people)... 
The explicit DB Client software is needed when you are talking to a remote instance of the DB. This bit is what catches out a lot of people. Then they make the mistake of using the DB supplied ODBC drivers rather than the WBI supplied ones.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| Gralgrathor |
| Posted: Wed Mar 24, 2010 11:40 pm Post subject: |
|
|
Master
Joined: 23 Jul 2009
Posts: 297
|
| smdavies99 wrote: |
| The explicit DB Client software is needed when you are talking to a remote instance of the DB. This bit is what catches out a lot of people. Then they make the mistake of using the DB supplied ODBC drivers rather than the WBI supplied ones. |
I'm sensing the lesson to be learned here is: don't trust the instruction manual? I am using the WS supplied ODBC drivers, btw. But perhaps I should not.
I was hoping to configure my x86 setup in a way similar to the situation described in http://www.ibm.com/developerworks/websphere/library/techarticles/0804_squibb/0804_squibb.html , under "Configuring Message Broker V6.1 for use with Oracle". I had hoped there would be a similar howto somewhere applicable to my setup with 32bit debian machines. So far, no luck.
Gr |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Thu Mar 25, 2010 12:12 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Debian is AFAIK, not a supported runtime. It may work BUT all the docs are targetted towards distros like RHEL & SLES which follow the Linux Standard Base standard. Deviant, AFAIK, does not do this.
That said,
there are many posts here about configuring ODBC on Unix. There is nowt different for the Linux config as far as the .odbc.ini goes.
Good Luck.
I'm sure it would be appreciated if any 'gotchas' you faces when getting it running on Debian or even Ubuntu(shock horror) were made available for others.
I run Broker on Fedora Systems (currently F12) all the time for Dev purposes. All testing is however done on CentOS or RHEL. In the past, just getting the installer to run in the right JVM was a real nightmare. Now it seems to be much more stable.
I'd much prefer to setup a Broker runtime on Linux than on Windows Server 2008 whick IMHO, is a big step backwards from 2003. Who wants to run UAC OOTB on a Server? etc etc etc. But that is a topic for another post...
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| MrSmith |
| Posted: Thu Mar 25, 2010 1:16 am Post subject: |
|
|
Master
Joined: 20 Mar 2008
Posts: 215
|
| Further to smdavies - debian as he says is not supported but i have a version of 6.1 broker running on Ubuntu Karmic Koala working most satisfactorily (hoping this has now not jinxed it) toolkit and all and with very little tweaking to get it to work, some things to bear in mind on things like ubuntu tho is the version of the JDK that is used - uninstall the openjdk and use the "proper" Sun version - the openjdk is not complete AFAIK. |
|
| Back to top |
|
|
| Gralgrathor |
| Posted: Thu Mar 25, 2010 1:56 am Post subject: |
|
|
Master
Joined: 23 Jul 2009
Posts: 297
|
| smdavies99 wrote: |
| I'm sure it would be appreciated if any 'gotchas' you faces when getting it running on Debian or even Ubuntu(shock horror) were made available for others. |
If and when I find out how to get the ODBC setup rolling I will write a little howto explaining how I managed. Really, the ODBC connectivity is the only part of the setup that doesn't work; the same setup works perfectly if I use a local DB2 database as broker config db, instead of a remote oracle db. But of course the intention is to find out how I can use a remote oracle db for this.
Gr |
|
| Back to top |
|
|
| Gralgrathor |
| Posted: Thu Mar 25, 2010 5:46 am Post subject: |
|
|
Master
Joined: 23 Jul 2009
Posts: 297
|
| MrSmith wrote: |
| i have a version of 6.1 broker running on Ubuntu Karmic Koala working most satisfactorily |
No problems there. I can get the whole config to work on Debian or Ubuntu, no problem: IF I don't use an odbc connection to a remote Oracle database, but a local DB2 instance in stead.
But unfortunately, the whole idea of my little experiment is to get this thing to work on two Debian 32bit VM's, one running the broker, the other running an Oracle config database. I'm crazy like that, but there you go.
Gr |
|
| Back to top |
|
|
| Gralgrathor |
| Posted: Thu Mar 25, 2010 12:03 pm Post subject: |
|
|
Master
Joined: 23 Jul 2009
Posts: 297
|
Okay, finally got it to work.
I installed
- oracle-xe-client
- WMQ 7.0.1 + FP1
- WMB 6.1.0 + FP5
Added to my profile:
| Code: |
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client
export ORACLE_SID=xe
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/client
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin
# bugfix for oracle version problems leading to segfault in broker
export LD_PRELOAD=/opt/ibm/mqsi/6.1/jre15/bin/libjava.so
|
And used this as my /var/mqsi/odbc/.odbc.ini:
| Code: |
;#######################################
;##### List of data sources stanza #####
;#######################################
[ODBC Data Sources]
BRKCFGDB=DataDirect 5.3 Oracle Driver
;###########################################
;###### Individual data source stanzas #####
;###########################################
;# Oracle stanza
[BRKCFGDB]
Driver=/opt/ibm/mqsi/6.1/ODBC32/V5.3/lib/UKor823.so
Description=DataDirect 5.3 Oracle Driver
EnableDescribeParam=1
OptimizePrepare=1
ServerName=oracle0vm
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
;##########################################
;###### Mandatory information stanza ######
;##########################################
[ODBC]
Trace=1
TraceFile=/var/log/odbctrace32.out
TraceDll=/opt/ibm/mqsi/6.1/ODBC32/V5.3/lib/odbctrac.so
InstallDir=/opt/ibm/mqsi/6.1/ODBC32/V5.3
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8 |
Then I let her rip:
| Code: |
mqsicreateconfigmgr CONFIGMGR -i user -a password -q QUEUEMGR
mqsicreatebroker BROKER -i user -a password -q QUEUEMGR -n BRKCFGDB -u dbuser -p dbpasswd |
And that seemed to do the trick. I'll update this as soon as I have confirmation that I can do stuff to this broker with the toolkit.
Gr
UPDATE
Had to add one more line to the profile because the broker kept crashing due to a problem with the oracle drivers. I found the solution at http://www-01.ibm.com/support/docview.wss?uid=swg21295770
After that, no more problems deploying and running flows.[/url][/b]
Last edited by Gralgrathor on Thu Mar 25, 2010 3:54 pm; edited 3 times in total |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Mar 25, 2010 12:15 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Gralgrathor wrote: |
| mqjeff wrote: |
| You have to install the Oracle client in order to use the 32bit ODBC drivers. |
Blast. How embarrassingly elementary. The first howto I read mentioned I would have no need of local installs when using odbc and the drivers that were provided. Ah, well... On with it. Thanks!
Gr |
The *64-bit* ODBC drivers are wire-format drivers that do not need an Oracle client install.
The 32-bit drivers are not. |
|
| Back to top |
|
|
|
|
