SIMULATE ORA ERROR IN ALERTLOG ORACLE

SIMULATE ORA ERROR IN ALERTLOG ORACLE

To simulate an ora error in alertlog for testing purpose, dbms_system package can be used with ksdwrt procedure

execute dbms_system.ksdwrt(2,to_char(sysdate)|| ' ORA-00600: Testing, Please Ignore!;');

Execute the procedure to simulate the error

SQL> exec dbms_system.ksdwrt(2,to_char(sysdate,'dd-mm-yyyy hh24:mi')||' ORA-00600: Testing! Please ignore!');

PL/SQL procedure successfully completed.

Check the alertlog for sample test message

tail -10f /data01/base/diag/rdbms/dbemt/dbemt/trace/alert_dbemt.log|grep 'ORA-' 
31-01-2022 22:12 ORA-00600: Testing! Please ignore!

Leave a Reply

%d bloggers like this: