Oracle 故障处理合辑

ORA-00001~ORA-00100·ORA-00001 normal,successful completion·ORA-00018 maximum number of sessions exceeded·ORA-00054 resource busy and acquire with NOWAIT specifie·ORA-00054 resource busy and acquire with NOWAIT specifie·ORA-00054 resource busy and acquire with NOWAIT specifie·ORA-00093 string must be between string and stringORA-00201~ORA-00300·ORA-00205 error in identifying controlfile, check alert log for more info·ORA-00205 error in identifying controlfile, check alert log for more info·ORA-00205 error in identifying controlfile, check alert log for more info·ORA-00206 error in writing (block string, # blocks string) of controlfile·ORA-00214 controlfile 'string' version string inconsistent with file 'string' version string·ORA-00245 control file backup operation failed·ORA-00257 archiver error. Connect internal only, until freed·ORA-00257 archiver error. Connect internal only, until freed·ORA-00257 archiver error. Connect internal only, until freed·ORA-00257 archiver error. Connect internal only, until freed·ORA-00257 archiver error. Connect internal only, until freed·ORA-00258 manual archiving in NOARCHIVELOG mode must identify log·ORA-00283 recovery session canceled due to errors·ORA-00283 recovery session canceled due to errorsORA-00401~ORA-00500·ORA-00494: enqueue [CF] held for too long·ORA-00494: enqueue [CF] held for too longORA-00601~ORA-00700·ORA-00603 ORACLE server session terminated by fatal error·ORA-00604 error occurred at recursive SQL level string·ORA-00604 error occurred at recursive SQL level string·ORA-00604 error occurred at recursive SQL level string·ORA-00604 error occurred at recursive SQL level string·ORA-00604 error occurred at recursive SQL level string·ORA-00604 error occurred at recursive SQL level string·ORA-00607 Internal error occurred while making a change to a data blockORA-00801~ORA-00900·ORA-00844 Parameter not taking MEMORY_TARGET into account, see alert log for more information·ORA-00845 MEMORY_TARGET not supported on this system·ORA-00845 MEMORY_TARGET not supported on this systemORA-01001~ORA-01100·ORA-01002 fetch out of sequence·ORA-01002 fetch out of sequence·ORA-01008 not all variables bound·ORA-01013 user requested cancel of current operation·ORA-01013 user requested cancel of current operation·ORA-01031 insufficient privileges·ORA-01031 insufficient privileges·ORA-01031 insufficient privileges·ORA-01031 insufficient privileges·ORA-01031 insufficient privileges·ORA-01034 ORACLE not available·ORA-01075 you are currently logged on·ORA-01075 you are currently logged on·ORA-01078 failure in processing system parameters·ORA-01078 failure in processing system parameters·ORA-01078 failure in processing system parameters·ORA-01092 ORACLE instance terminated. Disconnection forcedORA-01201~ORA-01300·ORA-01219 database not open: queries allowed on fixed tables/views onlyORA-01401~ORA-01500·ORA-01403 no data found·ORA-01407 cannot update ("SCOTT"."A"."A1") to NULL·ORA-01410 invalid ROWID·ORA-01450 maximum key length (string) exceeded·ORA-01461 can bind a LONG value only for insert into a LONG column·ORA-01461 can bind a LONG value only for insert into a LONG column·ORA-01461 can bind a LONG value only for insert into a LONG columnORA-01601~ORA-01700·ORA-01610 recovery using the BACKUP CONTROLFILE option must be done·ORA-01652 unable to extend temp segment by string in tablespace string·ORA-01658 unable to create INITIAL extent for segment in tablespace string·ORA-01679 database must be mounted EXCLUSIVE and not open to activateORA-01801~ORA-01900·ORA-01843 not a valid monthORA-02001~ORA-02100·ORA-02020 too many database links in use·ORA-02020 too many database links in use·ORA-02046 distributed transaction already begun·ORA-02065 illegal option for ALTER SYSTEM·ORA-02085 database link string connects to string·ORA-02085 database link string connects to string·ORA-02085 database link string connects to stringORA-02201~ORA-02300·ORA-02291 integrity constraint (string.string) violated - parent key not foundORA-02401~ORA-02500·ORA-02429 cannot drop index used for enforcement of unique/primary key·ORA-02429 cannot drop index used for enforcement of unique/primary keyORA-03201~ORA-03300·ORA-03214 File Size specified is smaller than minimum requiredORA-4001~ORA-04100·ORA-04021 timeout occurred while waiting to lock object·ORA-04030 out of process memory when trying to allocate string bytes (string,string)·ORA-04030 out of process memory when trying to allocate string bytes (string,string)·ORA-04031 unable to allocate string bytes of shared memory·ORA-04031 unable to allocate string bytes of shared memory·ORA-04031 unable to allocate string bytes of shared memory·ORA-04031 unable to allocate string bytes of shared memory·ORA-04031 unable to allocate string bytes of shared memory·ORA-04031 unable to allocate string bytes of shared memory·ORA-04043 object dba_data_files does not exist·ORA-04045 errors during recompilation/revalidation of string.string·ORA-04063 string has errors·ORA-04063 string has errors·ORA-04063 string has errors·ORA-04098 trigger 'string' is invalid and failed re-validation ORA-07201~ORA-07300·ORA-07217 sltln: environment variable cannot be evaluated ORA-07401~ORA-07500·ORA-07445 exception encountered: core dump·ORA-07445 exception encountered: core dump·ORA-07445 exception encountered: core dump·ORA-07445 exception encountered: core dump·ORA-07445 exception encountered: core dump ORA-09801~ORA-09900·ORA-09817 Write to audit file failed. ORA-12001~ORA-13000·ORA-12005 may not schedule automatic refresh for times in the past·ORA-12091 cannot online redefine table "string" ORA-12401~ORA-12500·ORA-12500 TNS : listener failed to start a dedicated server process·ORA-12500 TNS : listener failed to start a dedicated server process ORA-012601~ORA-12700·ORA-12638 Credential retrieval failed·ORA-12638 Credential retrieval failed ORA-12801~ORA-12900·ORA-12840 cannot access remote table in a parallel transaction·ORA-12899 value too large for column ORA-14001~ORA-14100·ORA-14098 index mismatch for tables in ALTER TABLE EXCHANGE PARTITION ORA-15001~ORA-15100·ORA-15027 active use of diskgroup "DGSYSTEM" precludes its dismount·ORA-15032 not all alterations performed·ORA-15046 ASM file name '+DATA/ractest/backup/users.264.664395373' is not in single-file creation form·ORA-15055 Unable to Connect to ASM When Starting an Instance·ORA-15055 Unable to Connect to ASM When Starting an Instance·ORA-15077 could not locate ASM instance serving a required diskgroup ORA-16001~ORA-16100·ORA-16014 log string sequence# string not archived, no available destinations·ORA-16014 log string sequence# string not archived, no available destinations·ORA-16038 log string sequence# string cannot be archived·ORA-16038 log string sequence# string cannot be archived·ORA-16038 log string sequence# string cannot be archived ORA-16401~ORA-16500·ORA-16401 archive log rejected by Remote File Server ORA-19201~ORA-19300·ORA-19206 Invalid value for query or REF CURSOR parameter ORA-19801~ORA-19900·ORA-19804 cannot reclaim 18055168 bytes disk space from 85899345920 limitORA-20001~ORA-20100·ORA-20005 object statistics are locked (stattype = ALL)ORA-26601~ORA-26700·ORA-26663 error queue for apply processORA-27001~ORA-27100·ORA-27037 unable to obtain file status·ORA-27037 unable to obtain file status·ORA-27046 file size is not a multiple of logical block size·ORA-27046 file size is not a multiple of logical block size·ORA-27069 skgfdisp: attempt to do I/O beyond the range of the file·ORA-27072 skgfdisp: I/O error·ORA-27091 skgfqio: unable to queue I/O·ORA-27100 shared memory realm already exists·ORA-27100 shared memory realm already existsORA-27201~ORA-27300·ORA-27300 OS system dependent operation:string failed with status: string·ORA-27300 OS system dependent operation:string failed with status: string·ORA-27300 OS system dependent operation:string failed with status: string·ORA-27300 OS system dependent operation:string failed with status: stringORA-28001~ORA-28100·ORA-28056 Writing audit records to Windows Event Log failed·ORA-28056 Writing audit records to Windows Event Log failedORA-29801~ORA-29900·ORA-29807 specified operator does not existORA-30001~ORA-30100·ORA-30012 undo tablespace 'UNDOTBS1' does not exist or of wrong type·ORA-30036 unable to extend segment by 8 in undo tablespace 'UNDOTBS1'ORA-31601~ORA-31700·ORA-31626 job does not exist·ORA-31655 no data or metadata objects selected for job·ORA-31694 master table "NEWTHSI"."SYS_IMPORT_SCHEMA_01" failed to load/unload ORA-00101~ORA-00200·ORA-00106 cannot startup/shutdown database when connected to a dispatcher·ORA-00108 failed to set up dispatcher to accept connection asynchronously·ORA-00119 invalid specification for system parameter MTS_LISTENER_ADDRESS·ORA-00119 invalid specification for system parameter MTS_LISTENER_ADDRESS·ORA-00130 invalid listener address·ORA-00132 syntax error or unresolved network name ’LISTENER_ORCL’ORA-00301~ORA-00400·ORA-00312 online log string thread string: 'string'·ORA-00312 online log string thread string: 'string'·ORA-00312 online log string thread string: 'string'·ORA-00312 online log string thread string: 'string'·ORA-00313 open failed for members of log group string of thread string·ORA-00314 log string of thread string, expected sequence# string doesn't match string·ORA-00353 log corruption near block string change string time string·ORA-00354 corrupt redo log block header·ORA-00376 file string cannot be read at this time·ORA-00376 file string cannot be read at this time·ORA-00376 file string cannot be read at this timeORA-00501~ORA-00600·ORA-00569: Failed to acquire global enqueue·ORA-00600 internal error code·ORA-00600 internal error code·ORA-00600 internal error code·ORA-00600 internal error codeORA-00901~ORA-01000·ORA-00903 invalid table name·ORA-00904 invalid column name·ORA-00904 invalid column name·ORA-00942 table or view does not exist·ORA-00980 synonym translation is no longer valid·ORA-01000 maximum open cursors exceededORA-01101~ORA-01200·ORA-01102 cannot mount database in EXCLUSIVE mode·ORA-01102 cannot mount database in EXCLUSIVE mode·ORA-01110 database already mounted·ORA-01110 database already mounted·ORA-01110 database already mounted·ORA-01100 database already mounted·ORA-01100 database already mounted·ORA-01113 file string needs media recovery·ORA-01113 file string needs media recovery·ORA-01115 IO error reading block from file string (block # string)·ORA-01122 database file string failed verification check·ORA-01122 database file string failed verification check·ORA-01122 database file string failed verification check·ORA-01122 database file string failed verification check·ORA-01144 File size (string blocks) exceeds maximum of string blocks·ORA-01149 cannot shutdown - file string has online backup set·ORA-01152 file 1 was not restored from a sufficiently old backup·ORA-01157 cannot identify/lock data file string - see DBWR trace file·ORA-01157 cannot identify/lock data file string - see DBWR trace file·ORA-01172 recovery of thread string stuck at block string of file string·ORA-01180 can not create datafile 1·ORA-01194 file string needs more recovery to be consistent·ORA-01200 actual file size of string is smaller than correct size of string blocksORA-01501~ORA-01600·ORA-01536 space quota exceeded for tablespace 'string'·ORA-01548 active rollback segment 'string' found, terminate dropping tablespace·ORA-01552 cannot use system rollback segment for non-system tablespace 'string'·ORA-01555 snapshot too old: rollback segment number string with name "string" too small·ORA-01555 snapshot too old: rollback segment number string with name "string" too small·ORA-01555 snapshot too old: rollback segment number string with name "string" too small·ORA-01555 snapshot too old: rollback segment number string with name "string" too small·ORA-01565 error in identifying file 'string'·ORA-01565 error in identifying file 'string'·ORA-01578 ORACLE data block corrupted (file # string, block # string)·ORA-01578 ORACLE data block corrupted (file # string, block # string)·ORA-01580 error creating control backup file string·ORA-01589 must use RESETLOGS or NORESETLOGS option for database open·ORA-01591 lock held by in-doubt distributed transaction stringORA-01701~ORA-01800·ORA-01722 invalid number·ORA-01722 invalid number·ORA-01775 looping chain of synonyms·ORA-01779 cannot modify a column which maps to a non key-preserved table·ORA-01790 expression must have same datatype as corresponding expressionORA-01901~ORA-02000·ORA-01925 maximum of string enabled roles exceeded·ORA-01940 cannot drop a user that is currently connectedORA-03101~ORA-03200·ORA-03113 end-of-file on communication channel·ORA-03113 end-of-file on communication channel·ORA-03113 end-of-file on communication channel·ORA-03136 inbound connection timed out·ORA-03136 inbound connection timed out·ORA-03137 TTC protocol internal errorORA-06501~ORA-06600·ORA-06502 PL/SQL: numeric or value errorstring·ORA-06502 PL/SQL: numeric or value errorstring·ORA-06512 at stringline string·ORA-06512 at stringline string·ORA-06521 PL/SQL: Error mapping function·ORA-06544 PL/SQL: internal error·ORA-06544 PL/SQL: internal error·ORA-06552: PL/SQL: Compilation unit analysis terminated·ORA-06553: PLS-553: character set name is not recognizedORA-08101~ORA-08200·ORA-08104 this index object 66144 is being online built or rebuilt·ORA-08177 can't serialze accessORA-09901~ORA-10000·ORA-09925 Unable to create audit trail file·ORA-09968 scumnt: unable to lock fileORA-12101~ORA-12200·ORA-12154: TNS:could not resolve the connect identifier specified·ORA-12154: TNS:could not resolve the connect identifier specified·ORA-12154: TNS:could not resolve the connect identifier specified·ORA-12162 TNS:net service name is incorrectly specified·ORA-12162 TNS:net service name is incorrectly specifiedORA-12501~ORA-12600·ORA-12505 TNS:listener does not currently know of SID given in connect descriptor·ORA-12514 TNS:listener does not currently know of service requested in connect descriptor·ORA-12514 TNS:listener does not currently know of service requested in connect descriptor·ORA-12514 TNS:listener does not currently know of service requested in connect descriptor·ORA-12516 TNS:listener could not find available handler with matching protocol·ORA-12516 TNS:listener could not find available handler with matching protocol·ORA-12516 TNS:listener could not find available handler with matching protocol·ORA-12519 TNS:no appropriate service handler found·ORA-12520 TNS:listener could not find available handler for requested type of server·ORA-12528: TNS:listener: all appropriate instances are blocking new connections·ORA-12528: TNS:listener: all appropriate instances are blocking new connections·ORA-12537 TNS:connection closed·ORA-12537 TNS:connection closed·ORA-12541 TNS:没有监听器·ORA-12542 TNS:address already in use·ORA-12545 TNS:name lookup failure·ORA-12545 TNS:name lookup failure·ORA-12547 TNS:lost contact·ORA-12547 TNS:lost contact·ORA-12560 TNS:protocol adapter error·ORA-12564 TNS:connection refused·ORA-12571 TNS:Packet writer failureORA-13501~ORA-13600·ORA-13541 system moving window baseline size (691200) greater than retentionORA-14501~ORA-14600·ORA-14552 cannot perform a DDL, commit or rollback inside a query or DMLORA-15101~ORA-15200·ORA-15173 entry 'orac' does not exist in directory '/'ORA-16101~ORA-16200·ORA-16198 timeout incurred on internal channel during remote archivalORA-19501~ORA-19600·ORA-19573 cannot obtain string enqueue for datafile stringORA-19901~ORA-20000·ORA-19909 datafile 9 belongs to an orphan incarnation·ORA-19957 file /oradata/anny/system01.dbf blocksize 8192 does not match set blocksize of 16384·ORA-20000 Content of the tablespace specified is not permanent or tablespace name is invalid·ORA-20000 Content of the tablespace specified is not permanent or tablespace name is invalid·ORA-20000 Content of the tablespace specified is not permanent or tablespace name is invalidORA-21701~ORA-21800·ORA-21779 duration not activeORA-25101~ORA-25200·ORA-25153 Temporary Tablespace is Empty·ORA-25153 Temporary Tablespace is EmptyORA-27101~ORA-27200·ORA-27101 shared memory realm does not exist·ORA-27101 shared memory realm does not exist·ORA-27102 out of memory·ORA-27102 out of memory·ORA-27125 unable to create shared memory segmentORA-27301~ORA-27400·ORA-27302 failure occurred at: stringORA-27501~ORA-27600·ORA-27504 IPC error querying network address of a portORA-27901~ORA-28000·ORA-28000 the account is lockedORA-29301~ORA-29400·ORA-29368 consumer group string does not existORA-29701~ORA-29800·ORA-29701 unable to connect to Cluster Manager·ORA-29701 unable to connect to Cluster Manager·ORA-29740 evicted by member 0, group incarnationORA-29901~ORA-30000·ORA-29913 error in executing ODCIEXTTABLEOPEN calloutORA-32001~ORA-32100·ORA-32001 write to SPFILE requested but no SPFILE specified at startup·ORA-32004 obsolete and/or deprecated parameter(s) specified·ORA-32004 obsolete and/or deprecated parameter(s) specifiedORA-39101~ORA-39200·ORA-39125 Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS while calling·ORA-39125 Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS while calling·ORA-39126 Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA·ORA-39149 cannot link privileged user to non-privileged userORA-39001~ORA-39100·ORA-39002 invalid operation·ORA-39014 One or more workers have prematurely exited·ORA-39070 Unable to open the log file·ORA-39095 Dump file space has been exhausted: Unable to allocate string bytes·ORA-39097 Data Pump job encountered unexpected error -1422ORA-44001~ORA-44100·ORA-44003 in the alert log