I LOVE SAP

Blog for BASIS Knowledge sharing

Oracle Log and Trace Files

Posted by Della on May 13, 2009

Oracle generates some log files and alerts that can make your file system full
When I googling about that, I found this usefull link Maintenance Log dan Trace File

Here is a short description about oracle logs and trace files:
1. Alert Log –> File name : Alert_SID.log –> Location : /oracle/SID/saptrace/background
consist of instance activity (startup, shutdown, switch logfile, parameter change, error, etc).

2. Trace File –> File name : *.trc
record system or user activity.
System Trace –> Location : /oracle/CAP/saptrace/background
User Trace –> Location : /oracle/CAP/saptrace/usertrace

3. Core dump file
Like core dump in OS, if there is a configuration error such as storage accessibility
Location : /oracle/SID/saptrace/background

4. Audit file –> file name : ora_OSID.aud
contain of connection history from user sysdba and user audit activity for AUDIT_TRAIL=OS

5. Network log –> file name : listener.log
Location : /oracle/SID/102_604/network/log

One Response to “Oracle Log and Trace Files”

  1. TatC said

    hey, thanks very much.. It was quite helpful..

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.