| 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 - SOLVED
Hi listers!
I found this note in Metalink yesterday and decided to try it...and it worked!
Problem Description
Your database has crashed last night. Checking alert.log reveals the
following error:
kcf:write/open error block=3D0x510 online=3D1 file=3D2 file is
/u02/oradata/wod022/temp101.dbf error=3D27063 txt;=20
('ibm aix rics sytem/6000 error 11 resource temporary unavailable.
Additional information -1
Additional information 4096
Automatic datafile offline due to write error on
/u02/oradata/wod022/temp101.dbf
You have check your hardware and everything seems normal.
Solution Description
You need to check the setting of AIX kernel parameter maxservers, =
minservers
and
maxreqs. Make sure that minservers and maxservers are set to at least =
40 and
80
respectively. Also make sure that maxreqs is set to at least 8192 or =
higher.
Explanation
This problem is async IO related and IBM is very much aware of it.
Saludos,
Ver=F3nica Levin Enr=EDquez
Administrador AIX
Compa=F1=EDa Cervecera de Nicaragua
Tel=E9fono: 505-2493779
Fax: 505-2443979
Email: vlevin_at_victoria.com.ni=20
http://www.victoria.com.ni
-----Mensaje original-----
De: Suhen Pather [mailto:Suhen.Pather_at_strandbags.com.au]
Enviado el: Lunes 27 de Noviembre de 2000 8:05 PM
Para: Multiple recipients of list ORACLE-L
Asunto: RE: DBWR process terminated - KCF:write/open error=20
Hi
I think this error has to do with the DBWR batch size limit.
The value may be set too high.
The default is=20
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=20 or decrease db_file_simultaneous_writes in=20 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-----
Sent: Tuesday, November 28, 2000 11:25 AM
To: Multiple recipients of list ORACLE-L
Dear=20
This is a potential case of bugs and patches
Why don't U go through metalink for bugs
Rao=20
-- On Mon, 27 Nov 2000 15:06:02 =20 Weaver, Walt wrote:Received on Tue Nov 28 2000 - 09:53:19 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.=20
>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=3D0x89e4online=3D1
>error=3D27063 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 =3D 18572
>
>--=20
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--=20
>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 --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20 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 also send the HELP command for other information (like subscribing). --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20 Author: Suhen Pather INET: Suhen.Pather_at_strandbags.com.au 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
 |
 |