oracle-Expdp/impdp命令

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

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 RECOVERABLE attributes of an object (non-partitioned table or index or  partitions of a partitioned table or index)

kkm kkmi 

dict/dictlkup

provides various semantic checking functions 

kkn 

ram/analyze

support for the analyze command

kko kkocri 

optim/cbo

Cost 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/partnmap

support for mapping predicate keys expressions to equivalent partitions

kkpo kkpoc kkpod 

dict/partn

support for creation and modification of partitioned objects

kkqg kkqs kkqs1 kkqs2 kkqs3 kkqu kkqv kkqw 

optim/vwsubq

query rewrite operation 

kks kksa kksh kksl kksm 

dict/shrdcurs

support for managing shared cursors/ shared sql

kkt 

dict/sqlddl

support for creating, altering and dropping trigger definitions as well as handling the trigger operation

kkxa 

repl/defrdrpc

underlying support for dbms_defer_query package operations

kkxb 

dict/sqlddl

library cache interface for external tables 

kkxl 

dict/plsicds

underlying support for the dbms_lob package

kkxm 

progint/opi

support for inter language method services

kkxs 

dict/plsicds

underlying support for the dbms_sys_sql package 

kkxt 

repl/trigger

support for replication internal trigger operation

kkxwtp 

progint/opi

entry point into the plsql compiler

kky 

drv

support for alter system/session commands

kkz kkzd kkzf kkzg kkzi kkzj kkzl kkzo kkzp kkzq kkzr kkzu kkzv 

repl/snapshot

support for snapshots or Materialized View validation and operation

kla klc klcli klx 

tools/sqlldr

support for direct path sql loader operation

kmc kmcp kmd kmm kmr 

mts/mts

support 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/apply

replication apply operation associated with Oracle streams

kncc 

repl/repcache

support for replication related information stored and maintained in library cache

kncd knce 

repl/defrdrpc

replication related enqueue and dequeue of transction data as well as other queue related operations 

kncog 

repl/repcache

support for loading replicaiton object group information into library cache

kni 

repl/trigger

support for replication internal trigger operation

knip knip2 knipi knipl knipr knipu knipu2 knipx 

repl/intpkg

support for replication internal package operation. 

kno 

repl/repobj

support for replication objects 

knp knpc knpcb knpcd knpqc knps 

repl/defrdrpc

operations assocaied with propagating transactions to a remote node and coordination of this activity.

knst 

repl/stats

replication statistics collection

knt kntg kntx 

repl/trigger

support for replication internal trigger operation

koc 

objmgmt/objcache

support for managing ADTs objects in the OOCI heap

kod 

objmgmt/datamgr

support for persistent storage for objects : for read/write objects, to manage object IDs, and to manage object concurrency and recovery. 

koh 

objmgmt/objcache

object heap manager provides memory allocation services for objects

koi 

objmgmt/objmgr

support for object types

koka 

objsupp/objdata

support for reading images, inserting images, updating images, and deleting images based on object references (REFs).

kokb kokb2 

objsupp/objsql

support for nested table objects

kokc 

objmgmt/objcache

support for pinning , unpinning and freeing objects

kokd 

objsupp/datadrv

driver on the server side for managing objects

koke koke2 koki 

objsupp/objsql

support for managing objects

kokl 

objsupp/objdata

lob access

kokl2 

objsupp/objsql

lob DML and programmatic interface support

kokl3 

objsupp/objdata

object temporary LOB support

kokle kokm 

objsupp/objsql

object SQL evaluation functions

kokn 

objsupp/objname

naming support for objects

koko 

objsupp/objsup

support functions to allow oci/rpi to communicate with Object Management Subsystem (OMS).

kokq koks koks2 koks3 koksr 

objsupp/objsql

query optimisation for objects , semantic checking and semantic rewrite operations

kokt kokt2 kokt3 

objsupp/objddl

object compilation type manager

koku kokv 

objsupp/objsql

support for unparse object operators and object view support

kol kolb kole kolf kolo 

objmgmt/objmgr

support for object Lob buffering , object lob evaluation and object Language/runtime functions for Opaque types

kope2 kopi2 kopo kopp2 kopu koputil kopz

objmgmt/pickler

8.1 engine implementation,  implementation of image ops for 8.1+ image format together with various pickler related support functions

kos 

objsupp/objsup

object Stream interfaces for images/objects

kot kot2 kotg 

objmgmt/typemgr

support for dynamic type operations to create, delete, and  update types.

koxs koxx 

objmgmt/objmgt

object generic image Stream routines and miscellaneous generic object functions

kpcp kpcxlt 

progint/kpc

Kernel programmatic connection pooling and kernel programmatic common type XLT translation routines

kpki