hoekstra.co.uk
Oracle
- Details
- Parent Category: Software
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:
- Details
- Parent Category: Software
To download an Oracle install package from the otn.oracle.com website, you need to supply a log-in Id and a password and perform the whole operation via a browser that supports JavaScript. But, how does one download Oracle install packages onto a headless server, i.e. without using a browser?
- Details
- Parent Category: Software
A step-by-step construction guide to install and configure a Linux server from scratch and how to then install the Oracle 10g RDBMS on it.
- Details
- Parent Category: Software
A classical method of getting Oracle-based processes communicating with the outside world is by using the DBMS_PIPE package: Typically, we write to a pipe from an Oracle PL/SQL-based process, and then we continuously run an asynchronous Oracle PL/SQL process which reads the pipe and processes what it reads. A common use of DBMS_PIPE is for debugging, logging and launching external processes.
- Details
- Parent Category: Software
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.