OraFAQ Forum: Server Administration » unable to write to file

Home » RDBMS Server » Server Administration » unable to write to file (Oracle,9i Release 2,Windows Server 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

unable to write to file [message #308620]

Tue, 25 March 2008 01:28

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.

Report message to a moderator

Re: unable to write to file [message #308621 is a reply to message #308620]

Tue, 25 March 2008 01:33

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.

Report message to a moderator

Re: unable to write to file [message #308622 is a reply to message #308620]

Tue, 25 March 2008 01:39

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.

Report message to a moderator

Re: unable to write to file [message #308624 is a reply to message #308622]

Tue, 25 March 2008 01:42

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.

Report message to a moderator

Re: unable to write to file [message #308631 is a reply to message #308624]

Tue, 25 March 2008 01:56

Michel Cadot
Messages: 68684
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

Report message to a moderator

Re: unable to write to file [message #308635 is a reply to message #308631]

Tue, 25 March 2008 02:01

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.

Report message to a moderator

Re: unable to write to file [message #308638 is a reply to message #308635]

Tue, 25 March 2008 02:09

Michel Cadot
Messages: 68684
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

Report message to a moderator

Re: unable to write to file [message #308739 is a reply to message #308638]

Tue, 25 March 2008 05:46

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.

Report message to a moderator

Re: unable to write to file [message #308754 is a reply to message #308739]

Tue, 25 March 2008 06:28

Michel Cadot
Messages: 68684
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

Report message to a moderator

Previous Topic:	Scheduling
Next Topic:	Re-organisation of datafiles

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 19:31:46 CDT 2024