Home » RDBMS Server » Server Administration » ORA-27072: File I/O error (Oracle 11gR1, RHE Linux)
ORA-27072: File I/O error [message #476408] Thu, 23 September 2010 02:40 Go to next message
sferreira72
Messages: 8
Registered: September 2010
Junior Member
Our database seems to work ok (we can stop, start, query, populate it) but when we try to alter a tablespace we get the following scary error message.

Disk space is ok. Server has been rebooted without problem. Help would appreciate!

---
ALTER DATABASE DATAFILE '/home/oracle/app/oracle/product/11.1.0/db_1/dbs/sde.dbf'
RESIZE 4614912K
Error at line 2
ORA-01237: cannot extend datafile 5
ORA-01110: data file 5: '/home/oracle/app/oracle/product/11.1.0/db_1/dbs/sde.dbf'
ORA-19502: write error on file "/home/oracle/app/oracle/product/11.1.0/db_1/dbs/sde.dbf", block number 454912 (block size=8192)
ORA-27072: File I/O error
Additional information: 4
Additional information: 454912
Additional information: 962560
Re: ORA-27072: File I/O error [message #476415 is a reply to message #476408] Thu, 23 September 2010 03:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Most likely there is no space available on your file system.

Regards
Michel
Re: ORA-27072: File I/O error [message #476417 is a reply to message #476415] Thu, 23 September 2010 03:47 Go to previous message
sferreira72
Messages: 8
Registered: September 2010
Junior Member
I was pretty sure that was not the issue. I rechecked and... @#$!! you are right! Problem solved. Thanks.
Previous Topic: Instance name on imaged server
Next Topic: Splitting partitions
Goto Forum:
  


Current Time: Sun Dec 01 16:27:06 CST 2024