To configure 32-bit binaries to run on a 64-bit Windows machine:
Install Foundation Services and Essbase but do not run EPM System Configurator.
%EPM_ORACLE_HOME%/products/Essbase/EssbaseServer
To:
%EPM_ORACLE_HOME%/products/Essbase/EssbaseServer-64
%EPM_ORACLE_HOME%/products/Essbase/EssbaseServer-32
To:
%EPM_ORACLE_HOME%/products/Essbase/EssbaseServer
Run EPM System Configurator to configure Essbase but do not perform the Essbase cluster setup task or deploy Essbase in stand-alone mode.
Modify %EPM_ORACLE_INSTANCE%/EssbaseServer/essbaseserver1/bin/essbase.cfg to use a 32-bit JRE (in the JvmModuleLocation line). For example, set this parameter to:
d:/oracle/Middleware/EPMSystem11R1/common/JRE/Sun/1.6.0/bin/server/jvm.dll
Modify %EPM_ORACLE_INSTANCE%/EssbaseServer/essbaseserver1/bin/setEssbaseEnv.bat to use a 32-bit ODBC (in the ODBCINST= line). For example, set this parameter to:
d:/Oracle/Middleware/EPMSystem11R1/common/ODBC/Merant/6.0/odbcinst.ini
Modify the PATH environment variable so that it points to the 32-bit version:
%EPM_ORACLE_HOME%/common/ODBC/Merant/6.0/Drivers
Make a copy of %EPM_ORACLE_INSTANCE%/EssbaseServer/essbaseserver1/startEsscmd.bat to startEssbase.bat and edit the file to change the ESSCMD line to ESSBASE.
Start Essbase Server using startEssbase.bat in %EPM_ORACLE_INSTANCE%/EssbaseServer/essbaseserver1/bin.