Home » RDBMS Server » Server Administration » File I/O error (11.2)
File I/O error [message #678632] Mon, 23 December 2019 05:14 Go to next message
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
Re: File I/O error [message #678633 is a reply to message #678632] Mon, 23 December 2019 05:40 Go to previous messageGo to next message
John Watson
Messages: 8274
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.
Re: File I/O error [message #678634 is a reply to message #678632] Mon, 23 December 2019 05:44 Go to previous messageGo to next message
Michel Cadot
Messages: 67150
Registered: March 2007
Location: Nanterre, France, http://...
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
/
Re: File I/O error [message #678635 is a reply to message #678634] Mon, 23 December 2019 08:53 Go to previous messageGo to next message
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



Re: File I/O error [message #678636 is a reply to message #678635] Mon, 23 December 2019 09:34 Go to previous message
BlackSwan
Messages: 26708
Registered: January 2009
Location: SoCal
Senior Member
Look for problem report in OS "messages" file
Previous Topic: DB Creation process stuck to 85%
Next Topic: How to check what takes the most disk space ?
Goto Forum:
  


Current Time: Wed Jun 03 10:01:21 CDT 2020