Fix Oracle 11g Client sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

_____________________________________________________________________________________________________________________

Error Description:

Oracle 11g Client SQL* PLUS is failing with following error.

$ORACLE_HOME/bin/sqlplus
/opt/oracle/client_11_2/bin/sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

Solution Description:

The error is because with the wrong environment variable LD_LIBRARY_PATH or the variable LD_LIBRARY_PATH is not set.

Make sure the ORACLE_HOME environment variable is set already

env|grep ORA
ORACLE_HOME=/opt/oracle/client_11_2

Set LD_LIBRARY_PATH variable as below.

export LD_LIBRARY_PATH=$ORACLE_HOME/lib32

Now initiate the sqlplus

:>$ORACLE_HOME/bin/sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Fri Oct 5 21:07:46 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name:

_____________________________________________________________________________________________________________________