BO XI 3.1 for Linux (on RHEL 5) with the CMS database as ORACLE

[Georgy]

Hi,

We are trying to install BO XI 3.1 for Linux (on RHEL 5) with the CMS database as ORACLE.

As prerequisites we did the following steps:

1) Created a CMS Database (biek) with UTF-8 character set.
2) Created a database user (cabi) and grant required permissions (grant dba, sysdba)
3) Created a linux user bobje to use with BO installation

During the installation, we chose to use an existing DBMS as CMS and selected oracle. We already have Oracle 10G installed here. When we go to the next step after giving the TNS service name and user id and password, we get the following error.

[color=#FD0D0D]"Failure to validate the database credential has a potential to crash the database at a later stage. Enter the correct information. (STU00104)"[color]


We could log into the biek DB using SQLPlus from the same machine. So this error screen is rather surprising.

Any thoughts on this error?

Waiting for your reply,
Georgy N Joseph

[System]

Hi All,

Any ideas here for Georgy?

Thanks!
Chris

[Georgy]

We resolved this issue by making the mode of installation to "System Level" from the default "User Level" option.

Thus we could continue the BO installation with Oracle as CMS database. :smile

[System]

Thanks for letting everyone know you were able to resolve Georgy!

Chris

[Anon Anon]

We have the same problem with a SUSE Esterprise Server Installation.

we have done the installation with "System level" but the problem is still there. What Oracle client are you using? 32 or 64 bits? we are using 64 bits and i think that could be the error.

Regards.

[Georgy]

Hi mgarciac_indra.es,

Yes, you are right! Infact we did the installation again today on another server and the system level install didn't solve the issue.

Did a lot of research and found the real culprit :)

Solution:

BO XI 3.1 needs 32bit libraries to connect to the CMS database.

One can use the 64bit Oracle client, but make sure the LD_LIBRARY_PATH or LIBPATH points to /lib32 directory, which should exist in Oracle Home client directory.

Example:
Put the following code in the .bash_profile of the linux user who does the BO install:-

export ORACLE_HOME=/opt/app/oracle/product/10.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32

:grin:

Thanks,
Georgy

[Nino Uziel]

Customer also has reported that he had to link the libclntsh.so:

ln -s libclntsh.so.11.1 libclntsh.so

Without this addition the installation did not continue.