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 –
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 “
Last Update: July 28, 2009