Metalink Note:175982.1
适用于
Oracle Server - Enterprise Edition - Version:
Oracle Server - Personal Edition - Version:
Oracle Server - Standard Edition - Version:
本文档中的相关信息适用于任何平台
目的
本文的主要目的是提供对内部错误的高质量的审视，这些错误是在oracle服务器（有时候也指oracle的内核）上产生。同时，对于可能存在的特定错误，给出诸如问题可能的影响之类的问题给出一个指导。这时候，问题是可以重现的，并且具有某些链接特征，可能你很明显的没有想过去利用这些特征。如果与问题有一致的特征，较好的做法是，确保最新的patchsets使用了，并且已经采取合理的措施，以避免已知的问题。
对于可重复的问题，其中ora-600的工具没有列出可能的原因，可以建造一个测试案例试试。如果这是可能的，那么在解决问题的时候，它极为有用。要记住的重要的一点是，在任何实例中，服务器非常灵活，通常可以找到一个折中的临时解决办法。
范围与应用
本文为Oracle DBA提供对数据库内部错误的一个概览。
声明:本文尽一切努力提供尽可能的准确性。请注意，提供的细节只是对某种功能的一种说明，在某些情况下，可能不完全正确。
ORA-600查找错误分类
在Oracle服务器端，有两种类型的ora-600错误：
第一个参数是一个数字反映了与错误有关的源组成部分或层；
第一个参数是一个助记符，表明产生的源模块。现在一般会使用这种类型的内部错误，而不是用一个错误号码。
这两种类型的错误可能在Oracle服务器中发生。
按照数字范围划分的内部错误类别
下表列出了oracle服务器中使用的内部错误代码。因此，当一个ora-600[X]错误发生的时候，就有可能收集一些较为有用的背景信息：错误在Y层产生表明会有个问题Z。
| Ora-600 Base | Functionality | Description | ||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Service Layer | The service layer has within it a variety of service related components which are associated with in memory related activities in the SGA such as, for example : the management of Enqueues, System Parameters, System state objects (these objects track the use of structures in the SGA by Oracle server processes), etc.. In the main, this layer provides support to allow process communication and provides support for locking and the management of structures to support multiple user processes connecting and interacting within the SGA.
Note : vos - Virtual Operating System provides features to support the functionality above. As the name suggests it provides base functionality in much the same way as is provided by an Operating System.
| ||||||||||||||||||||||||||||||||||||||||||||||||
| 2000 | Cache Layer | Where errors are generated in this area, it is advisable to check whether the error is repeatable and whether the error is perhaps associated with recovery or undo type operations; where this is the case and the error is repeatable, this may suggest some kind of hardware or physical issue with a data file, control file or log file. The Cache layer is responsible for making the changes to the underlying files and well as managing the related memory structures in the SGA.
Note : rcv indicates recovery. It is important to remember that the Oracle cache layer is effectively going through the same code paths as used by the recovery mechanism.
It is important to consider when the error occurred and the context in which the error was generated. If the error does not reproduce, it may be an in memory issue. | ||||||||||||||||||||||||||||||||||||||||||||||||
| 4000 | Transaction Layer | Primarily the transaction layer is involved with maintaining structures associated with the management of transactions. As with the cache layer , problems encountered in this layer may indicate some kind of issue at a physical level. Thus it is important to try and repeat the same steps to see if the problem recurs.
It is important to try and determine what the object involved in any reproducible problem is. Then use the analyze command. For more information, please refer to the analyze command as detailed in the context of Note 28814.1; in addition, it may be worth using the dbverify as discussed in Note 35512.1. | ||||||||||||||||||||||||||||||||||||||||||||||||
| 6000 | Data Layer | The data layer is responsible for maintaining and managing the data in the database tables and indexes. Issues in this area may indicate some kind of physical issue at the object level and therefore, it is important to try and isolate the object and then perform. an anlayze on the object to validate its structure.
Again, it is important to try and determine what the object involved in any reproducible problem is. Then use the analyze command. For more information, please refer to the analyze command as detailed in the context of Note 28814.1; in addition, it may be worth using the dbverify as discussed in Note 35512.1. | ||||||||||||||||||||||||||||||||||||||||||||||||
| 12000 | User/Oracle Interface & SQL Layer Components | This layer governs the user interface with the Oracle server. Problems generated by this layer usually indicate : some kind of presentation or format error in the data received by the server, i.e. the client may have sent incomplete information; or there is some kind of issue which indicates that the data is received out of sequence
You should try and repeat the issue and with the use of sql trace , try and isolate where exactly the issue may be occurring within the application. | ||||||||||||||||||||||||||||||||||||||||||||||||
| 14000 | System Dependent Component internal error values | This layer manages interaction with the OS. Effectively it acts as the glue which allows the Oracle server to interact with the OS. The types of operation which this layer manages are indicated as follows.
| ||||||||||||||||||||||||||||||||||||||||||||||||
| 15000 | security/dac, security/logon security/ldap |
local user access validation; challenge / response activity for remote access validation; auditing operation; any activities associated with granting and revoking of privileges; validation of password with external password file | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15100 | dict/sqlddl | this component manages operations associated with creating, compiling (altering), renaming, invalidating, and dropping procedures, functions, and packages. | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15160 | optim/cbo | cost based optimizer layer is used to determine optimal path to the data based on statistical information available on the relevant tables and indexes. | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15190 | optim/cbo | cost based optimizer layer. Used in the generation of a new index to determine how the index should be created. Should it be constructed from the table data or from another index. | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15200 | dict/shrdcurs | used to in creating sharable context area associated with shared cursors | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15230 | dict/sqlddl | manages the compilation of triggers | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15260 | dict/dictlkup dict/libcache |
dictionary lookup and library cache access | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15400 | server/drv | manages alter system and alter session operations | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15410 | progint/if | manages compilation of pl/sql packages and procedures | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15500 | dict/dictlkup | performs dictionary lookup to ensure semantics are correct | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15550 | sqlexec/execsvc sqlexec/rowsrc |
hash join execution management; parallel row source management | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15600 | sqlexec/pq | component provides support for Parallel Query operation | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15620 | repl/snapshots | manages the creation of snapshot or materialized views as well as related snapshot / MV operations | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15640 | repl/defrdrpc | layer containing various functions for examining the deferred transaction queue and retrieving information | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15660 | jobqs/jobq | manages the operation of the Job queue background processes | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15670 | sqlexec/pq | component provides support for Parallel Query operation | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15700 | sqlexec/pq | component provides support for Parallel Query operation; specifically mechanism for starting up and shutting down query slaves | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15800 | sqlexec/pq | component provides support for Parallel Query operation | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15810 | sqlexec/pq | component provides support for Parallel Query operation; specifically functions for creating mechanisms through which Query co-ordinator can communicate with PQ slaves; | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15820 | sqlexec/pq | component provides support for Parallel Query operation | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15850 | sqlexec/execsvc | component provides support for the execution of SQL statements | ||||||||||||||||||||||||||||||||||||||||||||||||
| 15860 | sqlexec/pq | component provides support for Parallel Query operation | ||||||||||||||||||||||||||||||||||||||||||||||||
| 16000 | loader | sql Loader direct load operation; | ||||||||||||||||||||||||||||||||||||||||||||||||
| 16150 | loader | this layer is used for 'C' level call outs to direct loader operation; | ||||||||||||||||||||||||||||||||||||||||||||||||
| 16200 | dict/libcache | this is part of library Cache operation. Amongst other things it manages the dependency of SQL objects and tracks who is permitted to access these objects; | ||||||||||||||||||||||||||||||||||||||||||||||||
| 16230 | dict/libcache | this component is responsible for managing access to remote objects as part of library Cache operation; | ||||||||||||||||||||||||||||||||||||||||||||||||
| 16300 | mts/mts | this component relates to MTS (Multi Threaded Server) operation | ||||||||||||||||||||||||||||||||||||||||||||||||
| 16400 | dict/sqlddl | this layer contains functionality which allows tables to be loaded / truncated and their definitions to be modified. This is part of dictionary operation; | ||||||||||||||||||||||||||||||||||||||||||||||||
| 16450 | dict/libcache | this layer layer provides support for multi-instance access to the library cache; this functionality is applicable therefore to OPS environments; | ||||||||||||||||||||||||||||||||||||||||||||||||
| 16500 | dict/rowcache | this layer provides support to load / cache Oracle's dictionary in memory in the library cache; | ||||||||||||||||||||||||||||||||||||||||||||||||
| 16550 | sqlexec/fixedtab | this component maps data structures maintained in the Oracle code to fixed tables such that they can be queried using the SQL layer; | ||||||||||||||||||||||||||||||||||||||||||||||||
| 16600 | dict/libcache | this layer performs management of data structures within the library cache; | ||||||||||||||||||||||||||||||||||||||||||||||||
| 16651 | dict/libcache | this layer performs management of dictionary related information within library Cache; | ||||||||||||||||||||||||||||||||||||||||||||||||
| 16701 | dict/libcache | this layer provides library Cache support to support database creation and forms part of the bootstrap process; | ||||||||||||||||||||||||||||||||||||||||||||||||
| 17000 | dict/libcache | this is the main library Cache manager. This Layer maintains the in memory representation of cached sql statements together will all the necessary support that this demands; | ||||||||||||||||||||||||||||||||||||||||||||||||
| 17090 | generic/vos | this layer implementations error management operations: signalling errors, catching errors, recovering from errors, setting error frames, etc.; | ||||||||||||||||||||||||||||||||||||||||||||||||
| 17100 | generic/vos | Heap manager. The Heap manager manages the storage of internal data in an orderly and consistent manner. There can be many heaps serving various purposes; and heaps within heaps. Common examples are the SGA heap, UGA heap and the PGA heap. Within a Heap there are consistency markers which aim to ensure that the Heap is always in a consistent state. Heaps are use extensively and are in memory structures - not on disk. | ||||||||||||||||||||||||||||||||||||||||||||||||
| 17200 | dict/libcache | this component deals with loading remote library objects into the local library cache with information from the remote database. | ||||||||||||||||||||||||||||||||||||||||||||||||
| 17250 | dict/libcache | more library cache errors ; functionality for handling pipe operation associated with dbms_pipe | ||||||||||||||||||||||||||||||||||||||||||||||||
| 17270 | dict/instmgmt | this component manages instantiations of procedures, functions, packages, and cursors in a session. This provides a means to keep track of what has been loaded in the event of process death; | ||||||||||||||||||||||||||||||||||||||||||||||||
| 17300 | generic/vos | manages certain types of memory allocation structure. This functionality is an extension of the Heap manager. | ||||||||||||||||||||||||||||||||||||||||||||||||
| 17500 | generic/vos | relates to various I/O operations. These relate to async i/o operation, direct i/o operation and the management of writing buffers from the buffer cache by potentially a number of database writer processes; | ||||||||||||||||||||||||||||||||||||||||||||||||
| 17625 | dict/libcache | additional library Cache supporting functions | ||||||||||||||||||||||||||||||||||||||||||||||||
| 17990 | plsql | plsql 'standard' package related issues | ||||||||||||||||||||||||||||||||||||||||||||||||
| 18000 | txn/lcltx | transaction and savepoint management operations | ||||||||||||||||||||||||||||||||||||||||||||||||
| 19000 | optim/cbo | cost based optimizer related operations | ||||||||||||||||||||||||||||||||||||||||||||||||
| 20000 | ram/index | bitmap index and index related errors. | ||||||||||||||||||||||||||||||||||||||||||||||||
| 20400 | ram/partnmap | operations on partition related objects | ||||||||||||||||||||||||||||||||||||||||||||||||
| 20500 | server/rcv | server recovery related operation | ||||||||||||||||||||||||||||||||||||||||||||||||
| 21000 | repl/defrdrpc, repl/snapshot, repl/trigger |
replication related features | ||||||||||||||||||||||||||||||||||||||||||||||||
| 23000 | oltp/qs | AQ related errors. | ||||||||||||||||||||||||||||||||||||||||||||||||
| 24000 | dict/libcache | operations associated with managing stored outlines | ||||||||||||||||||||||||||||||||||||||||||||||||
| 25000 | server/rcv | tablespace management operations |
按照助记符方式划分的内部错误类别
下表是助记符错误的详细情况，如果你遇到：类似ora-600[kkjsrj:1]的错误，您可以往下继续看，在error这一列中找到匹配项，就可以找到描述，比如kkj表明在执行job队列操作的时候，抛出异常。
| Error Mnemonic(s) | Functionality | Description |
|---|---|---|
| ain ainp | ram/index | ain - alter index; ainp - alter index partition management operation |
| apacb | optim/rbo | used by optimizer in connect by processing |
| atb atbi atbo ctc ctci cvw | 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 evah2p 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 expgon | 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 k2d | 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 |
| k2g k2l | txn/disttx | support for the 2 phase commit protocol protocol and the coordination of the various states in managing the distributed transaction |
| k2r k2s k2sp | progint/distrib | k2r - user interface for managing distributed transactions and combining distributed results ; k2s - handles logging on, starting a transaction, ending a transaction and recovering a transaction; k2sp - management of savepoints in a distributed environment. |
| k2v | txn/disttx | handles distributed recovery operation |
| kad | cartserv/picklercs | handles OCIAnyData implementation |
| kau | ram/data | manages the modification of indexes for inserts, updates and delete operations for IOTs as well as modification of indexes for IOTs |
| kcb kcbb kcbk kcbl kcbs kcbt kcbw kcbz | cache | manages Oracle's buffer cache operation as well as operations used by capabilities such as direct load, has clusters , etc. |
| kcc kcf | rcv | manages and coordinates operations on the control file(s) |
| kcit | context/trigger | internal trigger functionality |
| kck | rcv | compatibility related checks associated with the compatible parameter |
| kcl | cache | background lck process which manages locking in a RAC or parallel server multiple instance environment |
| kco kcq kcra kcrf kcrfr kcrfw kcrp kcrr kcs kct kcv | rcv | various buffer cache operation such as quiesce operation , managing fast start IO target, parallel recovery operation , etc. |
| kd | ram/data | support for row level dependency checking and some log miner operations |
| kda | ram/analyze | manages the analyze command and collection of statistics |
| kdbl kdc kdd | ram/data | support for direct load operation, cluster space management and deleting rows |
| kdg | ram/analyze | gathers information about the underlying data and is used by the analyze command |
| kdi kdibc3 kdibco kdibh kdibl kdibo kdibq kdibr kdic kdici kdii kdil kdir kdis kdiss kdit kdk | ram/index | support of the creation of indexes on tables an IOTs and index look up |
| kdl kdlt | ram/object | lob and temporary lob management |
| kdo | ram/data | operations on data such as inserting a row piece or deleting a row piece |
| kdrp | ram/analyze | underlying support for operations provided by the dbms_repair package |
| kds kdt kdu | ram/data | operations on data such as retrieving a row and updating existing row data |
| kdv kdx | ram/index | functionality for dumping index and managing index blocks |
| kfh kfp kft | rcv | support for writing to file header and transportable tablespace operations |
| kgaj kgam kgan kgas kgat kgav kgaz | argusdbg/argusdbg | support for Java Debug Wire Protocol (JDWP) and debugging facilites |
| kgbt kgg kgh kghs kghx kgkp | vos | kgbt - support for BTree operations; kgg - generic lists processing; kgh - Heap Manager : managing the internal structures withing the SGA / UGA / PGA and ensures their integrity; kghs - Heap manager with Stream support; kghx - fixed sized shared memory manager; kgkp - generic services scheduling policies |
| kgl kgl2 kgl3 kgla kglp kglr kgls | dict/libcache | generic library cache operation |
| kgm kgmt | ilms | support for inter language method services - or calling one language from another |
| kgrq kgsk kgski kgsn kgss | vos | support for priority queue and scheduling; capabilities for Numa support; Service State object manager |
| kgupa kgupb kgupd0 kgupf kgupg kgupi kgupl kgupm kgupp kgupt kgupx kguq2 kguu | vos | Service related activities activities associated with for Process monitor (PMON); spawning or creating of background processes; debugging; managing process address space; managing the background processes; etc. |
| kgxp | vos | inter process communication related functions |
| kjak kjat kjb kjbl kjbm kjbr kjcc kjcs kjctc kjcts kjcv kjdd kjdm kjdr kjdx kjfc kjfm kjfs kjfz kjg kji kjl kjm kjp kjr kjs kjt kju kjx | ccl/dlm | dlm related functionality ; associated with RAC or parallel server operation |
| kjxgf kjxgg kjxgm kjxgn kjxgna kjxgr | ccl/cgs | provides communication & synchronisation associated with GMS or OPS related functionality as well as name service and OPS Instance Membership Recovery Facility |
| kjxt | ccl/dlm | DLM request message management |
| kjzc kjzd kjzf kjzg kjzm | ccl/diag | support for diagnosibility amongst OPS related services |
| kkb | dict/sqlddl | support for operatoins which load/change table definitions |
| kkbl kkbn kkbo | objsupp/objddl | support for tables with lobs , nested tables and varrays as well as columns with objects |
| kkdc kkdl kkdo | dict/dictlkup | support for constraints, dictionary lookup and dictionary support for objects |
| kke | optim/cbo | query engine cost engine; provides support functions that provide cost estimates for queries under a number of different circumstances |
| kkfd | sqlexec/pq | support for performing parallel query operation |
| kkfi | optim/cbo | optimizer support for matching of expressions against functional ndexes |
| kkfr kkfs | sqlexec/pq | support for rowid range handling as well as for building parallel query query operations |
| kkj | jobqs/jobq | job queue operation |
| kkkd kkki | dict/dbsched | resource manager related support. Additionally, provides underlying functions provided by dbms_resource_manager and dbms_resource_manager_privs packages |
| kklr | dict/sqlddl | provides functions used to manipulate LOGGING and/or
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31324783/viewspace-2125053/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
nologging建表
请登录后发表评论
登录
全部评论
最新文章
北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区 广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员 违法和不良信息举报电话:18101376593 |
