OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » File I/O error (11.2)

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

File I/O error [message #678632]

Mon, 23 December 2019 05:14

rmestre
Messages: 2
Registered: December 2019

Junior Member

Hi,

i need help understanding the reasons of the following error:

KCF: read, write or open error, block=0x2d71f3 online=1
file=1 '/oradata/databases/dbapss/temp01.dbf'
error=27072 txt: 'Additional information: 4
Additional information: 2978291
Additional information: 73728'
Encountered write error
DDE rules only execution for: ORA 1110
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----
Successfully dispatched
----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) -----
Executing ASYNC actions
----- END DDE Actions Dump (total 0 csec) -----
error 63999 detected in background process
ORA-63999: data file suffered media failure
ORA-01114: IO error writing block to file 201 (block # 2978291)
ORA-01110: data file 201: '/oradata/databases/dbapss/temp01.dbf'
ORA-27072: File I/O error
Additional information: 4
Additional information: 2978291
Additional information: 73728
kjzduptcctx: Notifying DIAG for crash event
----- Abridged Call Stack Trace -----
ksedsts()+465<-kjzdssdmp()+267<-kjzduptcctx()+232<-kjzdicrshnfy()+63<-ksuitm()+5570<-ksbrdp()+3507<-opirip()+623<-opidrv()+603 <-sou2o()+103<-opimai_real()+250<-ssthrdmain()+265<-main()+201<-__libc_start_main()+253
----- End of Abridged Call Stack Trace -----

This already happened two times in last two weeks, and i need to understand why is it happening.

I would appreciate your help.

Thanks,
Ricardo Mestre

Report message to a moderator

Re: File I/O error [message #678633 is a reply to message #678632]

Mon, 23 December 2019 05:40

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read the OraFAQ Forum Guide and How to use code tags and make your code easier to read

Looks like a problem with that tempfile. You would get an error only when a session needs to use it, which might not be very often. I would create a new temporary tablespace, set it as the default and make sure all schemas are pointing to it, then drop the existing temporary tablespace.

Report message to a moderator

Re: File I/O error [message #678634 is a reply to message #678632]

Mon, 23 December 2019 05:44

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

The error means Oracle was unable to write into a file more precisely the block #2978291 of file '/oradata/databases/dbapss/temp01.dbf'.
The addition information are code returned to Oracle by the OS.
In most OS, error 4 is "ERROR_TOO_MANY_OPEN_FILES: The system cannot open the file", this does not mean this is the case here, check your user OS limits and Oracle trace files.

You can know the object involved using the following query:

select owner, segment_name, partition_name, segment_type
from dba_extents
where file_id = 201 and 2978291 between block_id and block_id+blocks-1
/

Report message to a moderator

Re: File I/O error [message #678635 is a reply to message #678634]

Mon, 23 December 2019 08:53

rmestre
Messages: 2
Registered: December 2019

Junior Member

Hi,

thanks, for quick replies for my post.

I am new in the administration role, and i am facing some difficulties understanding why this is happening.

I ran the query, and did not returned results.

The information in the first post is from the trace file. Where else should i look for information?

Thanks,
Ricardo

Report message to a moderator

Re: File I/O error [message #678636 is a reply to message #678635]

Mon, 23 December 2019 09:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Look for problem report in OS "messages" file

Report message to a moderator

Previous Topic:	DB Creation process stuck to 85%
Next Topic:	How to check what takes the most disk space ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 23:17:05 CST 2024