ss

Oracle Tips by Burleson

Get the e-mail lists

This section of the script creates a separate e-mail list based on the $ORACLE_SID. By allowing different e-mail list for each database, the same script can be run in large environments where we have dozens of DBAs, each with many databases. This section ensures that the appropriate DBA gets the alert e-mail message.

#*************************************************************
# E-mailx setup
# Here we setup the $dbalist variable to send messages to the right DBA's
#*************************************************************

case $ORACLE_SID in
"PRODV" )
dbalist='steven@oracle.com, joanne@oracle.com,
ngene@oracle.com' ;;
"PUMP1" )
dbalist='shri@oracle.com, \
sash@oracle.com, steven@oracle.com, \
richard@oracle.com, engene@oracle.com' ;;
esac

The above is an excerpt from the "Oracle9i UNIX Administration Handbook" by Oracle press, authored by Donald K. Burleson.

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA