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 18.104.22.168.0 Production on Fri Sep 3 11:56:56 2010 Copyright (c) 1982, 2009, Oracle. All rights reserved. Enter user-name: