Unix Scripts for Database Administrators

Database Administrators and consultants usually posses a set of scripts that they accumulate over a number of years, these become the tools of their trade. At TRU (UK) we would like to share some of the scripts that we find useful and use repeatedly. These Unix scripts are designed for Oracle Users, hence may appear rather basic to Unix Consultants, additionally these scripts have been tested on Solaris, therefore might need changing to work on other platforms.

 

General Scripts
Set-up the Oracle Environment Remove Archive logs older than a specified period.
Monitor the Alert Log Remove Audit logs older than a specified period.
Monitor for Oracle Trace Files Compress Archive Logs older than specified Period
Monitor Top Processes - Similar to Top Monitor Unix System Resource