Websphere MQ Workflow 3.6.0.9 requires 32 and 64 bit Oracle 11.2 libraries

Technote (troubleshooting)


Problem(Abstract)

Oracle 11.2 Client installs only 32 bit or 64 bit but not both. Both libraries are required with Websphere MQ Workflow 3.6.0.9 and MQ Series V6 or higher.

Symptom

Oracle 11.2 Client will only install the 32 bit library or 64 bit but not both. If 32 bit is installed MQ Series will not function. If 64 bit is installed Websphere MQ Workflow will not function.


Cause

As of MQ Series V6 the corresponding database must be at 64 bit. Websphere MQ Workflow requires a 32 bit database connection. MQ Series is able to converse with the database in 64 bit and MQ Workflow in 32 bit through the qm.ini and oraswit files.

Resolving the problem

The example provided is for AIX. Please be aware that Solaris and HP-UX are similar, but some paths and filename extensions differ. See the reference section below.

1) Install 64 bit Oracle 11.2 Client into /opt/oracle/product/11.2.0
2) Create a new directory /opt/oracle/product/11.2.0/lib32

    Note: The previously installed 64 bit Client uses directory  /opt/oracle/product/11.2.0/lib
3) Temporarily install 32 bit Oracle 11.2 Client somewhere else and manually copy the 32 bit library  libclntsh.a from there into  /opt/oracle/product/11.2.0/lib32

Having configured the Workflow installation with the command " fmczinsx -o ora10" previously (as documented in the Installation Guide), now everything should be setup correctly.

Some details and explanation:
The directories  /opt/oracle/product/11.2.0/lib and  /opt/oracle/product/11.2.0/lib32 are the default search paths for WebSphere MQ Workflow. Libraries available there will be found automatically.

If for some reason these directories cannot be used on the machine where you setup the Workflow system, the following Workflow specific subdirectories can be used instead:
  /usr/lpp/fmc/lib/workflow (for 32 bit libraries)
  /usr/lpp/fmc/lib/workflow64 (for 64 bit libraries)

If you choose to use them, the directories must be created manually:
  mkdir /usr/lpp/fmc/lib/workflow
  mkdir /usr/lpp/fmc/lib/workflow64
  chmod 755 /usr/lpp/fmc/lib/workflow*
and then the Oracle  libclntsh.a libraries (both 32 and 64 bit) need to be copied or linked accordingly:
  cp -p /opt/oracle/product/11.2.0/lib32/libclntsh.a /usr/lpp/fmc/lib/workflow
  cp -p /opt/oracle/product/11.2.0/lib/libclntsh.a /usr/lpp/fmc/lib/workflow64
or
  ln -s /opt/oracle/product/11.2.0/lib32/libclntsh.a /usr/lpp/fmc/lib/workflow
  ln -s /opt/oracle/product/11.2.0/lib/libclntsh.a /usr/lpp/fmc/lib/workflow64


Reference:
Name of Oracle Client Share library, to be used by the *swit files:
  AIX:          libclntsh.a
  HP-UX ia64:   libclntsh.so.9.0
                libclntsh.so.10.1
  HP-UX parisc: libclntsh.sl.9.0
                libclntsh.sl.10.1
  Solaris:      libclntsh.so.9.0
                libclntsh.so.10.1

WMQWF for AIX installation directory: /usr/lpp/fmc
WMQWF for HP-UX and Solaris installation directory: /opt/fmc

- - -

Oracle 11.2.0 default installation path: /opt/oracle/product/11.2.0
Library path for 64 bit libraries: /opt/oracle/product/11.2.0/lib
Library path for 32 bit libraries: /opt/oracle/product/11.2.0/lib32

Library search path for Workflow binaries: "dump -H fmcemain"
[...]
/usr/lpp/fmc/lib/workflow:/usr/lib/threads:/usr/lpp/xlC/lib:/usr/lib:/lib:/usr/lpp/fmc/lib:/usr/mqm/lib:/usr/opt/db2_08_01/lib:/opt/IBM/db2/V9.1/lib32:/opt/IBM/db2/V9.5/lib32:/opt/IBM/db2/V9.7/lib32:/opt/oracle/product/9.2.0/lib32:/opt/oracle/product/10.1.0/lib32:/opt/oracle/product/10.2.0/lib32:/opt/oracle/product/11.1.0/lib32:/opt/oracle/product/11.2.0/lib32

Library search path for 32 bit XA Switch file: "dump -X any -H ora10swit-32"
[...]
/usr/lpp/fmc/lib/workflow:/usr/lib/threads:/usr/lib:/lib:/opt/oracle/product/10.1.0/lib32:/opt/oracle/product/10.2.0/lib32:/opt/oracle/product/11.1.0/lib32:/opt/oracle/product/11.2.0/lib32

Library search path for 64 bit XA Switch file: "dump -X any -H ora10swit-64"
[...]
/usr/lpp/fmc/lib/workflow64:/usr/lib/threads:/usr/lib:/lib:/opt/oracle/product/10.1.0/lib:/opt/oracle/product/10.2.0/lib:/opt/oracle/product/11.1.0/lib:/opt/oracle/product/11.2.0/lib

Product Alias/Synonym

fmc00wf fmc00dba fmc00ora

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere MQ Workflow
Database

Software version:

3.6

Operating system(s):

AIX, HP-UX, Solaris

Software edition:

All Editions

Reference #:

1638175

Modified date:

2013-05-23

Translate my page

Machine Translation

Content navigation