11g Quick Steps to Package and Send Critical Error Diagnostic Information to Support for further information.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: 11g Quick Steps to Package and Send Critical Error Diagnostic Information to Support for further information.

Symptoms:

Staring with Oracle 11g there is significant change in trace file and alert.log generation. The locations of alert.log and trace files are also changed. This note explains how to find out a tracefile when there is a critical error in the database.


Solution:



From 11g , Whenever any critical error occurs, two files will be created .
1. Trace files .
2. Dump files
Trace files : Trace files have periodic, line-by-line information written by a process as it goes along doing its normal operation.
Dump files : Dumps are typically large blocks of information written in response to an error or other exceptional condition.
For each incident reported , there will be a trace file and incident dumps.
Process trace files are kept in ADR HOME/trace directory and will have name _ora_.trc.
When there is a critical error occur in the database an incident and a corresponding incident directory will be created.
The incident dump file will appear in the incident directory.
Alert log will show the trace file and incident dump for the error reported.
Thu Apr 17 17:11:56 2008
Errors in file e:\app\oracle\diag\rdbms\dmrds11\dmrds11\trace\dmrds11_fbda_2152.trc (incident=119612):
ORA-00600: internal error code, arguments: [ktfacht1-0], [], [], [], [], [], [], []
Incident details in: e:\app\oracle\diag\rdbms\dmrds11\dmrds11\incident\incdir_119612\dmrds11_fbda_2152_i119612.trc
Thu Apr 17 17:11:57 2008
dmrds11_fbda_2152.trc is the trace file .
dmrds11_fbda_2152_i119612.trc is the incident dump.
Most of the cases , incident dump will have the errorstack and will have more information for the error reported .
To identify the trace file from ADRCI :


The steps in identifying a trace file are.

1) Find out the incident number.
2) Find out the trace file.


1) Find out incident number.
adrci> show incident

ADR Home = /ade/prgeorge_v706/oracle/log/diag/rdbms/v706/v706:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
986 ORA 600 [qksdie - feature:QKSFM_CVM] 2007-07-09 21:55:11.566607 -07:00
985 ORA 600 [qksdie - feature:QKSFM_CVM] 2007-07-09 21:10:56.573263 -07:00

2) Now if we want to get the trace file for incindent_id 986
Adrci> show trace -i 986.

This will open the incident dump file. The incident dump file will contain a pointer to the process trace file too.
An example:
/ade/prgeorge_v706/oracle/log/diag/rdbms/v706/v706/incident/incdir_986/v706_ora_6231_i986.trc
----------------------------------------------------------
LEVEL PAYLOAD
----- -----------------------------------------------------------------------------------
Dump file /ade/prgeorge_v706/oracle/log/diag/rdbms/v706/v706/incident/incdir_986/v706_ora_6231_i986.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, Data Mining and Real Application Testing options
..........
..............
*** ACTION NAME:() 2007-07-09 21:55:11.568

Dump continued from file: /ade/prgeorge_v706/oracle/log/diag/rdbms/v706/v706/trace/v706_ora_6231.trc
1> ***** Error Stack *****
ORA-00600: internal error code, arguments: [qksdie - feature:QKSFM_CVM], [], [], [], [], [], [], []

In this example the process trace file is /ade/prgeorge_v706/oracle/log/diag/rdbms/v706/v706/trace/v706_ora_6231.trc

References:


NOTE:422893.1 - 11g Understanding Automatic Diagnostic Repository.

Get Oracle Certifications for all Exams
Free Online Exams.com