Seth Miller

Technical ramblings of an IT guy

Tag: Bash

How do I identify and set my environment for the Oracle Database and Clusterware homes on a server?

When Oracle software is installed on a server, it generally has a single home referred to as the oracle home. The installer will usually add the oracle home to the central inventory. The location of the central inventory can be determined by querying an operating system specific oracle inventory location file. On Linux, this location […]

Replacement Menu Script for Oracle’s oraenv

This script is a replacement for the “oraenv” script used to set the server environment on an Oracle database server. It’s biggest advantage over oraenv is that it requires far fewer keystrokes and provides a lot more feedback. I’ve been using various versions of this script for years but I decided to put together a […]

Find Instances and Listeners in Linux

I created this script to make it very easy to see which instances and listeners are running on my server. I mostly use it to make sure everything is down when patching in RAC. Stick it in your profile script, or better yet your /etc/bashrc so all users have access to it. function pl { […]