Hauke
asked on
ORA-27072: skgfdisp: I/O error
Hi,
a friend of mine has a problem.
ORACLE V8.1.5.0.0 - Production vsnsta=0
vsnsql=d vsnxtr=3
Windows NT V4.0, OS V5.101, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.5.0.0.
....
Errors in file d:\Oracle\admin\orcl\bdump \orclLGWR. TRC:
ORA-01110: data file 9: 'E:\ORACLE\ORADATA\ORCL\DF _PER_LARGE 1'
ORA-01114: IO error writing block to file 9 (block # 1)
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 5) Access is denied.
Drive E: is a NTFS partition and the size of the datafile should be ~20 GB.
a friend of mine has a problem.
ORACLE V8.1.5.0.0 - Production vsnsta=0
vsnsql=d vsnxtr=3
Windows NT V4.0, OS V5.101, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.5.0.0.
....
Errors in file d:\Oracle\admin\orcl\bdump
ORA-01110: data file 9: 'E:\ORACLE\ORADATA\ORCL\DF
ORA-01114: IO error writing block to file 9 (block # 1)
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 5) Access is denied.
Drive E: is a NTFS partition and the size of the datafile should be ~20 GB.
I would suggest first checking to make sure that there are not any hardware errors on the disk level. Next, check to make sure that there are no logical filesystem errors. Check to see that it is not a space issue and also make sure that the datafile is not corrupt. If all this checks out, it may be a security issue.
Good luck
Good luck
Is it possible drive E: to be off-line or sowhow to be not visible at OS level?
The error :
ORA-01114 IO error writing block to file string (block # string)
Cause: The device on which the file resides is probably off line.
Action: Restore access to the device, then retry the operation.
The error :
ORA-01114 IO error writing block to file string (block # string)
Cause: The device on which the file resides is probably off line.
Action: Restore access to the device, then retry the operation.
Hi,
This is for sure a disk space problem
Once the .trc files get generated due to errors it fill up the space very quickly.Please remove the unnessacary files from the location of bdump (defined in parameter file) and start the instance again.This should work
Thanx
Bala
This is for sure a disk space problem
Once the .trc files get generated due to errors it fill up the space very quickly.Please remove the unnessacary files from the location of bdump (defined in parameter file) and start the instance again.This should work
Thanx
Bala
Question has been LOCKED with a proposed answer for more than one year. Please accept the Proposed Answer if it served you, or reject it and comment as to what else you need.
EXPERT INPUT WELCOME AND APPRECIATED FOR FINAL OUTCOME IF ASKER DOES NOT HANDLE THIS QUESTION WITHIN ONE WEEK, since we will then be closing this.
Moondancer - EE Moderator
EXPERT INPUT WELCOME AND APPRECIATED FOR FINAL OUTCOME IF ASKER DOES NOT HANDLE THIS QUESTION WITHIN ONE WEEK, since we will then be closing this.
Moondancer - EE Moderator
Lacking timely response from Hauke or contributing experts, but seeing that there is useful information here, I recommend:
Save as PAQ -- No Refund.
DanRollins -- EE database cleanup volunteer
Save as PAQ -- No Refund.
DanRollins -- EE database cleanup volunteer
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Cheers
Srikant