ORA-01114: IO error writing block to file (block #)
Following error arose, check data tablespace, there's sufficent free space. There's high probability that this error is due to database unix box disk space. We know the nature of oracle temp tablespace that when space added to temp space it does not allocate physical space, take only when required . The temp mount point is of 15Gb and the tempfile created is of 40GB, So as 15GB size usage reached it throws an error of No space left on device . I guess if the temp space is small, oracle will try to overwrite the tempspace, if it's big, it will access the full space allocated initially.
when reach 15 if allocated 40, then oracle try to access more space and fail if no space left, but if alocated 15 and have only 15, then it will rewrite. delete the tempfiles, and recreate the tempfiles, allocating 15G to temp tablespace. Rerun application, it's fine this time.
[@more@]03 Jun 09 13:54:17 FEED ERROR Error occurred running feed : java.sql.SQLException: ORA-01114: IO error writing block to file (block # )ORA-06512: at line 1
ORA-06512: at "OWNER.P_EXP", line 223
ORA-06512: at "OWNER.P_FED", line 2804
ORA-01114: IO error writing block to file 202 (block # 246597)
ORA-27063: number of bytes read/written is incorrect
SVR4 Error: 28: No space left on device
Additional information: -1
Additional information: 114688
ORA-01114: IO error writing block to file 202 (block # 246597)
ORA-27063: number of bytes read/written is incorrect
SVR4 Error: 28: No space left on device
Additional information: -1
Additional information: 114688
ORA-06512: at line 1
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/14377/viewspace-1022776/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 452 Error writing file: A file cannot be larger than the value set by ulimit.ErrorMIT
- error:unable to get logical block size for spfileErrorBloC
- ORA-600 [kdBlkCheckError] [file#] [block#] [code]ErrorBloC
- ORA-27046: file size is not a multiple of logical block sizeBloC
- Block學習①--block的本質BloC
- Non critical error ORA-48913 caught while writing to trace fileErrorWhile
- oracle block phisical address to block#OracleBloC
- cannot use '/dev/da1': must be a block device or regular filedevBloC
- iOS block巢狀block中weakify的使用iOSBloC巢狀
- Unused Block Compression和Null Block CompressionBloCNull
- 深入理解Block之Block的型別BloC型別
- Block學習②--block的變數捕獲BloC變數
- 通過rowid查詢行所在的block,FILE OBJECTBloCObject
- block沒那麼難(一):block的實現BloC
- iOS Block探究iOSBloC
- iOS--BlockiOSBloC
- block詳解BloC
- oracle dump blockOracleBloC
- oracle block type!OracleBloC
- ORACLE BLOCK DUMPOracleBloC
- oracle hot blockOracleBloC
- block corruption typeBloC
- Ruby Block 理解BloC
- 物理備份是以block來區別邏輯備份的(os block或oracle block) ?BloCOracle
- Block學習⑤--block對物件變數的捕獲BloC物件變數
- gc current block pin time gc current block flush time 疑惑GCBloC
- db_block_checksum & db_block_checking 的區別BloC
- 亞馬遜雲科技推出Amazon EBS io2 Block Express儲存卷亞馬遜BloCExpress
- block_dump觀察Linux IO寫入的具體檔案BloCLinux
- Block的型別BloC型別
- block實現原理BloC
- Oracle Log Block SizeOracleBloC
- Block使用場景BloC
- iOS __weak、__block使用iOSBloC
- Oracle Find block in ASMOracleBloCASM
- 深入淺出 blockBloC
- block深入淺出BloC
- ios之Block研究iOSBloC