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

linux oracle installation sqlplus oracleclient
Priyanka U picture Priyanka U · Dec 31, 2014 · Viewed 107k times · Source

Please suggest a solution for solving this issue?? While giving the command:

sqlplus /nolog

the error that occurred:

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

Answer

Sylvain Leroux picture Sylvain Leroux · Dec 31, 2014

The minimum configuration to properly run sqlplus from the shell is to set ORACLE_HOME and LD_LIBRARY_PATH. For ease of use, you might want to set the PATH accordingly too.

Assuming you have unzipped the required archives in /opt/oracle/instantclient_11_1:

$ export ORACLE_HOME=/opt/oracle/instantclient_11_1
$ export LD_LIBRARY_PATH="$ORACLE_HOME"
$ export PATH="$ORACLE_HOME:$PATH"

$ sqlplus

SQL*Plus: Release 11.1.0.7.0 - Production on Wed Dec 31 14:06:06 2014
...

Related questions

How to find which version of Oracle is installed on a Linux server (In terminal)

I am in terminal in Redhat 5.5 and I need to find out which version of Oracle is installed. I am pretty new at Linux, but I have searched Google for a while and I can't find what I need. I …

Read More
libaio.so.1: cannot open shared object file

I have a simple test program that when I run I get: ./hello: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory I link it like this: $(CC) $(CCFLAGS) -o hello hello.…

Read More
Logrotate to clean up date stamped files

I'm currently trying to work out a method of tidying up Oracle Recover log files that are created by Cron... Currently, our Oracle standby recover process is invoked by Cron every 15mins using the following command: 0,15,30,45 * * * * /data/tier2/scripts/recover_…

Read More