HOEKSTRA.CO.UK

Famous Posters

hoekstra.co.uk

Oracle

Getting Oracle's SQLPlus Client to run on Linux

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:

Read more: Getting Oracle's SQLPlus Client to run on Linux

Download an Oracle Install Package using WGET

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?

Read more: Download an Oracle Install Package using WGET

Oracle server construction guide on Linux

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.
 

Read more: Oracle server construction guide on Linux

Oracle DBMS_PIPE - why you should abandon it

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.

Read more: Oracle DBMS_PIPE - why you should abandon it

Oracle External Procedures

It is possible to call O/S commands or third-party programs from within SQL or PL/SQL with external procedures. Let's build and install an External Procedure on an Oracle Database Server and see how we can call an O/S-level host command from within SQL code to do anything. No, actually, let's not. It is dangerous. Think of an ExtProc as a root kit for Oracle...

Read more: Oracle External Procedures