:

ORA-00600: internal error code, arguments: [kzaxins:sqtxt]

We had a scheduled job which ran each day to delete the archive logs which we no longer required. We noticed that the same job errored intermittently with the following error message:

ORA-00600: internal error code, arguments: [kzaxins:sqtxt], [], [], [], [], [], [], []

I don’t think it is specific to the command we were running to delete the archive logs, but this is what we were running:

run
{
DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE '(TRUNC(SYSDATE-2))' BACKED UP 1 TIMES TO DEVICE TYPE = DISK;
}

It turns out that the reason for this error is because we had the AUDIT_TRAIL parameter set to XML. In our case it was XML, EXTENDED.

Like it, share it...

Category: ORA 600


Related Posts

Leave a Reply

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