Alert Log Test Message

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 “