Seth Miller

Technical ramblings of an IT guy

Category: Linux

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 […]

Oracle DB12c in Docker

Docker has been making a lot of noise in the last couple of years. It piqued my interest recently when I came across a tweet saying that Oracle had recently uploaded an Oracle Linux 7 image to the Docker repository. Containers are nothing new in the Unix space but they are relatively new in Linux. […]

OTN Virtual Technology Summit

On July 9th, 2014, I presented for the Oracle Technology Network Virtual Technology Summit. My first presentation was in the Systems track titled, “Troubleshooting Techniques and Alternative Methods for Common Networking Tasks in Unix and Linux“. The commands used in my presentation and a video file can be found in my Github repository. My second presentation was a co-presentation […]

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 […]

Monitor NFS I/O

We use RMAN to backup to an NFS share. I was having some very lengthy RMAN backup times during certain time periods and the storage team was not able to correlate the slow downs to anything useful so I decided to monitor the NFS shares. I looked at the OS Watcher logs for information about […]

Oracleasmlib Not Necessary

Not only is it not necessary, but it may not even be available. This is in fact exactly what I discovered recently when I installed the Oracle Linux 6u3 and tried to install Clusterware on it. There are three packages that one would normally install as part of ASM: oracleasm-$( uname -r ) # Kernel […]

CRSSTATM: Fun with Awk

If you are not familiar with “awk” (actually “gawk” in Linux), you are missing out a very powerful and versatile interpretive language. It looks cumbersome at first but once you get a grasp of the basic concepts, it is quite simple. The authors (who very unoriginally used the first letters of their surnames to come […]

Oracle OSWatcher: Enterprise Wide Install Tips

I recently finished setting up a two node 11gR1 Oracle RAC cluster. One of the last steps was to run RACCHECK to see if anything was missed. A lot of recommendations came up, including setting up OSWatcher. Setting this up has not been a standard practice for us but I have used it for troubleshooting […]

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 { […]