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.

Where is the Oracle alert_protect.log?


Article ID: 160576


Updated On:


Data Loss Prevention Enforce


Data Loss Prevention Enforce:

Where to find the alert_protect.log to troubleshoot database issues?



For Oracle 11g and 12c (11.x and 12.x), the default log location is: 

For Windows:




For Linux:


The alert.log is always located in the trace directory. The location of the trace directory may be changed by a DBA. If the alert log is not located in the listed directory, log into SQLPlus as sysdba, and typing the following:

show parameter background_dump_dest

Note: The filename is alert_<SID>.log. If you are using a SID other than protect, the filename will be changed accordingly. Likewise, on Windows, if Oracle is installed on a drive other than C: (recommended for production installations), then you should look on that drive for the alert log.

The log can also be found with a file search for alert_<SID>.log.