Home » RDBMS Server » Server Administration » unable to write to file (Oracle,9i Release 2,Windows Server 2003)
unable to write to file [message #308620] Tue, 25 March 2008 01:28 Go to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi,

My instance is getting shutdown frequently:) Please find the portion of alert log file below

Mon Mar 24 21:16:04 2008
KCF: write/open error block=0x1a6 online=1
     file=2 E:\ORACLE\ORADATA\ABC\UNDOTBS01.DBF
     error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.'
Mon Mar 24 21:16:04 2008
Errors in file e:\oracle\admin\abc\bdump\abc_dbw0_5412.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 2 (block # 422)
ORA-01110: data file 2: 'E:\ORACLE\ORADATA\ABC\UNDOTBS01.DBF'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.

DBW0: terminating instance due to error 1242
Mon Mar 24 21:16:04 2008
Errors in file e:\oracle\admin\abc\bdump\abc_pmon_2956.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Mon Mar 24 21:16:04 2008
Errors in file e:\oracle\admin\abc\bdump\abc_lgwr_6108.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Mon Mar 24 21:16:04 2008
Errors in file e:\oracle\admin\abc\bdump\abc_ckpt_2268.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Mon Mar 24 21:16:04 2008
Errors in file e:\oracle\admin\abc\bdump\abc_reco_1384.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Mon Mar 24 21:16:04 2008
Errors in file e:\oracle\admin\abc\bdump\abc_smon_1244.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Instance terminated by DBW0, pid = 5412
Dump file e:\oracle\admin\abc\bdump\alert_abc.log


Kindly help me in this issue.

Thanks.
Re: unable to write to file [message #308621 is a reply to message #308620] Tue, 25 March 2008 01:33 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
ORA-01114: IO error writing block to file 2 (block # 422)
ORA-01110: data file 2: 'E:\ORACLE\ORADATA\ABC\UNDOTBS01.DBF'


Check this datafile. Ensure that it exists and permission is set to write.
Re: unable to write to file [message #308622 is a reply to message #308620] Tue, 25 March 2008 01:39 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.


There may be another process/user/something that access this file. Check it.
Re: unable to write to file [message #308624 is a reply to message #308622] Tue, 25 March 2008 01:42 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi Arju,

Thanks for your prompt reply.
I have checked the file permission and it has got full control, So there won't be any problem in this.

Coming to accessing the object, kindly let me know how to check whether any other process locking/accessing this datafile/undo file?

One more information is when I restart the instance then everything works fine for 1 day then it got terminated due to this accessible problem.

Thanks.
Re: unable to write to file [message #308631 is a reply to message #308624] Tue, 25 March 2008 01:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Coming to accessing the object, kindly let me know how to check whether any other process locking/accessing this datafile/undo file?

OS backup?

Regards
Michel
Re: unable to write to file [message #308635 is a reply to message #308631] Tue, 25 March 2008 02:01 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi Michel,

You mean that some OS backup is happening parallely? Please eloborate this context if my understanding is wrong.

Thanks.
Re: unable to write to file [message #308638 is a reply to message #308635] Tue, 25 March 2008 02:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, this is what I meant.
It is an example of processes accessing in parallel with database instance (and this should be configure to not happen).

Regards
Michel
Re: unable to write to file [message #308739 is a reply to message #308638] Tue, 25 March 2008 05:46 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Thanks Michel,

I don't find any process/backup process accessing this database! Do you have any script which will check whether this datafile is being used by any processes?

thanks.
Re: unable to write to file [message #308754 is a reply to message #308739] Tue, 25 March 2008 06:28 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I have no script but search on sysinternals site you surely will find a tool that gives you that.

Regards
Michel
Previous Topic: Scheduling
Next Topic: Re-organisation of datafiles
Goto Forum:
  


Current Time: Sat Dec 03 13:46:28 CST 2016

Total time taken to generate the page: 0.07875 seconds