大师，求讲解一下11g的自动诊断功能incident
最近发现数据库出现Exception
Incident 488910 created, dump file: /u01/app/oracle/diag/rdbms/jsdb/jsdb2/incident/incdir_488910/jsdb2_ora_9136_i488910.trc
ORA-07445: exception encountered: core dump []
然后发现bdump下的incident目录下，出现一个65G的dump文件，经查明发现是adr工具自动生成的。如果要等位系统问题所在，要读这个65G的dump文件吗，或者有什么更好的解决办法？
本帖最后由 北极光 于 2012-5-25 12:49 编辑
去查dump文件（/u01/app/oracle/diag/rdbms/jsdb/jsdb2/incident/incdir_488910/jsdb2_ora_9136_i488910.trc）头部就行，通常能看出是哪个代码引起了这个oracle bug。
然后去support.metalink.com查找ora-00600和ora-07445的查询工具页面,用这段信息进行查找，看看是打patch解决还是改写代码回避。 北极光 发表于 2012-5-25 12:47 static/image/common/back.gif
去查dump文件（/u01/app/oracle/diag/rdbms/jsdb/jsdb2/incident/incdir_488910/jsdb2_ora_9136_i488910.tr ...
这个是最新的错误对应的dump
Dump file /u01/app/oracle/diag/rdbms/jsdb/jsdb1/incident/incdir_1170226/jsdb1_ora_21767_i1170226.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db
System name: Linux
Node name: rac01
Release: 2.6.18-194.el5
Version: #1 SMP Tue Mar 16 21:52:39 EDT 2010
Machine: x86_64
Instance name: jsdb1
Redo thread mounted by this instance: 1
Oracle process number: 1547
Unix process pid: 21767, image: oracle@rac01
*** 2012-05-25 13:05:11.390
*** SESSION ID:(4076.5) 2012-05-25 13:05:11.390
*** CLIENT ID:() 2012-05-25 13:05:11.390
*** SERVICE NAME:(SYS$USERS) 2012-05-25 13:05:11.390
*** MODULE NAME:(JDBC Thin Client) 2012-05-25 13:05:11.390
*** ACTION NAME:() 2012-05-25 13:05:11.390
Dump continued from file: /u01/app/oracle/diag/rdbms/jsdb/jsdb1/trace/jsdb1_ora_21767.trc
ORA-00600: internal error code, arguments: , , [], [], [], [], [], [], [], [],
[], []
ORA-07445: exception encountered: core dump [PC:0
x46B8A41] [Invalid permissions
========= Dump for incident 1170226 (ORA 600 ) ========
----- Beginning of Customized Incident Dump(s) -----
***** Internal heap ERROR kghrcdepth:ds addr=0x2b6faacf0030 ds=0x2b6faacc4780 *****
***** Dump of memory around addr 0x2b6faacf0030:
2B6FAACEF030 000000A5 00000191 00000002 00001147[............G...]
2B6FAACEF040 00000001 00000000 00000000 00000000[................]
2B6FAACEF050 00000000 00000000 00000000 00000000[................]
Repeat 2 times
2B6FAACEF080 E783F478 00000012 E783F478 00000012
2B6FAACEF090 E783F3C0 00000012 E783F550 00000012[........P.......]
2B6FAACEF0A0 00000000 00000000 00000000 00000000[................]
2B6FAACEF0B0 00000090 00000000 00000000 00000000[................]
2B6FAACEF0C0 00000000 00000000 FD92D3E0 00000012[................]
2B6FAACEF0D0 FD92D3E0 00000012 11A6EBD0 00000013[................]
2B6FAACEF0E0 00000000 00000000 00000001 00000001[................]
2B6FAACEF0F0 00000000 00000000 000000A0 00000191[................]
2B6FAACEF100 00000002 0000114C 00000006 00000000[....L...........]
2B6FAACEF110 00000000 00000000 00000000 00000000[................]
我只复制了一部分，按照您说的，看头部，怎么确定问题呢？
ORA-600
--------------------------------------------------------------------------------
修改时间 30-JAN-2012 类型 REFERENCE 状态 PUBLISHED
In this Document
Purpose
Scope
ORA-600
--------------------------------------------------------------------------------
Applies to:
Oracle Server - Enterprise Edition
Information in this document applies to any platform.
Purpose
Note: For additional ORA-600 related information please read Document 1092832.1
This article represents a partially published OERI note.
It has been published because the ORA-600 error has been
reported in at least one confirmed bug.
Therefore, the SUGGESTIONS section of this article may help
in terms of identifying the cause of the error.
This specific ORA-600 error may be considered for full publication
at a later date. If/when fully published, additional information
will be available here on the nature of this error.
Scope
ERROR: Format: ORA-600
ORA-600
SUGGESTIONS:
If the Known Issues section below does not help in terms of identifying
a solution, please submit the trace files and alert.log to Oracle
Support Services for further analysis.
Known Issues:
Known Bugs
You can restrict the list below to issues likely to affect one of the following versions by clicking the relevant button:
NB Bug Fixed Description
+ 9019113 11.2.0.1.BP02, 11.2.0.2, 12.1.0.0 ORA-600 for OLTP COMPRESS table in OLTP Compression REDO V11010006 V11010007 V11020001 COMPRESS CORR CORR/LOG DUMP OERI
•'*' against a bug indicates that an alert exists for that issue.
•'+' indicates a particularly notable bug.
•'P' indicates a port specific bug.
•Fixed versions use "BPnn" to indicate Exadata bundle nn.
•"OERI:xxxx" may be used as shorthand for ORA-600 .
--------------------------------------------------------------------------------
相关内容
--------------------------------------------------------------------------------
产品
--------------------------------------------------------------------------------
•Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
关键字
--------------------------------------------------------------------------------
BUGTAG_ADDBUGS
错误
--------------------------------------------------------------------------------
ORA-600 北极光 发表于 2012-5-29 21:04 static/image/common/back.gif
ORA-600
----------------------------------------------------------------------- ...
明白了，非常感谢
页:
[1]