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

advertisements

_____________________________________________________________________________________________________________________

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:

_____________________________________________________________________________________________________________________

Live Traffic Feed

A visitor from Nevada viewed 'Steps to Enable fast_start failover (automatic) in' 1 hr 11 mins ago

A visitor from Boston viewed 'Fix ORA-01927: cannot REVOKE privileges you did no' 1 hr 56 mins ago

A visitor from Ohio viewed 'How to Enable or Disable the Supplemental Logging ' 2 hrs 12 mins ago

A visitor from The bronx viewed 'Fix RMAN-08138: WARNING: archived log not deleted ' 2 hrs 24 mins ago

A visitor from Tappahannock viewed 'How to Find out / Check SGA and PGA size of Oracle' 4 hrs 12 mins ago

Real-time | Get Script | More Info