Alert Log File

Where is Oracle Alert Log Location

Posted on
The Default Location of Oracle Alert Log The location of Oracle alert log may not be easily found, but it’s usually at 3 possible locations: For 11g and Above $ORACLE_BASE/diag/rdbms/<dbname_in_lower_case>/$ORACLE_SID/trace/ As we can notice, Oracle software divides alert logs to their own dedicated directories according to their database names, which is based on directory structure […]
Alert Log File

How to Trim Alert Log File in Oracle

Posted on
The retention of alert log cannot be controlled by ADRCI utility, it needs manual intervention. In this post, I’d like to share how I reduce the size of alert log by means of trimming the content of alert log file in order to save disk space. Clear Alert Log Whenever you want to clear alert […]
Alert Log File

Where is the Alert Log

Posted on
For Oracle 10g downward, the alert file is usually at:$ORACLE_HOME/admin/db_name/bdumpOr possible this one:$ORACLE_BASE/admin/db_name/bdumpBut your database could be different from the convention listed above. You can use the statement below to make sure the location.SQL> show parameter background_dump_dest;NAME                                 TYPE   […]