ORA 27072: File I/O Error

[prakasse]

Hi,

We are using HP-UX 11.31 Integrity server with Vxfsd 5.0 and Oracle 10g.

We tried to import data in to the DB using oracle enterprise manager, but getting the following error message while tried to increase table space also the DB auto extent fails to extent with the same error.

-------------------------------------
ORA-01237: cannot extend datafile 6.
ORA-01110 data file 6
/data/data1.dbf
ORA-19502: write error on file
/data/data1.dbf, block no 641, blocksize 8192
ORA-27072: File I/O Error
HPUX-ia64 Error 22: Invalid argument
Additional information: 4
Additional information: 641
Additional information: -1
-----------------------------------

Kindly assist us to resolve this problem. Right solution will get full 10 points and other replied too will be awarded good points.

Thanks,
Senthil.

[smatador]

The resize operation will fail at this point.
Hi,
Check this issue with your dba, the metalink doc : "How to Resize a Datafile" say

"If you try to resize a datafile larger than can be created, you will also get an error. For instance, if trying to create a file of 2 GB, without having 2 GB of available disk space the following errors will be returned:

ORA-01237: cannot extend datafile
ORA-01110: data file : ''
ORA-19502: write error on file "", blockno (blocksize=) ORA-27072: File I/O error

Hope it helps

[prakasse]

Hi,

I think there is enough disk place.
Filesystem kbytes used avail %used Mounted on
/data 733986816 75814374 617037157 11% /data

Thanks,
Senthil.

[smatador · Accepted solution]

Well, you could also try to patch vxfs with PHKL_39131 [most recent] , 11.31 VRTS 5.0 GARP2 VRTSvxfs Kernel Patch. The release notes of PHKL_38574 [specified] talk about HPUX-ia64 Error: 22, but not for extending dbf...
On metalink, oracle discuss also about this patch on subject When Importing Ora-27091 Ora-27072 using HP-UX 11.

[prakasse]

Hi smatador,

Thanks a ton. the patch solved the issue.

Thanks,
Senthil