If you are running a Linux version that does not support RPM packages and you need to install Oracle's sqlplus client, you have two options to install it:
- If you have a DEBIAN-based Linux distro, download the RPM package and convert it to a DEB package using the alien utility. This can get a little complicated and requires you to unpack the .rpm file and then rebuild the pack of files into a .deb file. And then install it using your preferred DEB package installer.
- Download one of the .zip files from Oracle. Which ones, you ask? It is not obvious which ones to download and if you don't get the correct combination of files, you get errors such as
sqlplus: error while loading shared libraries: libclntsh.so.21.1: cannot open shared object file: No such file or directorywhen you try to run sqlplus. Here is the installation recipe for a full-fat installation of SQLPLUS:
It is possible to call O/S commands or third-party programs from within SQL or PL/SQL with external procedures. This guide describes how to build, install and use such an ExtProc and shows an exploit on how to grant yourself Oracle sysdba rights. Think of an ExtProc as an Oracle root kit.