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

[Former Member]

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

[Former Member · Accepted solution]

Hi Billy,

The variables you have listed are correct and should be
added to the bash_profile of the user who installed BO ( no need to add it to
root and oracle user). No other configuration is required since BO will look
for these variables by its own when needed.

You might also require these additional variables too:
TNS_ADMIN,TNS_ADMIN32,LD_LIBRARY_PATH32,LD_LIBRARY_PATH

Their values should be:

TNS_ADMIN=$ORACLE_HOME/network/admin

TNS_ADMIN32=$ORACLE_HOME32/network/admin

LD_LIBRARY_PATH=$ORACLE_HOME/lib

LD_LIBRARY_PATH32=$ORACLE_HOME32/lib

Don’t forget to add them to the BOE_USE_32BIT_ENV_FOR variable.
e.g.: BOE_USE_32BIT_ENV_FOR=ORACLE_HOME,TNS_ADMIN,LD_LIBRARY_PATH,PATH

I think that these additional 32 bit variables are only
required if you want 32-bit connectivity for Crystal Reports. No need to add
them if you don’t use CR or don’t need CR 32-bit connectivity.

-Nikhil Nair

[Former Member · Accepted solution]

Dear Nikhil Nair,

Thanks for your prompt reply.

I have updated the bash_profile with above setting

FYI:

/home/app/oracle/product/11.2.0/client_1 for 64bit

/home/app/oracle/product/11.2.0/client_2 for 32bit

However I got the following error when refreshing a sample Webi on BI Launch Pad

Checked the file mentioned in error message is listed in the directory.

Anyone can give me some guidance?

The Target DB is Oracle 11g 64bit which I can successfully login by sqlplus