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:
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google