Oracle错误代码.docx

Oracle错误代码.docx

《Oracle错误代码.docx》由会员分享，可在线阅读，更多相关《Oracle错误代码.docx（18页珍藏版）》请在冰点文库上搜索。

Oracle错误代码

1vosComponentnotifier

100vosDebug

300vosError

500vosLock

700vosMemory

900vosSystemParameters

1100vosSystemStateobject

1110vosGenericLinkedListmanagement

1140vosEnqueue

1180vosInstanceLocks

1200vosUserStateobject

1400vosAsyncMsgs

1700voslicenseKey

1800vosInstanceRegistration

1850vosI/OServicescomponents

2000CacheLayerWhereerrorsaregeneratedinthisarea,itisadvisabletocheckwhethertheerrorisrepeatableandwhethertheerrorisperhapsassociatedwithrecoveryorundotypeoperations;wherethisisthecaseandtheerrorisrepeatable,thismaysuggestsomekindofhardwareorphysicalissuewithadatafile,controlfileorlogfile.TheCachelayerisresponsibleformakingthechangestotheunderlyingfilesandwellasmanagingtherelatedmemorystructuresintheSGA.

Note:

rcvindicatesrecovery.ItisimportanttorememberthattheOraclecachelayeriseffectivelygoingthroughthesamecodepathsasusedbytherecoverymechanism.

Ora-600BaseFunctionalityDescription

2000server/rcvCacheOp

2100server/rcvControlFilemgmt

2200server/rcvMisc（SCNetc.）

2400server/rcvBufferInstanceHashTable

2600server/rcvRedofilecomponent

2800server/rcvDbfile

3000server/rcvRedoApplication

3200server/cacheBuffermanager

3400server/rcvArchival&mediarecoverycomponent

3600server/rcvrecoverycomponent

3700server/rcvThreadcomponent

3800server/rcvCompatibilitysegment

Itisimportanttoconsiderwhentheerroroccurredandthecontextinwhichtheerrorwasgenerated.Iftheerrordoesnotreproduce,itmaybeaninmemoryissue.

4000TransactionLayerPrimarilythetransactionlayerisinvolvedwithmaintainingstructuresassociatedwiththemanagementoftransactions.Aswiththecachelayer,problemsencounteredinthislayermayindicatesomekindofissueataphysicallevel.Thusitisimportanttotryandrepeatthesamestepstoseeiftheproblemrecurs.

Ora-600BaseFunctionalityDescription

4000server/txnTransactionUndo

4100server/txnTransactionUndo

4210server/txnTransactionParallel

4250server/txnTransactionList

4300space/spcmgmtTransactionSegment

4400txn/lcltxTransactionControl

4450txn/lcltxdistributedtransactioncontrol

4500txn/lcltxTransactionBlock

4600space/spcmgmtTransactionTable

4800dict/rowcacheQueryRowCache

4900space/spcmgmtTransactionMonitor

5000space/spcmgmtTransactionExtent

Itisimportanttotryanddeterminewhattheobjectinvolvedinanyreproducibleproblemis.Thenusetheanalyzecommand.Formoreinformation,pleaserefertotheanalyzecommandasdetailedinthecontextof<;inaddition,itmaybeworthusingthedbverifyasdiscussedin<.

6000DataLayerThedatalayerisresponsibleformaintainingandmanagingthedatainthedatabasetablesandindexes.Issuesinthisareamayindicatesomekindofphysicalissueattheobjectlevelandtherefore,itisimportanttotryandisolatetheobjectandthenperformananlayzeontheobjecttovalidateitsstructure.

Ora-600BaseFunctionalityDescription

6000ram/data

ram/analyze

ram/indexdata,analyzecommandandindexrelatedactivity

7000ram/objectlobrelatederrors

8000ram/datageneraldataaccess

8110ram/indexindexrelated

8150ram/objectgeneraldataaccess

Again,itisimportanttotryanddeterminewhattheobjectinvolvedinanyreproducibleproblemis.Thenusetheanalyzecommand.Formoreinformation,pleaserefertotheanalyzecommandasdetailedinthecontextof<;inaddition,itmaybeworthusingthedbverifyasdiscussedin<.

12000User/OracleInterface&SQLLayerComponentsThislayergovernstheuserinterfacewiththeOracleserver.Problemsgeneratedbythislayerusuallyindicate:

somekindofpresentationorformaterrorinthedatareceivedbytheserver,i.e.theclientmayhavesentincompleteinformation;orthereissomekindofissuewhichindicatesthatthedataisreceivedoutofsequence

Ora-600BaseFunctionalityDescription

12200progint/kpo

progint/opilobrelated

errorsatinterfacelevelonserverside,xa,etc.

12300progint/ifOCIinterfacetocoordinatingglobaltransactions

12400sqlexec/rowsrctablerowsourceaccess

12600space/spcmgmtoperationsassociatedwithtablespace:

alter/create/dropoperations;operationsassociatedwithcreatetable/cluster

12700sqlexec/rowsrcbadrowid

13000dict/ifdictionaryaccessroutinesassociatedwithkernelcompilation

13080ram/indexkernelIndexcreation

13080sqllang/integconstraintmechanism

13100progint/opiarchivalandMediaRecoverycomponent

13200dict/sqlddlaltertablemechanism

13250security/auditauditstatementprocessing

13300objsupp/objdatasupportforhandlingofobjectgenerationandobjectaccess

