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?

book

Article ID: 160576

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

Data Loss Prevention Enforce:

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

 

Resolution

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

For Windows:

C:\oracle\diag\rdbms\protect\protect\trace\alert_protect.log

or

C:\app\Administrator\diag\rdbms\protect\protect\trace\alert_protect.log

For Linux:

/opt/oracle/diag/rdbms/protect/protect/trace/alert_protect.log

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.