#!/usr/bin/ksh

##################################################
# Modifier : shahn                               #
# Modified : 2010-02-02                          #
##################################################

LOGDATE=`date +%Y%m%d`	#Environment variable for date
ALERT_DEST=${ORACLE_BASE}/admin/${ORACLE_SID}/bdump	#Put the value for background_dump_dest
TOPWARE=${HOME}/TOPWARE
LOGDIR=${TOPWARE}/${LOGDATE} #Environment variable for log directory
DBPM_REPORT=dbpm_`hostname`_`echo ${ORACLE_SID}`_`date +%Y%m%d`.rpt	#Report file

export LOGDATE ALERT_DEST TOPWARE LOGDIR DBPM_REPORT	#Export environment variables

echo $LOGDATE;echo $ALERT_DEST;echo $TOPWARE;echo $LOGDIR;echo $DBPM_REPORT

mkdir -p ${LOGDIR}	# Create log directory

echo
echo
echo "**************************************************************************" >> ${LOGDIR}/${DBPM_REPORT}
echo "* Check oracle database                                                  *" >> ${LOGDIR}/${DBPM_REPORT}
echo "**************************************************************************" >> ${LOGDIR}/${DBPM_REPORT}

#sqlplus -s "/ as sysdba" << EOF
sqlplus -s "sys/manager0 as sysdba" << EOF
SPOOL ${LOGDIR}/${DBPM_REPORT}
@dbpm.sql
SPOOL off
exit
EOF

sleep 2

echo >> ${LOGDIR}/${DBPM_REPORT}
echo >> ${LOGDIR}/${DBPM_REPORT}
echo "**************************************************************************" >> ${LOGDIR}/${DBPM_REPORT}
echo "* 5. Check oracle internal error                                         *" >> ${LOGDIR}/${DBPM_REPORT}
echo "**************************************************************************" >> ${LOGDIR}/${DBPM_REPORT}

cd ${ALERT_DEST}
cp alert_${ORACLE_SID}.log alert_${ORACLE_SID}.${LOGDATE}
cp alert_${ORACLE_SID}.${LOGDATE} alert_work.err
touch alert_${ORACLE_SID}.log
grep ORA-600 alert_work.err >> alert.err
grep ORA-00600 alert_work.err >> alert.err
grep ORA-7445 alert_work.err >> alert.err
grep ORA-07445 alert_work.err >> alert.err

cat alert.err >> ${LOGDIR}/${DBPM_REPORT}

rm alert_work.err
rm alert.err

sleep 2

echo >> ${LOGDIR}/${DBPM_REPORT}
echo >> ${LOGDIR}/${DBPM_REPORT}
echo "**************************************************************************" >> ${LOGDIR}/${DBPM_REPORT}
echo "* 6. Check file system usage                                             *" >> ${LOGDIR}/${DBPM_REPORT}
echo "**************************************************************************" >> ${LOGDIR}/${DBPM_REPORT}

PLATFORM=`uname`
case ${PLATFORM} in
 HP-UX) bdf >> ${LOGDIR}/${DBPM_REPORT}
;;
  *)df -k >> ${LOGDIR}/${DBPM_REPORT}
;;
esac