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
TatC said
hey, thanks very much.. It was quite helpful..