Seth Miller

Technical ramblings of an IT guy

Category: Scripting

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

EM CLI Jython Script for Target Properties

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

Tablespace Size Report Script (updated)

I actually found it a little difficult to find a good sql script for reporting tablespace size so I took one that was almost there which I believe came from Oracle-Base and modified it to fit my needs. Feel free to comment or modify. Update: I’ve made significant changes to this script including a header […]

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

Tnsnames.ora and XML Solution

I have always found the Oracle connection strings (typically tnsnames.ora) difficult to manage. Even when using LDAP instead of the file, the connection strings still need to be managed even though it only has to be done in one place. After some planning and learning (and relearning) some atrophied perl skills, I created a set […]

Debugging PL/SQL

I recently wrote a stored procedure that wasn’t working so I decided to spend a little time putting in proper debugging. I know there are better ways of doing it including utilizing the IDE capabilities but I just wanted something simple that would be portable with the code.

Oracle OpenWorld 2012

I was about to board a plane to return home to Minneapolis from San Francisco but since my flight is delayed for another hour I will share some thoughts about my week. Today concludes day seven of my second attendance of Oracle OpenWorld. It was bigger and better than ever. Oracle and the sponsors spare […]

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