Oracle Blocks Error Codes

Oracle manages the storage space in the datafiles of a database in units called data blocks. A data block is the smallest unit of data used by a database. Default size 8k.

ORA-00058 DB_BLOCK_SIZE must be string to mount this database (not string)
ORA-00104 deadlock detected; all public servers blocked waiting for resources
ORA-00204 error in reading (block string, # blocks string) of controlfile
ORA-00206 error in writing (block string, # blocks string) of controlfile
ORA-00209 control file blocksize mismatch, check alert log for more info
ORA-00212 block size string below minimum required size of string bytes
ORA-00218 block size string of controlfile does not match DB_BLOCK_SIZE (string)
ORA-00227 corrupt block detected in controlfile: (block string, # blocks string)
ORA-00300 illegal redo log block size string specified – exceeds limit of string
ORA-00333 redo log read error block string count string
ORA-00336 log file size string blocks is less than minimum string blocks
ORA-00345 redo log write error block string count string
ORA-00347 log string of thread string, expected block size string doesn’t match string
ORA-00349 failure obtaining block size for ‘string’
ORA-00353 log corruption near block string change string time string
ORA-00354 corrupt redo log block header
ORA-00368 checksum error in redo log block
ORA-00374 parameter db_block_size = string invalid; must be a multiple of string in the range [string..string]
ORA-00375 unable to get default db_block_size
ORA-00379 no free buffers available in buffer pool string for block size stringK
ORA-00380 cannot specify db_numberk_cache_size since numberK is the standard block size
ORA-00382 string not a valid block size, valid range [string..string]
ORA-00383 DEFAULT cache for blocksize string cannot be reduced to zero
ORA-00397 lost write detected for file string, block string
ORA-00607 Internal error occurred while making a change to a data block
ORA-01057 invalid or ambiguous block.field reference in user exit
ORA-01114 IO error writing block to file string (block # string)
ORA-01115 IO error reading block from file string (block # string)
ORA-01117 adding file ‘string’ with illegal block size: string; limit is string
ORA-01136 specified size of file string (string blocks) is less than original size of string blocks
ORA-01144 File size (string blocks) exceeds maximum of string blocks
ORA-01151 use media recovery to recover block, restore backup if needed
ORA-01162 block size string in file header does not match configured block sizes
ORA-01163 SIZE clause indicates string (blocks), but should match header string
ORA-01168 physical block size string does not match size string of other members
ORA-01172 recovery of thread string stuck at block string of file string
ORA-01188 Block size string in header does not match physical block size string
ORA-01200 actual file size of string is smaller than correct size of string blocks
ORA-01498 block check failure – see trace file
ORA-01551 extended rollback segment, pinned blocks released
ORA-01557 rollback segment extents must be at least string blocks
ORA-01578 ORACLE data block corrupted (file # string, block # string)
ORA-01583 unable to get block size of controlfile to be backed up
ORA-01755 Must specify an extent number or block number
ORA-01762 vopdrv: view query block not in FROM
ORA-01787 only one clause allowed per query block
ORA-01788 CONNECT BY clause required in this query block
ORA-01789 query block has incorrect number of result columns
ORA-01963 Must specify a block number
ORA-02241 must of form EXTENTS (FILE n BLOCK n SIZE n, …)
ORA-02454 Number of hash keys per block (string) exceeds maximum of string
ORA-02475 maximum cluster chain block count of string has been exceeded
ORA-02492 missing required file block increment size in NEXT clause
ORA-02770 Total number of blocks is invalid
ORA-02818 Less than the number of blocks requested was read in
ORA-02820 Unable to write the requested number of blocks
ORA-02821 Unable to read the requested number of blocks.
ORA-02822 Invalid block offset
ORA-02826 Illegal block size
ORA-02839 Sync of blocks to disk failed.
ORA-03123 operation would block
ORA-03126 network driver does not support non-blocking operations
ORA-03128 connection is in blocking mode
ORA-03206 maximum file size of (string) blocks in AUTOEXTEND clause is out of range
ORA-03209 DBMS_ADMIN_PACKAGE invalid file/block specification
ORA-03221 temporary tablespaces and temporary segments must have standard block size
ORA-03230 segment only contains string blocks of unused space above high water mark
ORA-03246 Invalid block number specified
ORA-03247 Invalid block number specified
ORA-03249 Uniform size for auto segment space managed tablespace should have atleast string blocks.
ORA-06431 ssaio: Invalid Block number
ORA-06433 ssaio: LSEEK error, unable to seek to requested block.
ORA-06434 ssaio: read error, unable to read requested block from database file.
ORA-06435 ssaio: write error, unable to write requested block to database file.
ORA-07245 sfccf: unable to lseek and write the last block.
ORA-07247 sfrfb: read error, unable to read requested block from database file.
ORA-07248 sfwfb: write error, unable to write database block.
ORA-07620 smscre: illegal database block size
ORA-07621 smscre: illegal redo block size
ORA-08117 Index Organized Table operation released its block pin
ORA-10560 block type ‘string’
ORA-10561 block type ‘string’, data object# string
ORA-10562 Error occurred while applying redo to data block (file# string, block# string)
ORA-10563 Test recovery had to corrupt data block (file# string, block# string) in order to proceed
ORA-10567 Redo is inconsistent with data block (file# string, block# string)
ORA-10574 Test recovery did not corrupt any data block
ORA-10586 Test recovery had to corrupt 1 data block in order to proceed
ORA-10589 Test recovery had to corrupt string data blocks in order to proceed
ORA-10621 data block does not belong to the segment
ORA-10651 incorrect file number block number specified
ORA-12829 Deadlock – itls occupied by siblings at block string of file string
ORA-14296 Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
ORA-14297 Index block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
ORA-14298 LOB column block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
ORA-14519 Conflicting tablespace blocksizes for string string: Tablespace string block size string [string] conflicts with previously specified/implied tablespace string block size string [string]
ORA-14520 Tablespace string block size [string] does not match existing object block size [string]
ORA-14521 Default tablespace string block size [string] for string string does not match existing string block size [string]
ORA-14522 Partition-level default tablespace string block size [string] for string string does not match existing string block size [string]
ORA-14523 Cannot co-locate [sub]partition of string string with table [sub]partition because string block size [string] does not match table block size [string]
ORA-16059 Log file is empty or invalid next available block
ORA-16167 LGWR network server could not switch to non-blocking mode
ORA-16168 LGWR network server could not switch to blocking mode
ORA-17501 logical block size string is invalid
ORA-17505 ksfdrsz: string Failed to resize file to size number blocks
ORA-17507 I/O request size string is not a multiple of logical block size
ORA-17509 Attempt to do i/o beyond block1 offset
ORA-19500 device block size string is invalid
ORA-19501 read error on file “string”, blockno string (blocksize=string)
ORA-19502 write error on file “string”, blockno string (blocksize=string)
ORA-19510 failed to set size of string blocks for file “string” (blocksize=string)
ORA-19564 error occurred writing string bytes at block number string
ORA-19566 exceeded limit of string corrupt blocks for file string
ORA-19575 expected string blocks in file string, found string
ORA-19587 error occurred reading string bytes at block number string
ORA-19597 file string blocksize string does not match set blocksize of string
ORA-19599 block number string is corrupt in string string
ORA-19610 directory block string is corrupt
ORA-19680 some blocks not recovered. See trace file for details
ORA-19681 block media recovery on control file not possible
ORA-19683 real and backup blocksize of file string are unequal
ORA-19684 block media recovery failed because database is suspended
ORA-19707 invalid record block number – string
ORA-25115 duplicate BLOCK option specification
ORA-25116 invalid block number specified in the DUMP DATAFILE/TEMPFILE command
ORA-25117 MIN/MAX/Block Number expected
ORA-25157 Specified block size string is not valid
ORA-26040 Data block was loaded using the NOLOGGING option
ORA-27004 invalid blocksize specified
ORA-27018 BLKSIZE is not a multiple of the minimum physical block size
ORA-27035 logical block size is invalid
ORA-27044 unable to write the header block of file
ORA-27046 file size is not a multiple of logical block size
ORA-27047 unable to read the header block of file
ORA-27049 unable to seek to and read the last block
ORA-27053 skgfifi: blocksize in file header not a multiple of logical block size
ORA-28671 UPDATE BLOCK REFERENCES may not be used on a partitioned index as a whole
ORA-28672 UPDATE BLOCK REFERENCES may not be used on a global index
ORA-29337 tablespace ‘string’ has a non-standard block size (string)
ORA-29339 tablespace block size string does not match configured block sizes
RMAN-03031: this option of set command needs to be used inside a run block
RMAN-03032: this option of set command needs to be used outside of a run block
RMAN-05009: Block Media Recovery requires Enterprise Edition
RMAN-05054: recover block operand string cannot be used to recover datafile
RMAN-05055: recover datafile operand string cannot be used to recover block
RMAN-05060: block specifier must be specified to recover block
RMAN-06468: Invalid Data Block Address: number
RMAN-06508: MAXSETSIZE string KBYTES should be greater than block size string bytes
RMAN-06914: BLOCK string must be greater or equal to BLOCK string
RMAN-06947: searching flashback logs for block images until SCN string
RMAN-06948: searching flashback logs for block images
RMAN-06949: finished flashback log search, restored string blocks
RMAN-06957: finished standby search, restored string blocks
RMAN-06967: finished primary search, recovered string blocks
RMAN-08106: channel string: restoring block(s)
RMAN-08108: channel string: specifying block(s) to restore from backup set
RMAN-08109: channel string: restored block(s) from backup piece string
RMAN-08111: some blocks not recovered: See trace file for details
RMAN-08135: some corrupt blocks found during conversion of file string
RMAN-08183: channel string: block restore complete, elapsed time: string
RMAN-08190: validate found one or more corrupt blocks
RMAN-08525: backing up blocks string through string
RMAN-08532: channel string: restoring block(s) from datafile copy string
RMAN-08533: restoring blocks of datafile string
RMAN-08616: validating blocks string through string
SQL*Loader-00404: Column string present more than once in string’s INTO TABLE block.
SQL*Loader-00955: Error calling col array build, block formatter
EXP-00027: failed to calculate ORACLE block size
EXP-00034: error on rowid: file# number block# number slot# number
IMP-00091: Above error occurred on the following function and object: string. Remaining PL/SQL blocks for this object will be skipped.
TNS-00506: Operation would block
TNS-12527: TNS:listener: all instances are in restricted mode or blocking new connections
TNS-12528: TNS:listener: all appropriate instances are blocking new connections
TNS-12536: TNS:operation would block
PLS-00214: BEGIN…END block nesting is too deep
PLS-00370: OTHERS handler must be last among the exception handlers of a block
PLS-00483: exception ‘string’ may appear in at most one exception handler in this block
MySQL ERROR 1129 (HY000): Host ‘%s’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’
MySQL ERROR 1413 (42000): Duplicate handler declared in the same block
Windows XP/7/8/10 – The storage control blocks were destroyed
Windows XP/7/8/10 – The storage control block address is invalid
Windows XP/7/8/10 – The file type being saved or retrieved has been blocked
Windows XP/7/8/10 – Used to indicate that an operation cannot continue without blocking for I/O
Windows XP/7/8/10 – An operation is blocked waiting for an oplock
Windows XP/7/8/10 – When accessing a new tape of a multivolume partition, the current block size is incorrect
Windows XP/7/8/10 – This program is blocked by group policy. For more information, contact your system administrator
Windows XP/7/8/10 – This driver has been blocked from loadin
Windows XP/7/8/10 – The requested file operation failed because the storage policy blocks that type of file. For more information, contact your system administrator
Windows XP/7/8/10 – The printer driver is not compatible with a policy enabled on your computer that blocks NT 4.0 drivers
Windows XP/7/8/10 – Remote connections to the Print Spooler are blocked by a policy set on your machine
Windows XP/7/8/10 – The WMI data block or event notification has already been enabled
Windows XP/7/8/10 – The WMI data block is no longer available
Windows XP/7/8/10 – The WMI data block or event notification has already been disabled
Windows XP/7/8/10 – The WMI data item or data block is read only
Windows XP/7/8/10 – The WMI data item or data block could not be changed
Windows XP/7/8/10 – The requested operation was blocked by policy. For more information, contact your system administrator
Windows XP/7/8/10 – Log service encountered a log sector with invalid block parity
Windows XP/7/8/10 – Log service encountered a partial or incomplete log block
Windows XP/7/8/10 – Log service encountered an invalid log block version
Windows XP/7/8/10 – Log service encountered an invalid log block
Windows XP/7/8/10 – The kernel transaction manager had to abort or forget the transaction because it blocked forward progress
Windows XP/7/8/10 – A blocking operation was interrupted by a call to WSACancelBlockingCall
Windows XP/7/8/10 – A non-blocking socket operation could not be completed immediately
Windows XP/7/8/10 – A blocking operation is currently executing
Windows XP/7/8/10 – An operation was attempted on a non-blocking socket that already had an operation in progress
Windows XP/7/8/10 – IPsec DoS Protection matched an explicit block rule
NZE-28861: SSL connection would block
NZE-29241: a buffer block needs more space but its length is fixed
DBV-00200: Block, DBA number, already marked corrupt
DBV-00201: Block, DBA number, marked corrupt for invalid redo application
NID-00138: Block verification failed for datafile string (number)
DIA-48104: read mismatch on blocks requested and returned, [string], [string]
DIA-48105: write mismatch on blocks requested and returned, [string], [string]
DIA-48122: error with opening the ADR block file [string] [string]
DIA-48166: error with opening ADR block file because file does not exist [string] [string]
DIA-48178: error encountered while reading an ADR block file during ADR initialization [string]
QSM-01006: query rewrite disabled for this query block
QSM-01059: HAVING clause in the query block is malformed
QSM-01130: Multi MV rewrite not allowed if at least one query block has no MVs
QSM-02171: the materialized view has a join operation in the outer UNION block
QSM-02175: some query block in UNION ALL MV is not fast refreshable
QSM-02203: PCT FAST REFRESH is not possible if query has set operand query blocks
KFNDG-00304: unable to access heartbeat block of the device string:string
KFNDG-00402: ASM metadata block size conflict (number, number)