Oracle错误代码.docx

1、Oracle错误代码1 vos Component notifier100 vos Debug300 vos Error500 vos Lock700 vos Memory900 vos System Parameters1100 vos System State object1110 vos Generic Linked List management1140 vos Enqueue1180 vos Instance Locks1200 vos User State object1400 vos Async Msgs1700 vos license Key1800 vos Instance

2、Registration1850 vos I/O Services components2000 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 m

3、ay 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 t

4、he Oracle cache layer is effectively going through the same code paths as used by the recovery mechanism.Ora-600 Base Functionality Description2000 server/rcv Cache Op2100 server/rcv Control File mgmt2200 server/rcv Misc (SCN etc.)2400 server/rcv Buffer Instance Hash Table2600 server/rcv Redo file c

5、omponent2800 server/rcv Db file3000 server/rcv Redo Application3200 server/cache Buffer manager3400 server/rcv Archival & media recovery component3600 server/rcv recovery component3700 server/rcv Thread component3800 server/rcv Compatibility segmentIt is important to consider when the error occurred

6、 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 encounter

7、ed 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 Base Functionality Description4000 server/txn Transaction Undo4100 server/txn Transaction Undo4210 server/txn Transaction Parallel4250 serv

8、er/txn Transaction List4300 space/spcmgmt Transaction Segment4400 txn/lcltx Transaction Control4450 txn/lcltx distributed transaction control4500 txn/lcltx Transaction Block4600 space/spcmgmt Transaction Table4800 dict/rowcache Query Row Cache4900 space/spcmgmt Transaction Monitor5000 space/spcmgmt

9、Transaction ExtentIt 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 ; in addition, it may be worth using the dbverify as discussed in .600

10、0 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

11、 to validate its structure.Ora-600 Base Functionality Description6000 ram/dataram/analyzeram/index data, analyze command and index related activity7000 ram/object lob related errors8000 ram/data general data access8110 ram/index index related8150 ram/object general data accessAgain, it is important

12、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 ; in addition, it may be worth using the dbverify as discussed in .12000 User/Oracle Interface & SQL Lay

13、er 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 ind

14、icates that the data is received out of sequenceOra-600 Base Functionality Description12200 progint/kpoprogint/opi lob relatederrors at interface level on server side, xa , etc.12300 progint/if OCI interface to coordinating global transactions12400 sqlexec/rowsrc table row source access12600 space/s

15、pcmgmt operations associated with tablespace : alter / create / drop operations ; operations associated with create table / cluster12700 sqlexec/rowsrc bad rowid13000 dict/if dictionary access routines associated with kernel compilation13080 ram/index kernel Index creation13080 sqllang/integ constra

16、int mechanism13100 progint/opi archival and Media Recovery component13200 dict/sqlddl alter table mechanism13250 security/audit audit statement processing13300 objsupp/objdata support for handling of object generation and object access14000 dict/sqlddl sequence generation15000 progint/kpo logon to O

17、racle16000 tools/sqlldr sql loader relatedYou 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

18、 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 Base Functionality Description14000 osds File access14100 osds Concurrency management;14200 osds Process management;14300 osds Exception-handl

19、er or signal handler management14500 osds Memory allocation15000 security/dac,security/logonsecurity/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 pa

20、ssword with external password file15100 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 base

21、d 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

22、creating sharable context area associated with shared cursors15230 dict/sqlddl manages the compilation of triggers15260 dict/dictlkupdict/libcache dictionary lookup and library cache access15400 server/drv manages alter system and alter session operations15410 progint/if manages compilation of pl/sq

23、l packages and procedures15500 dict/dictlkup performs dictionary lookup to ensure semantics are correct15550 sqlexec/execsvcsqlexec/rowsrc hash join execution management;parallel row source management15600 sqlexec/pq component provides support for Parallel Query operation15620 repl/snapshots manages

24、 the creation of snapshot or materialized views as well as related snapshot / MV operations15640 repl/defrdrpc layer containing various functions for examining the deferred transaction queue and retrieving information15660 jobqs/jobq manages the operation of the Job queue background processes15670 s

25、qlexec/pq component provides support for Parallel Query operation15700 sqlexec/pq component provides support for Parallel Query operation; specifically mechanism for starting up and shutting down query slaves15800 sqlexec/pq component provides support for Parallel Query operation15810 sqlexec/pq com

26、ponent 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 operation15850 sqlexec/execsvc component provides support for the execut

27、ion of SQL statements15860 sqlexec/pq component provides support for Parallel Query operation16000 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 thing

28、s 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) operation16400

29、 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 applicabl

30、e therefore to OPS environments;16500 dict/rowcache this layer provides support to load / cache Oracles 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

31、;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 for

32、ms 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