cancel
Showing results for 
Search instead for 
Did you mean: 

ORA 27072: File I/O Error

SOLVED
Go to solution
prakasse
Advisor

ORA 27072: File I/O Error

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.
4 REPLIES
smatador
Honored Contributor

Re: ORA 27072: File I/O Error

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
Advisor

Re: ORA 27072: File I/O Error

Hi,

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

Thanks,
Senthil.
smatador
Honored Contributor
Solution

Re: ORA 27072: File I/O Error

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
Advisor

Re: ORA 27072: File I/O Error

Hi smatador,

Thanks a ton. the patch solved the issue.

Thanks,
Senthil