ora-600内部错误的类型

转载自 http://www.ningoo.net/html/2009/ora-600_internal_error_categories.html,作者:NinGoo 。[@more@]

ora-600是Oracle对于一些内部错误的一个统一的错误号(类似的还有ora-7445)。要判断ora-600错误具体的类型,一般要根据其第一个参数来区分。一个ora-600的例子如下:

ORA-00600: internal error code, arguments: [15700], [3], [0x1DDE1AAB0], [], [], [], [], []

其中15700代表这个错误的具体类型,这是和并行查询相关的一个内部错误,后面的几个参数则是该错误的一些具体参数,不同类型的错误,参数的意义也不尽相同。

ora-600一共有两大类,一类的错误类型以数字标识,另外一类则以字符串标识。数字表示不同的内核层,而字符串则是具体的函数或者模块名。在Metalink的Doc ID: 175982.1 中,oracle列举了这两类错误的详细信息,转录在这里以供需要是查询:

数字类型的Ora-600

Ora-600 BaseFunctionalityDescription
1Service LayerThe 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.

Ora-600 BaseFunctionalityDescription
1vosComponent notifier
100vosDebug
300vosError
500vosLock
700vosMemory
900vosSystem Parameters
1100vosSystem State object
1110vosGeneric Linked List management
1140vosEnqueue
1180vosInstance Locks
1200vosUser State object
1400vosAsync Msgs
1700voslicense Key
1800vosInstance Registration
1850vosI/O Services components
2000Cache LayerWhere 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.

Ora-600 BaseFunctionalityDescription
2000server/rcvCache Op
2100server/rcvControl File mgmt
2200server/rcvMisc (SCN etc.)
2400server/rcvBuffer Instance Hash Table
2600server/rcvRedo file component
2800server/rcvDb file
3000server/rcvRedo Application
3200server/cacheBuffer manager
3400server/rcvArchival & media recovery component
3600server/rcvrecovery component
3700server/rcvThread component
3800server/rcvCompatibility segment

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.

4000Transaction LayerPrimarily 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.

Ora-600 BaseFunctionalityDescription
4000server/txnTransaction Undo
4100server/txnTransaction Undo
4210server/txnTransaction Parallel
4250server/txnTransaction List
4300space/spcmgmtTransaction Segment
4400txn/lcltxTransaction Control
4450txn/lcltxdistributed transaction control
4500txn/lcltxTransaction Block
4600space/spcmgmtTransaction Table
4800dict/rowcacheQuery Row Cache
4900space/spcmgmtTransaction Monitor
5000space/spcmgmtTransaction Extent

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.

6000Data LayerThe 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.

Ora-600 BaseFunctionalityDescription
6000ram/data
ram/analyze
ram/index
data, analyze command and index related activity
7000ram/objectlob related errors
8000ram/datageneral data access
8110ram/indexindex related
8150ram/objectgeneral data access

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.

12000User/Oracle Interface & SQL Layer ComponentsThis 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

Ora-600 BaseFunctionalityDescription
12200progint/kpo
progint/opi
lob related
errors at interface level on server side, xa , etc.
12300progint/ifOCI interface to coordinating global transactions
12400sqlexec/rowsrctable row source access
12600space/spcmgmtoperations associated with tablespace : alter / create / drop operations ; operations associated with create table / cluster
12700sqlexec/rowsrc bad rowid
13000dict/ifdictionary access routines associated with kernel compilation
13080ram/indexkernel Index creation
13080sqllang/integconstraint mechanism
13100progint/opiarchival and Media Recovery component
13200dict/sqlddlalter table mechanism
13250security/auditaudit statement processing
13300objsupp/objdatasupport for handling of object generation and object access
14000dict/sqlddlsequence generation
15000progint/kpologon to Oracle
16000tools/sqlldrsql loader related

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.

14000System Dependent Component internal error valuesThis 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.

