Shell Scripts

Shell Scripts:
Monitoring Scripts
Administration Utility Scripts
Performance Scripts
Troubleshooting Scripts

Monitoring Scripts

Check Database is Running

Sends an email when it detects that the specified Oracle database is not running. To setu ...(more)

Sends an email when it detects that the specified Oracle database is not running. To setup notification, you will need a file named .notify_via_email in the owner's home (i.e. $HOME) directory. To setup monitoring, run the shell script from cron at a frequent interval (i.e. once per minute, once per 5 minutes, etc) every day. (less)

Check File System Space

Sends an email when it detects that an oracle dependent file system has less than 10% tota ...(more)

Sends an email when it detects that an oracle dependent file system has less than 10% total space available. To setup notification, configure a file named .notify_via_email in the owner's home (i.e. $HOME) directory. To setup monitoring, run the shell script from cron at a frequent interval (i.e. once per couple hours or so) every day. (less)

Check Tablespace Space

Sends an email when it detects any tablespaces that are more than 99% full. To setup notif ...(more)

Sends an email when it detects any tablespaces that are more than 99% full. To setup notification, you will need a file named .notify_via_email in the owner's home (i.e. $HOME) directory. To setup monitoring, run the shell script from cron at a frequent interval (i.e. once per couple hours or so) every day. (less)

Check Oracle Errors and Core Files

Sends an email when it detects a newly logged ORA- error message in the alert.log file, ...(more)

Sends an email when it detects a newly logged ORA- error message in the alert.log file, or in the .trc files in the BACKGROUND_DUMP_DEST or USER_DUMP_DEST directories. Also reports newly generated core files in the CORE_DUMP_DEST. To setup notification, configure a file named .notify_via_email in the owner's home (i.e. $HOME) directory. To setup monitoring, run the shell script from cron on a daily or weekly interval. (less)

Check Indexes

Sends an email when it detects that any indexes, index partitions, or index subpartitions ...(more)

Sends an email when it detects that any indexes, index partitions, or index subpartitions are in an UNUSABLE state. To setup notification, configure a file named .notify_via_email in the owner's home (i.e. $HOME) directory. To setup monitoring, run the shell script from cron once per day or a couple times per week. (less)

Wakeup PMON

Uses the ORADEBUG WAKEUP command to "wake up" the PMON background process, in the event th ...(more)

Uses the ORADEBUG WAKEUP command to "wake up" the PMON background process, in the event that it doesn't seem to be doing it's job. Generally something like this is not needed, but in some limited cases it might be helpful. (less)

Check INVALID Objects

Sends an email when it detects any invalid compiled database objects, such as database vie ...(more)

Sends an email when it detects any invalid compiled database objects, such as database views or compiled programs (i.e. packages, procedures, functions, triggers). To setup notification, configure a file named .notify_via_email in the owner's home (i.e. $HOME) directory. To setup monitoring, run the shell script from cron at a daily or weekly interval. (less)

Administration Utility Scripts

Clone Subset of Database

Copies a subset (i.e. a specified tablespace plus the SYSTEM tablespace and any tablespace ...(more)

Copies a subset (i.e. a specified tablespace plus the SYSTEM tablespace and any tablespaces with rollback segments) from one database to a new "clone" database. This shell script utilizes the new CONNECT INTERNAL feature of SQL*Plus, which is present from Oracle8 v8.0.5 and forward. Using the technique of "SQL-generating-SQL", this script generates a complete set of SQL scripts to be used in creating a "clone" database. Along the way, the script also serves as terrific documentation of the steps necessary to accomplish, one of the most useful feats in any DBA's bag of tricks. Also requires the SQL script clonedb_arch.sql (ASCII text file - 2Kb). (less)

Performance Scripts

Memory Usage

Uses the pmap utility to display totals of virtual memory consumed by server processes i ...(more)

Uses the pmap utility to display totals of virtual memory consumed by server processes in an Oracle instance. Written and tested on Solaris 8. (less)

Top 10 CPU Intensive Processes

Lists the "top 10" CPU-intensive Oracle "dedicated server" processes. Written for HP-UX; ...(more)

Lists the "top 10" CPU-intensive Oracle "dedicated server" processes. Written for HP-UX; probably adaptable to other versions of UNIX. (less)

Troubleshooting Scripts

Enable SQL Tracing

Enables SQL Tracing at level 12 (i.e. display "bind variable" values as well as "wait even ...(more)

Enables SQL Tracing at level 12 (i.e. display "bind variable" values as well as "wait event" information) for an Oracle session using the Oracle Server Manager ORADEBUG facility. (less)

Disable SQL Tracing

Disables SQL Tracing using the Server Manager ORADEBUG facility.