Today we are going to have look at the “MONITORING ALERT LOG ORA-ERRORS”. With help of this script DBA can monitor all the ORA-Errors from the alert log and used to send to our mailboxes, he schedules this through a cronjob. Being DBA we all are aware of the importance of Alert Log. For managing the backup we must monitoring alert log.

 

 

 

 

vi monitor_alertlog.sh

tail -100 /u02/app/oracle/diag/rdbms/db/ORCL/trace/alert_ORCL.log > /u02/app/oracle/monitor/temp.lst
cat /u02/app/oracle/monitor/temp.lst | grep ORA- > /u02/app/oracle/monitor/temp1.lst
cnt=`cat /u02/app/oracle/monitor/temp1.lst |wc -l`
if [ $cnt -gt 0 ]; then
/bin/mail -s "ORA ERRORS FOUND IN ORCL ALERT LOG" oraclehelp@gmail.com < /u02/app/oracle/monitor/temp1.lst
fi
rm /u02/app/oracle/monitor/temp.lst /u02/app/oracle/monitor/temp1.lst

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

 

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.