8:15 PM - 8:45 AM Breakfast
9:00 AM - 12:00 PM Jon Emmons - Shell Scripting
12:00 PM - 1:30 PM Buffet Lunch & GMOUG Annual Meeting
1:30 PM - 4:00 PM Jon Emmons - SQL Tuning
Many of the best tools for performing complex tasks, monitoring services and automating common administration duties are already included in your UNIX and Linux systems. In this presentation we will examine how to identify tasks to be scripted, discuss many of the key tools for writing shell scripts and examine specific techniques for building robust, reliable shell scripts. The first step to developing scripts is to identify the needs of your environment. We will discuss how nearly all repeated tasks can be at least partially automated. While repeated manual tasks are the most obvious candidate for scripting we will also discuss the value of scripting complex tasks which may only be performed occasionally. Finally we will discuss how shell scripting can be applied for purposes like monitoring and tuning. Next we will look at the anatomy of a shell script including examples for several common purposes. Many common tools will be introduced and we will investigate how these simple tools can be combined to perform complex tasks. Loops and decision making will be discussed and how they can be employed to react to specific conditions on the system. Methods for developing, troubleshooting and testing will also be covered. As with any system it is important to know how you will get feedback when something goes wrong with your shell scripts. We will discuss how to configure your environment so errors in shell scripts are reported properly. Materials for this presentation will include a hardcopy of the presentation outlines and the example scripts shown. The example scripts will also be made available for download after the presentation. Jon Emmons is the author of “Easy Linux Commands: Working Examples of Linux Command Syntax” and “Oracle Shell Scripting: Linux and UNIX Programming for Oracle” both available from Rampant TechPress (www.rampant-books.com.) In addition to his print offerings Jon is also author of the popular blog Life After Coffee (www.lifeaftercoffee.com) where he writes on many topics including Oracle, system administration, music and humor. Jon has several years of experience in system and database administration and is currently working as an Oracle consultant. | 
