ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How do I reset the Oracle alert log?


Article ID: 160105


Updated On:


Data Loss Prevention Enforce


How to reset the Oracle alert log.


Relevant versions:  Oracle 9.x and above

If the alert log is getting too big, you can perform one of the following actions to remediate (listed in order of preference):

  1. Move the alert log to a different directory.
  2. Compress the alert log
  3. Delete the alert log

The next time the Oracle database needs to write a message into the log it will recreate the file.