Friday, December 23, 2016

Database access error. Reason Loading shared object failed

User might receive below error during Business Objects(Boxi ) or Data services installation when using Oracle as database.

Error
An error has occurred.

Database access error. Reason Loading shared object failed. First tried to load library clntsh and failed because of error: . Second tried to load library libclntsh.so and failed because of error: .
(FWB 00090)

The system cannot verify the database logon information. That means the path might not be correct.

User will receive this error when below environment variables are not set properly.

1. The environment variable "LD_LIBRARY_PATH" is not set.
2. environment variable for ORACLE client is not setup properly
3. the user where you are running the BOXI install not able to tnsping to the listener service

Resolution

Make sure you set the below library paths in .profile of the user by which Business objects is installed

• ORACLE_HOME=<Oracle client home path>
• LD_LIBRARY_PATH=<$ORACLE_HOME/lib>

Note : ORACLE_HOME may be set also in the bash_profile. After setting variables, tomcat should be restarted.

Regards,
Satishbabu Gunukula, Oracle ACE

License key not valid INS00140 in Unix

You might encounter below error during the installation of Business Objects (BODS/BOBJ), Data Services  install will stop

License key not valid INS00140 in Unix

Cause
A library is missing

Resolution
Use strace or ldd to find what library is missing.

strace -ff -v isKeycodeValid
Note: Using strace, you can watch something similar like this: 10isKeycodeValid: error while loading shared libraries: libstdc++.so.6: cannot open shared object file: No such file or directory.

If using ldd
Run ldd on /usr/dlc/odbc/lib/pgoe1023.so to ensure all dependencies are found.

Find out which library is missing , in my case  libstdc++.so.6 would be the library that is missing.

Installed the library using below command
sudo yum install libstdc++.so.6

Rerun the install and install working fine.

Regards
Satishbabu Gunukula, Oracle ACE