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

3 comments:

  1. It's great that people are interested in this topic. escort-service-london.co.uk

    ReplyDelete
  2. Nice Content, good information shared..
    Inovies

    ReplyDelete
  3. Hey Oracle community, I've been following the insightful discussions on database access errors, and I wanted to share a tool that has proven handy for me. If you ever find yourself dealing with image-related tasks, check out this Background Remover tool at depositphotos.com. It's a quick and efficient solution to eliminate backgrounds hassle-free. In the spirit of knowledge sharing, I hope this resource proves beneficial for those managing graphical elements within databases. Feel free to share your experiences or other useful tools related to database management. Let's continue enriching our collective expertise!

    ReplyDelete