Additional information: 253952
ORA-01114: IO error writing block to file 201 (block # 36167)
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 253952
ORA-01114: IO error writing block to file 201 (block # 36105)
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 253952
Wed Aug 15 22:21:16 2007
MMNL absent for 1203 secs; Foregrounds taking over
Wed Aug 15 22:22:12 2007
Errors in file /oracle/ora102DB/OraHome_2/admin/LIVE/bdump/live_j001_160
1688.trc:
ORA-01114: IO error writing block to file 201 (block # 36128)
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 196608
We are facing this error every once a month, the problem is solved by making free space in this file system.
Additionally here the contents of the trace file,
/oracle/ora102DB/OraHome_2/admin/LIVE/bdump/live_j001_1601688.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/ora102DB/OraHome_2
System name: AIX
Node name: appserv
Release: 2
Version: 5
Machine: 005B6D8A4C00
Instance name: LIVE
Redo thread mounted by this instance: 1
Oracle process number: 21
Unix process pid: 1601688, image: oracle@APPSERV (J001)
*** 2007-08-15 22:16:02.173
*** ACTION NAME:(GATHER_STATS_JOB) 2007-08-15 22:16:02.093
*** MODULE NAME:(DBMS_SCHEDULER) 2007-08-15 22:16:02.093
*** SERVICE NAME:(SYS$USERS) 2007-08-15 22:16:02.093
*** SESSION ID:(133.39) 2007-08-15 22:16:02.093
This happens as GATHER_STATS_JOB executes but i don't understand why?
Has anyone faced a similar problem?
Thank you
Adith