Skip to Content
0
Former Member
Jun 24, 2013 at 10:47 AM

How to configure the Oracle Client 11gR2 32 and 64 bit for BO 4.0 on Linux Server

811 Views

Dear All,

I have installed a SAP BO BIP 4.0 SP6 on Linux (Red Hat 5.6 64bit), and now I am getting confuse on how to configure the Oracle Client 11gR2 32 and 64 bit on BO Server.

According to the BO installation guide:

9.1.15 Using 32-bit and 64-bit third-party libraries with BI 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 versus 64-bit) with Business Intelligence (BI) platform processes, you must set separate environment variables for each version on the computer hosting BI 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 BI platform, it will select the appropriate variable depending on whether the process is 32-bit or 64-bit.

• <FIRST_ENV_VAR> is the value to be used by 64-bit BI platform processes.

• <FIRST_ENV_VAR32> is the value to be used by 32-bit processes.

• <SECOND_ENV_VAR> is the value to be used by 64-bit processes.

• <SECOND_ENV_VAR32> is the value to be used by 32-bit processes.

• BOE_USE_32BIT_ENV_FOR=<FIRST_ENV_VAR>,<SECOND_ENV_VAR>

Q1) Should I configured as follow?

export ORACLE_HOME=/home/app/oracle/product/11.2.0/client_1

export ORACLE_HOME32=/home/app/oracle/product/11.2.0/client_2

export PATH=$PATH:$ORACLE_HOME/bin

export PATH32=$PATH:$ORACLE_HOME32/bin

BOE_USE_32BIT_ENV_FOR=ORACLE_HOME,PATH

Q2) The above environment variables should be exported to which Linux user?

- root?

- BO installation user?

- Oracle Client installation user?

Q3) Any configure for BO to select ORACLE_HOME/PATH or ORACLE_HOME32/PATH32? BO can automatic detect the variable BOE_USE_32BIT_ENV_FOR?

I have installed BO 4.0 with Oracle Client 32 + 64 bit below for few environment on Window before, but it is the first time to do that on Linux.

Thanks in advance.

Best Regards,

Billy