Ora-600 BaseFunctionalityDescription
14000osdsFile access
14100osdsConcurrency management;
14200osdsProcess management;
14300osdsException-handler or signal handler management
14500osdsMemory allocation
15000security/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
15100dict/sqlddlthis component manages operations associated with creating, compiling (altering), renaming, invalidating, and dropping procedures, functions, and packages.
15160optim/cbocost based optimizer layer is used to determine optimal path to the data based on statistical information available on the relevant tables and indexes.
15190optim/cbocost 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.
15200dict/shrdcursused to in creating sharable context area associated with shared cursors
15230dict/sqlddlmanages the compilation of triggers
15260dict/dictlkup
dict/libcache
dictionary lookup and library cache access
15400server/drvmanages alter system and alter session operations
15410progint/ifmanages compilation of pl/sql packages and procedures
15500dict/dictlkupperforms dictionary lookup to ensure semantics are correct
15550sqlexec/execsvc
sqlexec/rowsrc
hash join execution management;
parallel row source management
15600sqlexec/pqcomponent provides support for Parallel Query operation
15620repl/snapshotsmanages the creation of snapshot or materialized views as well as related snapshot / MV operations
15640repl/defrdrpclayer containing various functions for examining the deferred transaction queue and retrieving information
15660jobqs/jobqmanages the operation of the Job queue background processes
15670sqlexec/pqcomponent provides support for Parallel Query operation
15700sqlexec/pqcomponent provides support for Parallel Query operation; specifically mechanism for starting up and shutting down query slaves
15800sqlexec/pqcomponent provides support for Parallel Query operation
15810sqlexec/pqcomponent provides support for Parallel Query operation; specifically functions for creating mechanisms through which Query co-ordinator can communicate with PQ slaves;
15820sqlexec/pqcomponent provides support for Parallel Query operation
15850sqlexec/execsvccomponent provides support for the execution of SQL statements
15860sqlexec/pqcomponent provides support for Parallel Query operation
16000loadersql Loader direct load operation;
16150loaderthis layer is used for ‘C’ level call outs to direct loader operation;
16200dict/libcachethis 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;
16230dict/libcachethis component is responsible for managing access to remote objects as part of library Cache operation;
16300mts/mtsthis component relates to MTS (Multi Threaded Server) operation
16400dict/sqlddlthis layer contains functionality which allows tables to be loaded / truncated and their definitions to be modified. This is part of dictionary operation;
16450dict/libcachethis layer layer provides support for multi-instance access to the library cache; this functionality is applicable therefore to OPS environments;
16500dict/rowcachethis layer provides support to load / cache Oracle’s dictionary in memory in the library cache;
16550sqlexec/fixedtabthis component maps data structures maintained in the Oracle code to fixed tables such that they can be queried using the SQL layer;
16600dict/libcachethis layer performs management of data structures within the library cache;
16651dict/libcachethis layer performs management of dictionary related information within library Cache;
16701dict/libcachethis layer provides library Cache support to support database creation and forms part of the bootstrap process;
17000dict/libcachethis 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;
17090generic/vosthis layer implementations error management operations: signalling errors, catching errors, recovering from errors, setting error frames, etc.;
17100generic/vosHeap 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.
17200dict/libcachethis component deals with loading remote library objects into the local library cache with information from the remote database.
17250dict/libcachemore library cache errors ; functionality for handling pipe operation associated with dbms_pipe
17270dict/instmgmtthis 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;
17300generic/vosmanages certain types of memory allocation structure. This functionality is an extension of the Heap manager.
17500generic/vosrelates 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;
17625dict/libcacheadditional library Cache supporting functions
17990plsqlplsql ‘standard’ package related issues
18000txn/lcltxtransaction and savepoint management operations
19000optim/cbocost based optimizer related operations
20000ram/indexbitmap index and index related errors.
20400ram/partnmapoperations on partition related objects
20500server/rcvserver recovery related operation
21000repl/defrdrpc,
repl/snapshot,
repl/trigger
replication related features
23000oltp/qsAQ related errors.
24000dict/libcacheoperations associated with managing stored outlines
25000server/rcvtablespace management operations

字符串类型的Ora-600

