err: ERROR Failed to get cluster name. (STU00165) err: Error description: Database access error. Reason Loading shared objects failed. First tried to load library clntsh and failed because of error: [clntsh: cannot open shared object file: No such file or directory]. Second tried to load library libclntsh.so and failed because of error: [libclntsh.so: cannot open shared object file: No such file or directory].

I was using Business Objects XI 3.1 on Red Hat Enterprise Linux 5 and when run cmsdbsetup.sh to check the CMS repository I faced the following error:

err: ERROR Failed to get cluster name. (STU00165)
err: Error description: Database access error. Reason Loading shared objects failed. First tried to load library clntsh and failed because of error: [clntsh: cannot open shared object file: No such file or directory]. Second tried to load library libclntsh.so and failed because of error: [libclntsh.so: cannot open shared object file: No such file or directory].

After some search I find this solution:
Find libclntsh.so in your system by running the following command
 find / -name libclntsh.*
 gives the result: /libclntsh.so
then add the path of libclntsh.so into the LD_LIBRARY_PATH system variable by executing
 export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/libclntsh.so

Also make sure that the Oracle client is running and try to tnsping the repository database