[sysdba@proddb:proddb-/cluster/home/oracle]$ sid
SIDs on this node:
+ASM
proddb
ORACLE_SID = [proddb] ?
The Oracle base remains unchanged with value /cluster/app/grid
ORACLE_SID=proddb
ORACLE_HOME=/cluster/app/grid/product/11.2.0/db_1
[sysdba@proddb:proddb-/cluster/home/oracle]$ adrci
ADRCI: Release 11.2.0.2.0 - Production on Wed Dec 5 10:26:08 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
ADR base = "/cluster/app/grid"
adrci> show home
ADR Homes:
diag/asm/+asm/+ASM
diag/clients/user_sysdba/host_2521857129_80
diag/rdbms/proddb/proddb
diag/tnslsnr/proddb/listener
adrci> set homepath diag/rdbms/proddb/proddb
adrci> show problem
ADR Home = /cluster/app/grid/diag/rdbms/proddb/proddb:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
1 ORA 603 28041 2012-01-12 18:10:07.605000 +00:00
2 ORA 600 [729] 53146 2012-04-26 23:16:44.468000 +01:00
3 ORA 445 72816 2012-10-27 04:37:58.085000 +01:00
6 ORA 600 [17090] 77732 2012-11-26 22:13:57.472000 +00:00
5 ORA 600 77733 2012-11-26 22:14:46.972000 +00:00
7 ORA 600 [ORA-00600: internal error code, arguments: [17090] 77734 2012-11-26 22:14:48.634000 +00:00
8 ORA 600 [ORA-31671: Worker process DW00 had an unhandled ex 77668 2012-11-26 22:14:50.081000 +00:00
4 ORA 7445 [skgpgetinfo()+162] 84821 2012-12-04 17:00:03.936000 +00:00
8 rows fetched
adrci> show incident -p "problem_key='ORA 7445 [skgpgetinfo()+162]'"
ADR Home = /cluster/app/grid/diag/rdbms/proddb/proddb:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
80820 ORA 7445 [skgpgetinfo()+162] 2012-11-20 08:00:05.351000 +00:00
84821 ORA 7445 [skgpgetinfo()+162] 2012-12-04 17:00:03.936000 +00:00
2 rows fetched
adrci> ips pack incident 84821 in /tmp
Generated package 1 in file /tmp/ORA7445sk_20121205104140_COM_1.zip, mode complete
adrci>
If at this step the ADRCI utility complains that the incident was flood-controlled and that no package can be generated for it, then instead of choosing the most recent incident to be packaged, choose the first incident that occurred after an instance startup.
Examples of IPS PACK include:
ips pack problem 100 in /tmp
--Generates the package for the problem id 100 in /tmp
ips pack incident 6439 in /tmp
--Generates the package for the incident id 6439 in /tmp
ips pack problemkey "ORA 1578"
--Generates the package for the problem with the problem_key 'ORA 1578'
ips pack seconds 8
--Generates the package with the incidents occurred in last 8 seconds.
ips pack time '2007-05-01 10:00:00.00' to '2007-05-01 23:00:00.00'
--Generates the package with the incidents occurred between the times '2007-05-01 10:00:00.00' and '2007-05-01 23:00:00.00'
Upload the ZIP file generated to the Service Request you created on the My Oracle Support website . This file will include all the trace files, instance alert file and other diagnostic information for the critical error. Make sure that the ZIP file is uploaded WITHOUT any post processing (such as TAR)
Video Demo:
Database 11g: Quick Steps to Package and Send Critical Error Diagnostic Information to Support [Video] [ID 443529.1]
NOTE:422893.1 - 11g Understanding Automatic Diagnostic Repository.
NOTE:738732.1 - ADR Different Methods to Create IPS Package
NOTE:778.1 - Multimedia Content Reference
No comments:
Post a Comment