14000dict/sqlddlsequencegeneration

15000progint/kpologontoOracle

16000tools/sqlldrsqlloaderrelated

Youshouldtryandrepeattheissueandwiththeuseofsqltrace,tryandisolatewhereexactlytheissuemaybeoccurringwithintheapplication.

14000SystemDependentComponentinternalerrorvaluesThislayermanagesinteractionwiththeOS.EffectivelyitactsasthegluewhichallowstheOracleservertointeractwiththeOS.Thetypesofoperationwhichthislayermanagesareindicatedasfollows.

Ora-600BaseFunctionalityDescription

14000osdsFileaccess

14100osdsConcurrencymanagement;

14200osdsProcessmanagement;

14300osdsException-handlerorsignalhandlermanagement

14500osdsMemoryallocation

15000security/dac,

security/logon

security/ldaplocaluseraccessvalidation;challenge/responseactivityforremoteaccessvalidation;auditingoperation;anyactivitiesassociatedwithgrantingandrevokingofprivileges;validationofpasswordwithexternalpasswordfile

15100dict/sqlddlthiscomponentmanagesoperationsassociatedwithcreating,compiling（altering）,renaming,invalidating,anddroppingprocedures,functions,andpackages.

15160optim/cbocostbasedoptimizerlayerisusedtodetermineoptimalpathtothedatabasedonstatisticalinformationavailableontherelevanttablesandindexes.

15190optim/cbocostbasedoptimizerlayer.Usedinthegenerationofanewindextodeterminehowtheindexshouldbecreated.Shoulditbeconstructedfromthetabledataorfromanotherindex.

15200dict/shrdcursusedtoincreatingsharablecontextareaassociatedwithsharedcursors

15230dict/sqlddlmanagesthecompilationoftriggers

15260dict/dictlkup

dict/libcachedictionarylookupandlibrarycacheaccess

15400server/drvmanagesaltersystemandaltersessionoperations

15410progint/ifmanagescompilationofpl/sqlpackagesandprocedures

15500dict/dictlkupperformsdictionarylookuptoensuresemanticsarecorrect

15550sqlexec/execsvc

sqlexec/rowsrchashjoinexecutionmanagement;

parallelrowsourcemanagement

15600sqlexec/pqcomponentprovidessupportforParallelQueryoperation

15620repl/snapshotsmanagesthecreationofsnapshotormaterializedviewsaswellasrelatedsnapshot/MVoperations

15640repl/defrdrpclayercontainingvariousfunctionsforexaminingthedeferredtransactionqueueandretrievinginformation

15660jobqs/jobqmanagestheoperationoftheJobqueuebackgroundprocesses

15670sqlexec/pqcomponentprovidessupportforParallelQueryoperation

15700sqlexec/pqcomponentprovidessupportforParallelQueryoperation;specificallymechanismforstartingupandshuttingdownqueryslaves

15800sqlexec/pqcomponentprovidessupportforParallelQueryoperation

15810sqlexec/pqcomponentprovidessupportforParallelQueryoperation;specificallyfunctionsforcreatingmechanismsthroughwhichQueryco-ordinatorcancommunicatewithPQslaves;

15820sqlexec/pqcomponentprovidessupportforParallelQueryoperation

15850sqlexec/execsvccomponentprovidessupportfortheexecutionofSQLstatements

15860sqlexec/pqcomponentprovidessupportforParallelQueryoperation

16000loadersqlLoaderdirectloadoperation;

16150loaderthislayerisusedfor‘C’levelcalloutstodirectloaderoperation;

16200dict/libcachethisispartoflibraryCacheoperation.AmongstotherthingsitmanagesthedependencyofSQLobjectsandtrackswhoispermittedtoaccesstheseobjects;

16230dict/libcachethiscomponentisresponsibleformanagingaccesstoremoteobjectsaspartoflibraryCacheoperation;

16300mts/mtsthiscomponentrelatestoMTS（MultiThreadedServer）operation

16400dict/sqlddlthislayercontainsfunctionalitywhichallowstablestobeloaded/truncatedandtheirdefinitionstobemodified.Thisispartofdictionaryoperation;

16450dict/libcachethislayerlayerprovidessupportformulti-instanceaccesstothelibrarycache;thisfunctionalityisapplicablethereforetoOPSenvironments;

16500dict/rowcachethislayerprovidessupporttoload/cacheOracle’sdictionaryinmemoryinthelibrarycache;

16550sqlexec/fixedtabthiscomponentmapsdatastructuresmaintainedintheOraclecodetofixedtablessuchthattheycanbequeriedusingtheSQLlayer;

16600dict/libcachethislayerperformsmanagementofdatastructureswithinthelibrarycache;

16651dict/libcachethislayerperformsmanagementofdictionaryrelatedinformationwithinlibraryCache;

16701dict/libcachethislayerprovideslibraryCachesupporttosupportdatabasecreationandformspartofthebootstrapprocess;

17000dict/libcachethisisthemainlibraryCachemanager.ThisLayermaintainstheinmemoryrepresentationofcachedsqlstatementstogetherwillallthenecessarysupportthatthisdemands;

17090generic/vosthislayerimplementationserrormanagementoperations:

signallingerrors,catchingerrors,recoveringfromerrors,settingerrorframes,etc.;

17100generic/vosHeapmanager.TheHeapmanagermanages