Oracle 通过ADR工具 收集ORA
问题描述: 2014-06-10 在点检数据库预警文件时,出现Ora -00600 错误,并且Rman L1 备份失败,查询相关资料,得知是Bug:9835218。于是,提SR寻求Oracle 官方技术支持。 Oracle回复如下: Your Service Request has been submitted as anORA-600/ORA-7445 iss
问题描述:
2014-06-10 在点检数据库预警文件时,出现Ora -00600 错误,并且Rman L1 备份失败,查询相关资料,得知是Bug:9835218。于是,提SR寻求Oracle 官方技术支持。
Oracle回复如下:
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.
参考文档: Doc ID1638904.1 和 Note:443529.1
Oracle 要求收集相关异常资料,并上传到sr,现将收集过程介绍如下:以便大家在遇到同样问题时,作为参考:
1.异常资料收集
ADR 路径
查看参数: diagnostic_dest +diag/
也可以查询视图: V$DIAG_INFO:
执行过程:
输入adrci
$ adrci
ADRCI:Release 11.2.0.3.0 - Production on Thu Jun 12 09:52:25 2014
Copyright(c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
ADR base= "/u01/app/oracle"
adrci>
查看$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
查看问题:
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 600 [krbbsThrottle_zero_total_size] 453579 2014-06-1009:57:18.828000 +08:00
4 rows fetched
adrci>
分析问题
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, execute the SHOW INCIDENT command forthe problem to be 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
打包trace 文件
Packagethe trace files invoking IPS.
Generate the package using the IPS PACK command 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
上传到Oracle Support寻求解决方法

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

This article describes how to build a highly available MongoDB database on a Debian system. We will explore multiple ways to ensure data security and services continue to operate. Key strategy: ReplicaSet: ReplicaSet: Use replicasets to achieve data redundancy and automatic failover. When a master node fails, the replica set will automatically elect a new master node to ensure the continuous availability of the service. Data backup and recovery: Regularly use the mongodump command to backup the database and formulate effective recovery strategies to deal with the risk of data loss. Monitoring and Alarms: Deploy monitoring tools (such as Prometheus, Grafana) to monitor the running status of MongoDB in real time, and

This article introduces a variety of methods and tools to monitor PostgreSQL databases under the Debian system, helping you to fully grasp database performance monitoring. 1. Use PostgreSQL to build-in monitoring view PostgreSQL itself provides multiple views for monitoring database activities: pg_stat_activity: displays database activities in real time, including connections, queries, transactions and other information. pg_stat_replication: Monitors replication status, especially suitable for stream replication clusters. pg_stat_database: Provides database statistics, such as database size, transaction commit/rollback times and other key indicators. 2. Use log analysis tool pgBadg

Regarding the problem of removing the Python interpreter that comes with Linux systems, many Linux distributions will preinstall the Python interpreter when installed, and it does not use the package manager...

How to teach computer novice programming basics within 10 hours? If you only have 10 hours to teach computer novice some programming knowledge, what would you choose to teach...

The network configuration of the Debian system is mainly implemented through the /etc/network/interfaces file, which defines network interface parameters, such as IP address, gateway, and DNS server. Debian systems usually use ifup and ifdown commands to start and stop network interfaces. By modifying the ifeline in the interfaces file, you can set a static IP or use DHCP to dynamically obtain the IP address. It should be noted that Debian12 and subsequent versions no longer use NetworkManager by default, so other command-line tools, such as IP commands, may be required to manage network interfaces. You can edit /etc/netwo

Understanding the anti-crawling strategy of Investing.com Many people often try to crawl news data from Investing.com (https://cn.investing.com/news/latest-news)...

Downloading software from official Debian or reliable sources is crucial. The following steps and suggestions can effectively ensure the security of the downloaded Debian system or software package: 1. Verify the integrity of the software package After downloading the Debian image, be sure to use MD5 or SHA256 and other checksums to verify its integrity to prevent malicious tampering. 2. Choose a secure mirror source to always download from the Debian official website or a reputable third-party mirror site. Priority is given to official certification or mirroring sources provided by large institutions. 3. Keep the system updates and installation immediately after running sudoaptupdate&&sudoaptupgrade to fix potential security vulnerabilities. It is recommended to install unattend

This article describes how to optimize ZooKeeper performance on Debian systems. We will provide advice on hardware, operating system, ZooKeeper configuration and monitoring. 1. Optimize storage media upgrade at the system level: Replacing traditional mechanical hard drives with SSD solid-state drives will significantly improve I/O performance and reduce access latency. Disable swap partitioning: By adjusting kernel parameters, reduce dependence on swap partitions and avoid performance losses caused by frequent memory and disk swaps. Improve file descriptor upper limit: Increase the number of file descriptors allowed to be opened at the same time by the system to avoid resource limitations affecting the processing efficiency of ZooKeeper. 2. ZooKeeper configuration optimization zoo.cfg file configuration
