Oracle Logs & Trace Files

Oracle logs & Trace Files:

1. Alert Log (alert_SID.log):

    Location: /oracle/SID/saptrace/background

    Log consist of instance activity such as startup, shutdown, switch logfile, parameter change, error etc.

2. Trace File (*.trc):

    2 types of Trace Files:

        System trace--> /oracle/SID/saptrace/background

        User Trace  --> /oracle/SID/saptrace/usertrace

    Normally the error logs globally mentioned in the alert log & more details are written in trace files.

    SQL> show parameter user_dump_dest;

3. Core Dump File:

    Location: /oracle/SID/saptrace/background

    Like core dump in OS. When there are issues related to configuration of OS such as, accessibility,

    oracle storage usually make core dump.

    SQL> show parameter core_dump_dest;

4. Audit File (ora_OSID.aud):

    It contains connection history from user sysdba (sys) & user audit activity for AUDIT_TRAIL = OS.

    If the file system, where audit_file_dest is full, we could not login with sysdba user (sys).

    SQL> show parameter audit_file_dest;

5. Network log (listener.log):

    Location : /oracle/SID/102_64/network/log

    Contains network related logs.