Shell Programming and Scripting

/etc/oratab

for sid in ${orasids}

orasids=`cat /etc/oratab | grep '11.2.0.2/dbhome_1:Y$' | awk -F: '{print $1}' -`

orasids=`cat /etc/oratab | grep '11.2.0.2/dbhome_1:Y$' | awk -F: '{print $1}' -`

orasids=`cat /etc/oratab | grep '11.2.0.2/dbhome_1:Y$' | awk -F: '{print $1}' -`

$oraisds list all database in oratab as

db1
db2
db3
...
db5

#!/bin/ksh
# This shell performs a full clean audit files  of each DB that is running
export PATH=/opt/oracle/product/11.2.0.2/dbhome_1/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin
export ORACLE_PATH=/opt/oracle/scripts/sql:$ORACLE_HOME/rdbms/admin
export SCRIPTSDIR=/opt/oracle/scripts
export SCRIPTSLOG=/opt/oracle/logs
export LOGFILE=$SCRIPTSLOG/audit_clean.log
export ORACLE_BASE=/opt/oracle
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15
export ORATAB=/etc/oratab
export ORACLE_HOME=/opt/oracle/product/11.2.0.2/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH:/usr/contrib/bin
EMAILFILE=`cat $SCRIPTSDIR/emaildba.lst`
set -A emaillist $EMAILFILE

if [ -f $LOGFILE ]; then
  rm $LOGFILE
fi

orasids=`cat /etc/oratab | grep '11.2.0.2/dbhome_1' | awk -F: '{print $1}' -`

echo "Job: Removing audit file on `hostname` at `date`" > $LOGFILE
echo " " >> $LOGFILE
echo "-----------------------------------------------------------------" >> $LOGFILE
for sid in ${orasids[*]}
do
export ORACLE_SID=$sid
echo "----------------------------------------------" >> $LOGFILE
echo "Database: $ORACLE_SID  Hostname: `hostname`" >> $LOGFILE
echo "----------------------------------------------" >> $LOGFILE

sqlplus -s << EOF
/ as sysdba
@/opt/oracle/scripts/sql/clean_audit.sql
exit
EOF
done

for rec in ${emaillist[*]}
do
mailx -s "Full audit files cleaned on `hostname`" $rec < $LOGFILE
done
exit 0