联系:手机/微信(+86 17813235971) QQ(107644445)
标题:/u01空间100%导致数据库报ORA-01114 ORA-29701
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
通过分析发现磁盘/u01分区使用100%
sqlplus / as sysdba 无法登陆
清理trace,释放/u01空间之后,数据库恢复正常,mos中关于ORA-01114错误描述
APPLIES TO: BI Publisher (formerly XML Publisher) - Version 11.1.1.7.x and later Information in this document applies to any platform. SYMPTOMS While generating reports the following error occurred. oracle.xdo.XDOException: java.sql.SQLException: ORA-01114: IO error writing block to file (block # ) ORA-01114: IO error writing block to file 201 (block # 755561) ORA-27072: File I/O error Additional information: 4 Additional information: 755561 Additional information: 36864 CHANGES CAUSE The issue is caused due to DB not having enough space. SOLUTION Cleared space in DB and the report worked fine.