Error Mnemonic(s)FunctionalityDescription
ain ainp ram/indexain – alter index; ainp - alter index partition management operation
apacb optim/rboused by optimizer in connect by processing
atb atbi atbo ctc ctci cvw dict/sqlddlalter table , create table (IOT) or cluster operations as well as create view related operations (with constraint handling functionality)
dbsdrvsqllang/parsealter / create database operation
ddfnet progint/distribvarious distributed operations on remote dictionary
delexe sqlexec/dmldrvmanages the delete statement operation
dix ram/indexmanages drop index or validate index operation
dtb dict/sqlddlmanages drop table operation
evaa2g evah2p evaa2g dbproc/sqlfuncvarious 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/exprevalhandles expression evaluation with respect to two operands being equivalent
gra security/dacmanages the granting and revoking of privilege rights to a user
gslcsq plsldapsupport for operations with an LDAP server
insexe sqlexec/dmldrvhandles the insert statement operation
jox progint/opifunctionality associated with the Java compiler and with the Java runtime environment within the Server
k2c k2d progint/distribsupport 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 k2ltxn/disttxsupport for the 2 phase commit protocol protocol and the coordination of the various states in managing the distributed transaction
k2r k2s k2sp progint/distribk2r – 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/disttxhandles distributed recovery operation
kad cartserv/picklercshandles OCIAnyData implementation
kau ram/datamanages 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 cachemanages Oracle’s buffer cache operation as well as operations used by capabilities such as direct load, has clusters , etc.
kcc kcf rcvmanages and coordinates operations on the control file(s)
kcit context/triggerinternal trigger functionality
kck rcvcompatibility related checks associated with the compatible parameter
kcl cachebackground 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 rcvvarious buffer cache operation such as quiesce operation , managing fast start IO target, parallel recovery operation , etc.
kd ram/datasupport for row level dependency checking and some log miner operations
kda ram/analyzemanages the analyze command and collection of statistics
kdbl kdc kdd ram/datasupport for direct load operation, cluster space management and deleting rows
kdg ram/analyzegathers 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/indexsupport of the creation of indexes on tables an IOTs and index look up
kdl kdlt ram/objectlob and temporary lob management
kdo ram/dataoperations on data such as inserting a row piece or deleting a row piece
kdrp ram/analyzeunderlying support for operations provided by the dbms_repair package
kds kdt kdu ram/dataoperations on data such as retrieving a row and updating existing row data
kdv kdx ram/indexfunctionality for dumping index and managing index blocks
kfc kfd kfg asmsupport for ASM file and disk operations
kfh kfp kft rcvsupport for writing to file header and transportable tablespace operations
kgaj kgam kgan kgas kgat kgav kgaz argusdbg/argusdbgsupport for Java Debug Wire Protocol (JDWP) and debugging facilites
kgbt kgg kgh kghs kghx kgkpvoskgbt – 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/libcachegeneric library cache operation
kgm kgmt ilmssupport for inter language method services – or calling one language from another
kgrq kgsk kgski kgsn kgss vossupport 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 vosService 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 vosinter 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/dlmdlm related functionality ; associated with RAC or parallel server operation
kjxgf kjxgg kjxgm kjxgn kjxgna kjxgr ccl/cgsprovides communication & synchronisation associated with GMS or OPS related functionality as well as name service and OPS Instance Membership Recovery Facility
kjxt ccl/dlmDLM request message management
kjzc kjzd kjzf kjzg kjzm ccl/diagsupport for diagnosibility amongst OPS related services
kkb dict/sqlddlsupport for operatoins which load/change table definitions
kkbl kkbn kkbo objsupp/objddlsupport for tables with lobs , nested tables and varrays as well as columns with objects
kkdc kkdl kkdo dict/dictlkupsupport for constraints, dictionary lookup and dictionary support for objects
kke optim/cboquery engine cost engine; provides support functions that provide cost estimates for queries under a number of different circumstances
kkfd sqlexec/pqsupport for performing parallel query operation
kkfi optim/cbooptimizer support for matching of expressions against functional ndexes
kkfr kkfs sqlexec/pqsupport for rowid range handling as well as for building parallel query query operations
kkj jobqs/jobqjob queue operation
kkkd kkki dict/dbschedresource manager related support. Additionally, provides underlying functions provided by dbms_resource_manager and dbms_resource_manager_privs packages
kklr dict/sqlddlprovides functions used to manipulate LOGGING and/or RECOVERABLE attributes of an object (non-partitioned table or index or partitions of a partitioned table or index)
kkm kkmi dict/dictlkupprovides various semantic checking functions
kkn ram/analyzesupport for the analyze command
kko kkocri optim/cboCost based Optimizer operation : generates alternative execution
plans in order to find the optimal / quickest access to the data. Also , support to determine cost and applicability of scanning a given index in trying to create or rebuild an index or a partition thereof
kkpam kkpap ram/partnmapsupport for mapping predicate keys expressions to equivalent partitions
kkpo kkpoc kkpod dict/partnsupport for creation and modification of partitioned objects
kkqg kkqs kkqs1 kkqs2 kkqs3 kkqu kkqv kkqw optim/vwsubqquery rewrite operation
kks kksa kksh kksl kksm dict/shrdcurssupport for managing shared cursors/ shared sql
kkt dict/sqlddlsupport for creating, altering and dropping trigger definitions as well as handling the trigger operation
kkxa repl/defrdrpcunderlying support for dbms_defer_query package operations
kkxb dict/sqlddllibrary cache interface for external tables
kkxl dict/plsicdsunderlying support for the dbms_lob package
kkxm progint/opisupport for inter language method services
kkxs dict/plsicdsunderlying support for the dbms_sys_sql package
kkxt repl/triggersupport for replication internal trigger operation
kkxwtp progint/opientry point into the plsql compiler
kky drvsupport for alter system/session commands
kkz kkzd kkzf kkzg kkzi kkzj kkzl kkzo kkzp kkzq kkzr kkzu kkzv repl/snapshotsupport for snapshots or Materialized View validation and operation
kla klc klcli klx tools/sqlldrsupport for direct path sql loader operation
kmc kmcp kmd kmm kmr mts/mtssupport for Multi Threaded server operation (MTS) : manange and
operate the virtual circuit mechanism, handle the dispatching of massages, administer shared servers and for collecting and maintaining statistics associated with MTS
knac knafh knaha knahc knahf knahs repl/applyreplication apply operation associated with Oracle streams
kncc repl/repcachesupport for replication related information stored and maintained in library cache
kncd knce repl/defrdrpcreplication related enqueue and dequeue of transction data as well as other queue related operations
kncog repl/repcachesupport for loading replicaiton object group information into library cache
kni repl/triggersupport for replication internal trigger operation
knip knip2 knipi knipl knipr knipu knipu2 knipx repl/intpkgsupport for replication internal package operation.
kno repl/repobjsupport for replication objects
knp knpc knpcb knpcd knpqc knps repl/defrdrpcoperations assocaied with propagating transactions to a remote node and coordination of this activity.
knst repl/statsreplication statistics collection
knt kntg kntx repl/triggersupport for replication internal trigger operation
koc objmgmt/objcachesupport for managing ADTs objects in the OOCI heap
kod objmgmt/datamgrsupport for persistent storage for objects : for read/write objects, to manage object IDs, and to manage object concurrency and recovery.
koh objmgmt/objcacheobject heap manager provides memory allocation services for objects
koi objmgmt/objmgrsupport for object types
koka objsupp/objdatasupport for reading images, inserting images, updating images, and deleting images based on object references (REFs).
kokb kokb2 objsupp/objsqlsupport for nested table objects
kokc objmgmt/objcachesupport for pinning , unpinning and freeing objects
kokd objsupp/datadrvdriver on the server side for managing objects
koke koke2 koki objsupp/objsqlsupport for managing objects
kokl objsupp/objdatalob access
kokl2 objsupp/objsqllob DML and programmatic interface support
kokl3 objsupp/objdataobject temporary LOB support
kokle kokm objsupp/objsqlobject SQL evaluation functions
kokn objsupp/objnamenaming support for objects
koko objsupp/objsupsupport functions to allow oci/rpi to communicate with Object Management Subsystem (OMS).
kokq koks koks2 koks3 koksr objsupp/objsqlquery optimisation for objects , semantic checking and semantic rewrite operations
kokt kokt2 kokt3 objsupp/objddlobject compilation type manager
koku kokv objsupp/objsqlsupport for unparse object operators and object view support
kol kolb kole kolf kolo objmgmt/objmgrsupport for object Lob buffering , object lob evaluation and object Language/runtime functions for Opaque types
kope2 kopi2 kopo kopp2 kopu koputil kopzobjmgmt/pickler8.1 engine implementation, implementation of image ops for 8.1+ image format together with various pickler related support functions
kos objsupp/objsupobject Stream interfaces for images/objects
kot kot2 kotg objmgmt/typemgrsupport for dynamic type operations to create, delete, and update types.
koxs koxx objmgmt/objmgtobject generic image Stream routines and miscellaneous generic object functions
kpcp kpcxlt progint/kpcKernel programmatic connection pooling and kernel programmatic common type XLT translation routines
kpki progint/kpkikernel programatic interface support
kpls cartserv/corecssupport for string formatting operations
kpn progint/kpnsupport for server to server communication
kpoal8 kpoaq kpob kpodny kpodp kpods kpokgt kpolob kpolon kpon progint/kposupport for programmatic operations
kpor progint/opisupport for streaming protocol used by replication
kposc progint/kposupport for scrollable cursors
kpotc progint/opioracle side support functions for setting up trusted external procedure callbacks
kpotx kpov progint/kposupport for managing local and distributed transaction coordination.
kpp2 kpp3 sqllang/parsekpp2 – parse routines for dimensions;
kpp3 – parse support for create/alter/drop summary statements
kprb kprc progint/rpisupport for executing sql efficiently on the Oracle server side as well as for copying data types during rpi operations
kptsc progint/twotaskcallback functions provided to all streaming operation as part of replication functionality
kpu kpuc kpucp progint/kpuOracle kernel side programmatic user interface, cursor management functions and client side connection pooling support
kqan kqap kqas argusdbg/argusdbgserver-side notifiers and callbacks for debug operations.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13162384/viewspace-1052101/,如需转载,请注明出处,否则将追究法律责任。

user_pic_default.png
请登录后发表评论 登录
全部评论
<%=items[i].createtime%>

<%=items[i].content%>

<%if(items[i].items.items.length) { %>
<%for(var j=0;j
<%=items[i].items.items[j].createtime%> 回复

<%=items[i].items.items[j].username%>   回复   <%=items[i].items.items[j].tousername%><%=items[i].items.items[j].content%>

<%}%> <%if(items[i].items.total > 5) { %>
还有<%=items[i].items.total-5%>条评论 ) data-count=1 data-flag=true>点击查看
<%}%>
<%}%> <%}%>

转载于:http://blog.itpub.net/13162384/viewspace-1052101/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值