| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBWR process terminated - KCF:write/open error
Hi
I think this error has to do with the DBWR batch size limit.
The value may be set too high.
The default is
db_files * db_file_simultaneous_writes / 2
To check the current value
select kviidsc,kviival from sys.x$kvii
where kviitag in ('kcbswc','kcbscc')
/
This will give you the size of your DBWR batch size limit. To lower this limit decrease the value for db_files or decrease db_file_simultaneous_writes in you initSID.ora.
If you set the DBWR batch size limit too high, on some relaeses of Oracle it is possible to generate batches larger than the maximum number of simultaneous asynchronous writes suported by the O/S. The writes would fail and messages would be sent to the alert log.
This could be the reason for the messages in your alert log.
Best Regards
Suhen Pather
Oracle DBA
Strandbags Australia
Land 02 9749 7791
email suhen.pather_at_strandbags.com.au
-----Original Message-----
From: aaaa wwwwww [mailto:krisibm_at_lycos.com]
Sent: Tuesday, November 28, 2000 11:25 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: DBWR process terminated - KCF:write/open error
Dear
This is a potential case of bugs and patches
Why don't U go through metalink for bugs
Rao
-- On Mon, 27 Nov 2000 15:06:02 Weaver, Walt wrote:Received on Mon Nov 27 2000 - 20:05:02 CST
>This is a reach, but I remember, way back in my AIX days, getting an error
>similar to this when something bad happened to the kernel extensions that
>need to be set up for AIX.
>
>I'm working on dim ancestral memory here, so I make no guarantees...
>
>--Walt Weaver
> Bozeman, Montana, USA
>
>-----Original Message-----
>Sent: Monday, November 27, 2000 1:40 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi listers!
>
>I have a production database (AIX 4.2.1, Oracle 7.3.4) where I did a
>compressed export (using compress) and then passed it to another server
(AIX
>4.3.3, Oracle 8.1.5) via ftp in binary mode.
>In this new server wich I am testing, I have already created the structures
>of the oracle database and I am supposed to just do an import to get the
>data.
>
>While importing, I got the following error (I tried this twice) at the same
>disk:
>
>IMP-00003: ORACLE error 3113 encountered
>ORA-03113:end-of-file on communication channel
>IMP-00000: Import terminatedunsuccessfully
>
>Once I got this, the import was terminated. I checked if there was a
message
>in the alert.log, and I found this:
>
>Fri Nov 24 16:09:48 2000
>KCF: write/open error block=0x89e4online=1
>error=27063 txt: 'IBM AIXRISC System/6000 Error: 11: Resource temporarily
>unavailable
>Additionalinformation: -1
>Additional information: 8192'
>DBW0: terminating instance due to error 1242
>Instance terminated by DBW0, pid = 18572
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Weaver, Walt
> INET: wweaver_at_rightnow.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
Get FREE Email/Voicemail with 15MB at Lycos Communications at http://comm.lycos.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: aaaa wwwwww INET: krisibm_at_lycos.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may
 |
 |