Table of Contents
Oracle 要求收集相关异常资料,并上传到sr,现将收集过程介绍如下:以便大家在遇到同样问题时,作为参考:
1.异常资料收集
ADR 路径
执行过程:
输入adrci
$ adrci
查看$ORACLE_BASE
查看问题:
分析问题
打包trace 文件
上传到Oracle Support寻求解决方法
Home Database Mysql Tutorial Oracle 通过ADR工具 收集ORA

Oracle 通过ADR工具 收集ORA

Jun 07, 2016 pm 03:38 PM
oracle tool collect pass question

问题描述: 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寻求解决方法

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Oracle's Role in the Business World Oracle's Role in the Business World Apr 23, 2025 am 12:01 AM

Oracle is not only a database company, but also a leader in cloud computing and ERP systems. 1. Oracle provides comprehensive solutions from database to cloud services and ERP systems. 2. OracleCloud challenges AWS and Azure, providing IaaS, PaaS and SaaS services. 3. Oracle's ERP systems such as E-BusinessSuite and FusionApplications help enterprises optimize operations.

The top ten free platform recommendations for real-time data on currency circle markets are released The top ten free platform recommendations for real-time data on currency circle markets are released Apr 22, 2025 am 08:12 AM

Cryptocurrency data platforms suitable for beginners include CoinMarketCap and non-small trumpet. 1. CoinMarketCap provides global real-time price, market value, and trading volume rankings for novice and basic analysis needs. 2. The non-small quotation provides a Chinese-friendly interface, suitable for Chinese users to quickly screen low-risk potential projects.

What are the digital currency trading apps suitable for beginners? Learn about the coin circle in one article What are the digital currency trading apps suitable for beginners? Learn about the coin circle in one article Apr 22, 2025 am 08:45 AM

When choosing a digital currency trading platform suitable for beginners, you need to consider security, ease of use, educational resources and cost transparency: 1. Priority is given to platforms that provide cold storage, two-factor verification and asset insurance; 2. Apps with a simple interface and clear operation are more suitable for beginners; 3. The platform should provide learning tools such as tutorials and market analysis; 4. Pay attention to hidden costs such as transaction fees and cash withdrawal fees.

Reliable and easy-to-use virtual currency exchange app recommendations The latest ranking of the top ten exchanges in the currency circle Reliable and easy-to-use virtual currency exchange app recommendations The latest ranking of the top ten exchanges in the currency circle Apr 22, 2025 pm 01:21 PM

The reliable and easy-to-use virtual currency exchange apps are: 1. Binance, 2. OKX, 3. Gate.io, 4. Coinbase, 5. Kraken, 6. Huobi Global, 7. Bitfinex, 8. KuCoin, 9. Bittrex, 10. Poloniex. These platforms were selected as the best for their transaction volume, user experience and security, and all offer registration, verification, deposit, withdrawal and transaction operations.

What are the free market viewing software websites? Ranking of the top ten free market viewing software in the currency circle What are the free market viewing software websites? Ranking of the top ten free market viewing software in the currency circle Apr 22, 2025 am 10:57 AM

The top three top ten free market viewing software in the currency circle are OKX, Binance and gate.io. 1. OKX provides a simple interface and real-time data, supporting a variety of charts and market analysis. 2. Binance has powerful functions, accurate data, and is suitable for all kinds of traders. 3. gate.io is known for its stability and comprehensiveness, and is suitable for long-term and short-term investors.

What are the digital currency trading platforms in 2025? The latest rankings of the top ten digital currency apps What are the digital currency trading platforms in 2025? The latest rankings of the top ten digital currency apps Apr 22, 2025 pm 03:09 PM

Recommended apps for the top ten virtual currency viewing platforms: 1. OKX, 2. Binance, 3. Gate.io, 4. Huobi, 5. Coinbase, 6. Kraken, 7. Bitfinex, 8. KuCoin, 9. Bybit, 10. Bitstamp, these platforms provide real-time market trends, technical analysis tools and user-friendly interfaces to help investors make effective market analysis and trading decisions.

Tips and recommendations for the top ten market websites in the currency circle 2025 Tips and recommendations for the top ten market websites in the currency circle 2025 Apr 22, 2025 am 08:03 AM

Domestic user adaptation solutions include compliance channels and localization tools. 1. Compliance channels: Franchise currency exchange through OTC platforms such as Circle Trade, domestically, they need to go through Hong Kong or overseas platforms. 2. Localization tools: Use the currency circle network to obtain Chinese information, and Huobi Global Station provides a meta-universe trading terminal.

Meme Coin Exchange Ranking Meme Coin Main Exchange Top 10 Spots Meme Coin Exchange Ranking Meme Coin Main Exchange Top 10 Spots Apr 22, 2025 am 09:57 AM

The most suitable platforms for trading Meme coins include: 1. Binance, the world's largest, with high liquidity and low handling fees; 2. OkX, an efficient trading engine, supporting a variety of Meme coins; 3. XBIT, decentralized, supporting cross-chain trading; 4. Redim (Solana DEX), low cost, combined with Serum order book; 5. PancakeSwap (BSC DEX), low transaction fees and fast speed; 6. Orca (Solana DEX), user experience optimization; 7. Coinbase, high security, suitable for beginners; 8. Huobi, well-known in Asia, rich trading pairs; 9. DEXRabbit, intelligent

See all articles