Big Brother - Reads and displays process statistics (memory, %cpu, open files/sockets), one time every 5 seconds. Uses Solaris-specific commands/formats. Submitted by Ivan Muravyev.

Performance Test - This set of script contains 5 shell and PERL scripts, used to stress-test performance of UNIX system. They create long files, load memory, CPU or kernel. Please, be careful, those scripts may cause harm if misused! Contributed by Ivan Muravyev.

Statstics Report - This shell script will execute the STATSRPT SQL Script and e-mail the results using SENDMAIL to a designated address.

Alert Log Error Check (all instances) - This script performs a check of alert log errors for all instance(s) on a server. 

Auto Analyze - This shell script will execute the AUTOANALYZE SQL Script and e-mail the results using SENDMAIL to a designated address.

Capture Pinned Objects - This shell script will execute the CAPTURE_PINNED_OBJECTS SQL Script and e-mail the results using SENDMAIL to a designated address.

Cleanup SNIPED Sessions - A script to clean up sniped sessions at the OS level. The database sessions will dissappear after the OS process is killed 

Cold Backup TAR - Cold backup with tar unix shell script. Contributed by Charles Cao.

Cold Backups - This shell script will facilitate a cold backup.

Cold Backups (All Instances) - This script performs a cold backup for all instance(s) on a server.

Compress Archive Logs - This script will compress archive logs in the directory passed to it

Copy Archive Logs - A script to copy archived redo logs to a secondary standby destination. This can be necessary if the standby exists on another server which is an NFS mounted filesystem. This script will also compress the logs on the primary machine.

Copy Standby Logs - A script to copy the archived redo logs from a primary server to a standby server using an NFS mounted filesystem. This is necessary because Oracle does not support the archive logs writing directly to an NFS filesystem. The alternative is to write to a local filesystem and use this script to copy the file to the NFS mounted filesystem.

COPY-N-MAIL Process - This script will automatically e-mail or copy a report/process output from BANJOB home directory for Banner processing ,if needed. 

Database Clone - This script will create a clone of an Oracle Database.

Database Startup/Shutdown - This script will facilitate start or stop of the Oracle services. Modified to include calls to start the OEM Agent, Data Gatherer and DBSNMP services.

Date Based Directory Cleanup - This shell script will facilitate the deletion of old date-based directories after a period of time. Generate date used to clean up directories older a specified number of days (7 in this example).Can use internal without password for Oracle8.

Delete Old Files - This shell script will delete files older than the designated KEEP duration.

Delete Trace/Dump Files - This shell script will clean up trace files (older than 7 days) in bdump, udump & cdump. It will also to clean up archive files (older than 21 days).

Disk Usage - This script is meant for monitoring the disk space usage. If the space usage capacity for the given file system is more than 90% it will send a warning Email message to DBA Group. If the space usage is more than 95% then it will send a page to the DBA.

NEXT  

Production Ready Unix Scripts

BACK TO SCRIPTS INDEX