Unix for Oracle DBAs Pocket Reference
[ 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
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
- 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.
- cr_vmstat_tab.sql: Creates the table used
- 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
- get_iostat.ksh: Collects I/O statistics using
iostat, and stores them in the database tables created earlier using
- 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 ]
oreilly.com Home |
O'Reilly Bookstores |
How to Order |
About O'Reilly |
Affiliated Companies |
© 2001, O'Reilly & Associates, Inc.