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

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

Issue Received from Application Team:


Hi DBA Team,

Could not able to connect to database from 1.***.***.101 server from sqlplus.


Could you please check the prerequisite on this server from DBA side?

[webdb@G****INPLEWEB2P admin]$ sqlplus user@testdbprd
sqlplus: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory


================================================================================================================================================

ERROR:

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

RESOLUTION:

We advised to install libaio1, with the following:

sudo apt-get install libaio1


and set and export following environmental variables before connecting again:


ORACLE_HOME
ORACLE_SID
LD_LIBRARY_PATH
ORACLE_BASE


Please install 32 bit version aswell.

Common Errors and Resolutions while installing Oracle Client:

========================================================================

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

If you get this, it’s probably because you haven’t set your environment variables.  Ours looked vaguely like this:

export ORACLE_HOME=/usr/lib/oracle/11.2/client

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

export PATH=$ORACLE_HOME/bin:$PATH



Another common error is due to lack of libaio1, so if you see this:

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

then you should install that as well, with the following:

sudo apt-get install libaio1