ABSTRACT
Many Oracle DBAs rely on UNIX scripts running repeating administrative tasks. There are two important advantages of UNIX shells: (1) they are simple, and (2) they are reliable. Adding up some scripts really makes the difference. This chapter considers a pack of utilities for Oracle administration implemented in Bourne shell. These scripts track and report problems with mission-critical Oracle processes — database instances, SQL*Net listeners, and Oracle Web Server listeners. Yet another script from this pack analyzes Oracle export log files, verifies if backup was successful, and reports status to DBAs. We will schedule these scripts in a crontab file for automatic execution.
