Frequently Asked Question

1. Alert Log

• Location: $ORACLE_BASE/diag/rdbms///trace/alert_.log

2. Trace Files

• Location: $ORACLE_BASE/diag/rdbms///trace/*.trc

3. Diagnostic Data (incident and trace files)

• Location: $ORACLE_BASE/diag/rdbms///incident/

4. Listener Log

• Location: $ORACLE_BASE/diag/tnslsnr///trace/listener.log

5. Data Pump Log

• Only neccesary uppon OneClickDBA request
• Location: User-defined during Data Pump operations, typically in the $DATA_PUMP_DIR.

6. RMAN Logs

• Only neccesary uppon OneClickDBA request
• Location: User-defined (e.g., /path/to/rman_logs/).

7. SQL*Net Logs

• Files:
  • sqlnet.log (client-side)
  • trace.sqlnet.log (detailed tracing)
  • tnsnames.ora and listener.ora (configuration files)
• Location: $ORACLE_HOME/network/log/

8. Core Dumps

• Only neccesary uppon OneClickDBA request
• Location: $ORACLE_BASE/diag/rdbms///cdump/

9. Operating System Logs

Oracle Support may request OS-level logs, such as:

• /var/log/messages (Linux)
• /var/log/syslog (Linux)
• Event Viewer Logs (Windows)

10. Archive Logs

• Location: $ORACLE_BASE//

11. Clusterware Logs (if using RAC)

• Files:
  • CRS logs ($ORACLE_BASE/diag/crs//crs/trace/alert.log)
  • ASM logs ($ORACLE_BASE/diag/asm//trace/alert_.log)
  • Clusterware-related traces.

12. Automatic Diagnostic Repository (ADR) Logs

• Tool: Use ADRCI commands to collect logs:

  adrci> show incident
  adrci> package generate problem_id 

13. Application Logs

If an issue involves specific applications or queries, Oracle Support might ask for:

• Application logs showing how it interacts with the database.
• Execution plans (EXPLAIN PLAN or SQL_TRACE outputs).

14. AWR / ADDM / ASH Reports

• Commands:
  • Generate AWR:

    >@?/rdbms/admin/awrrpt.sql
    

  • Generate ADDM:

    EXEC DBMS_ADVISOR.CREATE_REPORT('ADDM');
    

  • Generate ASH:

    @?/rdbms/admin/ashrpt.sql

15. Configuration Files

• Files like init.ora or spfile.ora, often requested to analyze initialization parameters.