Oracle collects ORA using ADR tools

Source: Internet
Author: User
Problem description: 2014-06-10 in the checking database warning file, Ora-00600 error, and RmanL1 backup failed, query related information, it is known that the Bug: 9835218. Therefore, we asked SR for official Oracle technical support. Oracle reply: YourServiceRequesthasbeensubmittedasanORA-600ORA-7445iss

Problem description: on February 10, 00600, the Ora-9835218 error occurred while checking the database warning file, and the Rman L1 backup failed. Check the relevant information and find the Bug. Therefore, we asked SR for official Oracle technical support. Oracle replies below: Your Service Request has been submitted as anORA-600/ORA-7445 iss

Problem description:

On February 10, 00600, the Ora-9835218 error occurred while checking the database warning file, and the Rman L1 backup failed. query the relevant information and find that the error was a Bug. Therefore, we asked SR for official Oracle technical support.

Oracle replies as follows:

Your Service Request has been submitted as anORA-600/ORA-7445 issue based on the problem type you chose when logging the 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 was already provided at SRcreation, please ignore this action request.

The SR will be assigned to a technicalengineer after:

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

The engineer will 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 information.

References: Doc ID1638904.1 and Note: 443529.1

Oracle requires collection of relevant abnormal data and upload it to sr. The collection process is described as follows: in this case, when you encounter the same problem, as a reference: 1. Collection of abnormal data ADR path

View parameters: diagnostic_dest + diag/ / / .

You can also query the view: V $ DIAG_INFO:

Execution Process: Enter adrci $ adrci

ADRCI: Release 11.2.0.3.0-Production on Thu Jun 12 09:52:25 2014

Copyright (c) 1982,201 1, 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> sethomepathDatabase_home

View the problem:

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 09:11:17. 274000 + 08: 00

3 ORA 7445 [qecinisub () + 50] 311344 17:31:50. 828000 + 08: 00

4 ORA 600 [krbbsThrottle_zero_total_size] 453579 2014-06-1009:57:18. 828000 + 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 is called an 'incident'. The instance alert filewill show all the incidents reported. Each incident will be associated with aunique incident id in the ADR.

From the ADRCI prompt, executeSHOW INCIDENTCommand forthe problem to be investigated, by specifying the associated problem key. Youcan get the problem key fromSHOW PROBLEMCommand:

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-012. 805002 + 10: 00
1 rows fetched

Package A trace file

Packagethe trace files invoking IPS.

Generate the package usingIPS PACKCommand and store thegenerated package in a directory of your choice. The example below shows thepackage for the incident will 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 for solutions

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.