Sunday, June 17, 2012

sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

Issue:

$ sqlplus
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

when invoking sqlplus as non oracle user

Workaround:

chmod -R a+rX $ORACLE_HOME or chmod -R 755 $ORACLE_HOME

2 comments:

Gori Shanker Gupta said...

Solution is here :
vi ~/.bashrv
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

save and quit.

than relogin...problem will be solve.

Mohammed said...

Thanks Gori Shanker Gupta for sharing