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.
The Oracle Database File System (DBFS) is a feature that creates a standard file system interface on top of files and directories that are stored in database tables. DBFS is similar to NFS in that it provides a shared network file system that looks like a local file system. Like NFS, there is a server... Continue Reading →
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 →
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 →
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.
If you need to determine the configured speeds of the network adapters on your linux server, the ethtool command provides the answer. You can find the speed of all your ethernet adapters with a simple unix script.
During an installation of Oracle 11gR2 Real Application Clusters we encountered a warning during cluster verification that the NTP daemon did not have slewing enabled.