[BI 4.x] Correct ORACLE client for SIA / CMS config on Win2008(64bit)

[SAPMM]

Hi all,

Trying a "Sandbox" install of SAP-BO BI-4.x on Windows Server 2008 (64-Bit).

Intend to use ORACLE for our CMS / AUDIT databases - and most of the "client" databases that provide data to our Crystal Reports.

Can anyone confirm if you are installing the 32-BIT or the 64-BIT versions of the ORACLE client on your Windows Server 2008 (64-Bit) boxes..?

As much version detail as possible would be great - as there are a number of different people involved on our end...IT Operations, IT Security, Oracle DBAs, BOBJ Admins, etc...

Thanks in advance,
SAPMM

[Rima]

Hi SAPMM,

Since BI 4.x, all componenets installed are 64 bit, hence you need to install a 64 bit oracle client.

Regards,
Rima

[SAPMM]

Hi Rima,

Turns-out that you need to install BOTH the 32-bit and 64-bit clients...

Further to your COMMENT - I did find this on Page 398 of the ADMIN GUIDE for 4.x...
8.1.15 Using 32-bit and 64-bit third-party libraries with SAP BusinessObjects Business Intelligence platform

SAP BusinessObjects Business Intelligence platform servers are a combination of 32-bit and 64-bit processes. Some servers additionally launch 32-bit and 64-bit child processes. To use the correct version of third-party libraries (32-bit vs 64-bit) with SAP BusinessObjects Business Intelligence platform processes, you must set separate environment variables for each version on the machine hosting SAP BusinessObjects Business Intelligence platform.
You must then set an additional environment variable that contains a comma-separated list of those environment variables that have 32-bit and 64-bit versions.

When a process is launched by SAP BusinessObjects Business Intelligence platform, it will select the appropriate variable depending on whether the process is 32-bit or 64-bit.

. <FIRST_ENV_VAR>=The value to be used by 64-bit SAP BusinessObjects Business Intelligence
platform processes.
. <FIRST_ENV_VAR32>=The value to be used by 32-bit processes.
. <SECOND_ENV_VAR>=The value to be used by 64-bit processes.
. <SECOND_ENV_VAR32>=The value to be used by 32-bit processes.
. BOE_USE_32BIT_ENV_FOR=<FIRST_ENV_VAR>,<SECOND_ENV_ VAR>

For example, if you've installed SAP BusinessObjects Business Intelligence platform on an AIX machine, as well as 32-bit and 64-bit Oracle clients, and need to set the LIBPATH variable, set the following variables:

. ORACLE_HOME=<64-bit version of the Oracle client>
. ORACLE_HOME32=<32-bit version>
. LIBPATH=<64-bit version>
. LIBPATH32=<32-bit version>
. BOE_USE_32BIT_ENV_FOR=ORACLE_HOME,LIBPATH

Regards,
SAPMM