./sqlplus: error while loading shared libraries: libsqlplus.so

While connecting to Oracle database using sqlplus, you can get an error (./sqlplus: error while loading shared libraries: libsqlplus.so). There can be various reasons for this issue.

After you unzip all the client files, make sure you set the environments variable correctly in your bash file. Generally its your .bashrc file:

ORACLE_HOME=/location of your sqlplus client directory

//In my case i installed under /opt directory.
//By default it makes the directory as instantclient_11_2
// (I installed Oracle 11g r2).
//Then i did mv instantclient_11_2 oracle

Thus now:

ORACLE_HOME= /opt/oracle

//Add $ORACLE_HOME to PATH

PATH=.:$ORACLE_HOME
export PATH
export ORACLE_BASE=/opt
export ORACLE_HOME
export LD_LIBRARY_PATH=$ORACLE_HOME:$ORACLE_HOME/lib

This should solve your issue, however after this you might again get error: sqlplus: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

To resolve this error you need to install libaio1 package:  

(libaio1 - Linux kernel AIO access library - shared library)

# apt-get install libaio1

After the installation, you can connec to to sqlplus:

# ./sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 3 11:56:56 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter user-name: 
Tags: , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*