sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
this is a classic shared object where the shared object cannot be found.
I don't know how it happened, but my sqlplus install had become detached. The solution is simple as root: search for the .so file in your file system. You can do this using your expert knowledge, or find:
find /usr -name 'libsqlplus.so'
Once you have this location, stick the folder which contains this library (i.e. /usr/lib/oracle/11.2/client/lib/) in a file for linker to find:
The linker is call 'ld' and on Fedora 11 uses /etc/ld... for it's configuration files. The final step is to re-configure the dynamic linker run time bindings which is done with: