Chapter 19
UNIX Scripts for Oracle Administration
Serg Shestakov
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. ...
Get Oracle Internals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
