Wednesday 29 October 2014

ld.so.1: sqlplus: fatal: libsqlplus.so: open failed: No such file or directory

Issue :--

oracle@test$sqlplus
ld.so.1: sqlplus: fatal: libsqlplus.so: open failed: No such file or directory
Killed

oracle@test$



solution :--

We could see from above result that some shared library dependencies for sqlplus is not found.
Following settings are applicable for Solaris.

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/dt/lib:/usr/openwin/lib:/lib:/usr/lib:/usr/lib/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:
export LD_LIBRARY_PATH

 

After setting correct value for LD_LIBRARY_PATH, issue got resolved and not getting any error.


oracle@test$sqlplus

SQL*Plus: Release 10.2.0.5.0 - Production on Wed Oct 29 13:52:25 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Enter user-name: / as sysdba

No comments:

Post a Comment