Oracle 11.2 Client installs only 32 bit or 64 bit but not both. Both libraries are required with Websphere MQ Workflow 18.104.22.168 and WebSphere MQ V6 or higher.
Oracle 11.2 Client will only install the 32 bit library or 64 bit but not both. If 32 bit is installed WebSphere MQ will not function. If 64 bit is installed Websphere MQ Workflow will not function.
As of WebSphere MQ V6 the corresponding database must be at 64 bit. Websphere MQ Workflow requires a 32 bit database connection. Websphere MQ 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
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:
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
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
Name of Oracle Client Share library, to be used by the *swit files:
HP-UX ia64: libclntsh.so.9.0
HP-UX parisc: libclntsh.sl.9.0
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"
Library search path for 32 bit XA Switch file: "dump -X any -H ora10swit-32"
Library search path for 64 bit XA Switch file: "dump -X any -H ora10swit-64"
fmc00wf fmc00dba fmc00ora