说明:
CSDN 的新blog 对表格的样式支持太差,所以这里的排版很不清楚。 可以下载我的word 文档,下载地址,0分资源,有帐号即可下载。
http://download.csdn.net/source/3480570
一.
ORA-600 概述
ORA-600 是一个非常头疼的一个错误。比如:
ORA-00600:internal error code, arguments: [4194], [43], [46], [], [], [], [], []
这个就是undo 损坏出现故障的一个提示信息。关于这种情况的解决方法,参考blog:
Current
online Redo 和 Undo 损坏的处理方法
http://blog.csdn.net/xujinyang/article/details/6822947
Errorsof the form ORA-600 are called internal errors. This section clarifies themisunderstanding of ORA-600s being synonymous with corruption.
An ORA-600 usually has up to five arguments associated withit which gives Oracle support and developers more information about theerror. The first argument of an ORA-600 indicates wherein the source code an unexpected condition was encountered. Theremaining
arguments give information about the variables and data beingexamined. An analyst can then determine if the error was the result of sometype of corruption.
Oracle server source code is subdivided into about 13different layers or modules,each of which is assigned a range of ORA-600 errors. Of these, only some rangespertain directly to the types of corruption described in this paper.
ORA-600通常有5个参数,第一个参数表示的是异常的source
code位置。 Oracle Server source code 大致分为了13个不同的layers 和 modules。 关于第一参数的具体说明,在MOS 的文档:[ID175982.1],有详细的说明。
二.
第一个参数说明
在[ID 175982.1]文档上的定义分成了2种:
(1)the first parameter is a number which reflects the source componentor layer the error is connected with; or
(2)the first parameter is a mnemonic which indicates the source modulewhere the error originated. This type of internal error is now used inpreference to an internal error number.
2.1
Internal Errors Categorised by numberrange
Thefollowing table provides an indication of internal error codes used in theOracle server. Thus, if ora-600[X] is encountered, it is possible to glean somehigh level background information : the error in generated in the Y layer whichindicates that
there may be a problem with Z.
2.2
Internal Errors Categorised by mnemonic
Thefollowing table details mnemonics error stems which are possible. If you haveencountered : ora-600[kkjsrj:1] for example, you should look down the ErrorMnemonic column (errors in alphabetical order) until you find the matchingstem. In this case, kkj
indicates that something unexpected has occurred in jobqueue operation.
Error
|
Functionality
|
Description
|
||
ain
|
ram/index
|
ain - alter index; ainp - alter index partition management operation
|
||
apacb
|
optim/rbo
|
used by optimizer in connect by processing
|
||
atb
|
dict/sqlddl
|
alter table , create table (IOT) or cluster operations as well as create view related operations (with constraint handling functionality)
|
||
dbsdrv
|
sqllang/parse
|
alter / create database operation
|
||
ddfnet
|
progint/distrib
|
various distributed operations on remote dictionary
|
||
delexe
|
sqlexec/dmldrv
|
manages the delete statement operation
|
||
dix
|
ram/index
|
manages drop index or validate index operation
|
||
dtb
|
dict/sqlddl
|
manages drop table operation
|
||
evaa2g
|
dbproc/sqlfunc
|
various functions involves in evaluating operand outcomes such as : addition , average, OR operator, bites AND , bites OR, concatenation, as well as Oracle related functions : count(), dump() , etc. The list is extensive.
|
||
expcmo
|
dbproc/expreval
|
handles expression evaluation with respect to two operands being equivalent
|
||
gra
|
security/dac
|
manages the granting and revoking of privilege rights to a user
|
||
gslcsq
|
plsldap
|
support for operations with an LDAP server
|
||
insexe
|
sqlexec/dmldrv
|
handles the insert statement operation
|
||
jox
|
progint/opi
|
functionality associated with the Java compiler and with the Java runtime environment within the Server
|
||
k2c
|
progint/distrib
|
support for database to database operation in distributed environements as well as providing, with respect to the 2-phase commit protocol, a globally unique Database id
|