Kornshell function declarations

Over the years I have seen and maintained many kornshell scripts written by DBAs, and there are a number of programming styles that provoke strong reactions on who is doing it the "right" way. In this article, I will explain the different ways in which functions can be defined in Kornshell and explain why I personally prefer one method over another.

Installing FUSE on linux (for DBFS)

Filesystem in Userspace (FUSE) is a loadable kernel module for Unix-like computer operating systems that lets non-privileged users create their own file systems without editing kernel code. This is achieved by running file system code in user space while the FUSE module provides only a "bridge" to the actual kernel interfaces. It is a pre-requisite... Continue Reading →

A guide to Oracle Wallet

It is often necessary to make connections to the database from shell scripts held on the filesystem. This can be a major security issue if these scripts contain the database connection details. One solution is to use OS Authentication, but Oracle 10g Release 2 gives us the option of using a secure external password store... Continue Reading →

Installing Oracle Enterprise Linux

Whilst building a virtual machine for some Oracle development work I thought it would be useful to document the installation of the OS and Oracle components for future builds. The following guide documents the installation of Oracle Enterprise Linux 5 into a Virtualbox VM ready for a 11g database installation.

Blog at WordPress.com.

Up ↑