Unix for Oracle DBAs Pocket Reference
Examples

[ Back to: Unix for Oracle DBAs Pocket Reference ]

This page contains links to many of the scripts shown in Unix for Oracle DBAs Pocket Reference. The scripts are organized by major sections as they appear in the book. Only scripts too long to retype are included on this page. The many one and two line commands shown in the book are not reproduced here.

You may download a zip file containing all of the scripts listed on this page. Or you may view any of the scripts individually by following the links provided below.

Unix Server Environment

• dot_profile: Contains commands that the author commonly adds to the .profile files of Oracle users.

• run_sql.ksh: Shows how to place a SQL*Plus script in a Unix shell wrapper.

• check_parms.ksh: Shows how to ensure that proper parameters are passed to a Unix script.

• val_sid.ksh: Demonstrates a method for validating the Oracle SID passed to a Unix shell script.

• rsh_server_loop.ksh: Shows how to loop through .rhosts and use rsh to execute a set of commands on all your Unix servers.

• rsh_sqlplus_loop.ksh: Similar to rsh_server_loop.ksh, but also executes a SQL*Plus script on each Oracle database on each server visited.

• chg_all.sh: Uses sed to do a search and replace on all files in a directory.

Server Monitoring

• cr_vmstat_tab.sql: Creates the table used by get_vmstat.ksh.

• get_vmstat.ksh: Collects statistics at regular intervals using vmstat, and stores them in the mon_vmstat table.

• mon_vmstat_report.sql: SQL*Plus script to generate a report of the statistics contained in the mon_vmstat table.

• cr_iostat_tab.sql: Creates the tables used by get_iostat.ksh.

• get_iostat.ksh: Collects I/O statistics using iostat, and stores them in the database tables created earlier using cr_iostat_tab.sql.

File Management

• del_old_files.ksh: Deletes audit and trace files that are more than 14 days old.

Disk Management

• dialect_changes.ksh: Demonstrates one way of encapsulating Unix dialect differences into a script.

Miscellaneous Shell Scripts

• soft_link.ksh: Creates a soft link to /etc for every tnsnames.ora file on your server.

• tar_backup.ksh: Uses the tar utility to backup database files to tape.

• copy_tnsnames.ksh: Uses rsh to copy a tnsnames.ora file out to all your Oracle servers.

• dead_listener.ksh: Checks to see if the Net8 listener is running, and then restarts the listener if necessary.

• db_run_check.ksh: A script snippet that you can use to cause a script to exit when your database is not running.

• no_connect_alert.ksh: Tests to see if a database is accepting connections, and emails you an alert if it is not.

[ Return to Unix for Oracle DBAs Pocket Reference ]