UNIX SCRIPTS FOR
ORACLEBig 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
|