I got this error while installing SAP BOBI 4.0 SP4 on SUN Solaris system, but this is applicable to all Linux / Unix systems installations with Oracle Database.
Scenario:-
1.You are trying to Install SAP BO 4.0 SP4 on Sun Solaris (SPARC) and using Oracle DB 10g/11g for CMS and Audit database.
2. Oracle client is installed, and TNSfile is updated, TNSPING command can ping the database, tried to use SQLPLUS and executed a SQL query, every thing is working fine.
3. But when you go through the “SAP BO 4.0″ installation, the installer can not verify the database credentials and giving the following message
“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: .
Cannot verify DB login information.
Would you like to correct them?”
Issue Reason :-
This can happen because of multiple reasons
1. Oracle client installed is 32 bit version.
2. Library path is not set or set to wrong location.
3. User do not have access permissions on Library locations.
Solution :-
1. Install 64 bit client , SAP BOBJ 4.0 is 64 bit application, it works only with 64 bit clients.
2. Some times variable “LD_LIBRARY_PATH” may not be set, or set to 32 bit library folder “lib32″, so change it to 64 bit library folder “lib”, using command
$ export LD_LIBRARY_PATH=<Oracle Client Lib folder path>
and save this to “.profile” file . the name of “.profile” file may be different in different operating systems.
Some flavors of Linux/Unix use “LIBPATH” instead of “LD_LIBRARY_PATH”
3. If the user can not access the Oracle client folder, give access to user for the library.
One of these 3 solutions should solve your problem.