News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Alert Log Test Message

  • Posted by Arjun Raja
  • On July 28, 2009
  • 0 Comments

FORCE MESSAGE TO BE WRITTEN TO THE ALERT LOG

If you wish to force an alert to be written to the alert log- for example ORA-600 to test the functioning of a monitoring system you can use this command to force an ORA-600 alert to be written to the alert log.

Login as sysdba

exec dbms_system.ksdwrt(2,’ORA-00600: This is a test error message for monitoring and can be ignored.’);

To check –

cd $BDUMP

view alert_SID.log and you will find the alert written to the log.

Tue Jul 28 10:06:28 2009 ORA-00600: ” This is a test error message for monitoring and can be ignored “

 1

0 Comments

Leave Reply

Your email address will not be published. Required fields are marked *