BI 4.0 Install on Suse Linux with Oracle

server administration XI Server Discussion
1

Hi
Having issues installing BI 4.0 SP4 on Suse Enterprise Linux v 11 SP2. Oracle version is 11.2
Receiving this error when attempting to setup the database

Any help on this one?

Thanks
Dennis

djkailin (BOB member since 2009-07-31)

2

Hi

My guess is that the shell (account) that BO is running under doesn’t have access to the Oracle libraries.

Edit the profile for that shell and specify,

# ORACLE Environment
export ORACLE_BASE=/u00/oracle
export ORACLE_HOME=/u00/oracle/product/ora11client
export PATH=$ORACLE_HOME/bin:$PATH

export LIBPATH=${ORACLE_HOME}/lib
export LD_LIBRARY_PATH=${ORACLE_HOME}/lib
  • update for whatever your Oracle home is.

Check that you can use sqlplus to connect to oracle from that shell.

I did have a weird issue on one server where these oracle environment variables weren’t being passed to the BusObj processes. To resolve this i had to add same entries as above in the BO environment setup script

AL

agulland :uk: (BOB member since 2004-03-17)

3

Hi
Yes the DB is accessible when using SQL Plus.
I tried the suggestions offered below, same error has occurred. Thanks for the idea.

Dennis

djkailin (BOB member since 2009-07-31)

4

How did you end up fixing this?

angelsd1 :us: (BOB member since 2005-10-21)

5

Hi
I worked with the server admin and found a bug with the script the user id runnning BI 4.1 uses.
It was not pointing at the /home/userid/.profile file, it was looking somewhere else so the id was not able to access the Oracle libraries. We had already added the Oracle parms to the setup.sh file, hence the post here.

After fixing the script, and adding the Oracle parms to the .profile everything was resolved.

Thanks
Dennmis

djkailin (BOB member since 2009-07-31)