Oracle collects ORA-600 error messages through ADR tools

Problem Description:

2014-06-10 in the checkpoint database warning file, there is a Ora-00600 error, and Rman L1 backup failed, query the relevant information, know is bug:9835218. As a result, SR seeks official Oracle technical support.

Oracle replies as follows:

Your Service Request have been submitted as anora-600/ora-7445 issue based on the problem type you chose when logging T He SR.

Additional diagnostic data is needed.
Execute The action plan described in [Doc ID1638904.1] "ora-600/ora-7445:checklist of Evidence to supply" andupload The collected information to ensure rapid resolution.

If This information is already provided at srcreation, please ignore this action request.

The SR'll is assigned to a technicalengineer after:

1. The requested information is provided
OR
2. Your Service Request is updated asking Forreview and assignment

The engineer would need the diagnostic data toproceed with resolution steps even if assignment is requested.

If You receive a notification that this SR hasbeen updated, un-check the ' Hide System Messages ' box to seeadditional I Nformation.

Reference Documents  : Doc ID1638904.1 and note:443529.1

Oracle requires the collection of relevant anomalies and uploads to SR, and the collection process is described as follows: so that when you encounter the same problem, as a reference:1. Exception data collectionADR Path

View parameters: Diagnostic_dest +diag/<product_type>/<prod_id>/<instance_id>.

You can also query the view: V$diag_info:

Execution Process:input Adrci$ adrci

Adrci:release 11.2.0.3.0-production on Thu June 12 09:52:25 2014

Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved.

ADR base= "/u01/app/oracle"

Adrci>

View $oracle_base

Adrci> Show Home
--show Home Willlist all the ADR homes. Set the proper database ADR home for use with Adrci.
adrci> Sethomepath Database_home

To View the issue:

Adrci> Show Problem

ADR Home =/U01/APP/ORACLE/DIAG/RDBMS/XXXDB/XXXDB2:

*************************************************************************

problem_id Problem_key last_incident Lastinc_time

-------------------- ------------------------------------------------------------------------------- ------------ ----------------------------

1                     ORA 7445[LSFCLN2 () +52]                                      161345                2013-04-3014:02:25.311000 +08:00       

2                     ora 7445 [Kkqstfppu () +150]                                    311712                2014-02-19 09:11:17.274000+08:00      

3                     ORA 7445[qecinisub () +50]                                     311344                2014-03-03 17:31:50.828000+08:00      

4 ORA [krbbsthrottle_zero_total_size] 453579 2014-06-1009:57:18.828 000 +08:00

4 Rows fetched

Adrci>

Analyze Problems

checkfor the incidents reported for the problem which needs to be packaged
Each occurrence of the problem was called an ' incident '. The instance alert Filewill Show all the incidents reported. Each incident is associated with Aunique incident ID in the ADR.

From the Adrci prompt, execute the  SHOW INCIDENT  command forthe problem to being investigated, by Specifying the associated problem key. Youcan get the problem key from the  SHOW problem  command:

adrci> showincident-p "problem_key= ' ORA 1578 '"

ADR Home =/opt/oracle/diag/rdbms/db11g/db11g:
*************************************************************************
incident_id Problem_key Create_time
--------------- ------------------------ ----------------------------------
18147 ORA1578 2009-06-0122:02:08.805002 +10:00
1 Rows fetched

Packaging trace Files

Packagethe trace files invoking IPS.

Generate the package using the IPS PACK command and the store thegenerated package in a directory of your choice. The example below shows thepackage for the incident would be created in The/tmp directory.

adrci> IPs pack incident 18147 In/tmp
Generated Package 9 in File/tmp/ora1578_20090602113045_com_1.zip, Modecomplete

upload to Oracle support to find a solution