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.
Imported Document ID: TECH221596
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe