Archive for the ‘Linux’ category

Troubleshooting a BO Edge on Red Hat Linux Oracle driver Issue

August 29th, 2010
So BOE 3.1 SP2 Edge CMS would not start after a database driver upgrade to solve an LDAP imcompatibility on a Red hat installation
1) checked the tnsnames.ora
Status: OK
2) Checked my Connectivity through sqlplus
Status: OK
3) Checked the CMS Setup
[bobj@server bobje]$ ./cmsdbsetup.sh
err: ERROR Failed to get cluster name. (STU00165)
err: Error description: Database access error. Reason Loading shared object 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: wrong ELF class: ELFCLASS64].
4) Checked the LD_LIBRARY_PATH in the profile of the bobj account
drwxr-x— 58 oracle oinstall 4096 Aug 27 13:51 OraHome10gr2_32bit
$ cd
$ vi .bash_profile
Status: OK
export LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/lib:
5) Tried changing to 32 bit libary path
export LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/lib32:
Status: libclntsh.so file was not there
6) Reset the rights for Read and Execute
chmod -R 755 lib32
Status: OK
7) Checked the file that BOE is looking for and it shows as a 64 bit file
libclntsh.so.10.1: ELF 64-bit LSB shared object, AMD x86-64, version 1 (SYSV), not stripped
This should be showing as the following as BOE requires 32 bit database drivers
libclntsh.so: ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), not stripped
Status: Issue
8) The current issue prohibits the BusinessObjects system from running on the server. Database driver to be setup correctly

So BusinessObjects 3.1 SP2 Edge CMS would not start after an Oracle database driver upgrade to solve an LDAP imcompatibility on a Red hat installation

1) checked the tnsnames.ora

Status: OK

2) Checked my Connectivity through sqlplus

Status: OK

3) Checked the CMS Setup

[bobj@server bobje]$ ./cmsdbsetup.sh

err: ERROR Failed to get cluster name. (STU00165)

err: Error description: Database access error. Reason Loading shared object 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: wrong ELF class: ELFCLASS64].

4) Checked the LD_LIBRARY_PATH in the profile of the bobj account

drwxr-x— 58 oracle oinstall 4096 Aug 27 13:51 OraHome10gr2_32bit

$ cd

$ vi .bash_profile

Status: OK

export LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/lib:

5) Tried changing to 32 bit libary path

export LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/lib32:

Status: libclntsh.so file was not there

6) Reset the rights for Read and Execute

chmod -R 755 lib32

Status: OK

7) Checked the file that BOE is looking for and it shows as a 64 bit file

libclntsh.so.10.1: ELF 64-bit LSB shared object, AMD x86-64, version 1 (SYSV), not stripped

This should be showing as the following as BOE requires 32 bit database drivers

libclntsh.so: ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), not stripped

Status: Issue

8) The current issue prohibits the BusinessObjects system from running on the server. Database driver to be setup correctly