A/UX Oracle -- sfwfb: write error
Date: Tue, 10 May 1994 21:30:48 GMT
Message-ID: <1994May10.213048.13121_at_news.yale.edu>
Greetings,
Wondering if anyone else is seeing this problem on the A/UX implementation of Oracle. Under moderately heavy I/O load, a medium sized Oracle instance fairly regularly crashes producting a .trc file for each of the Unix processes associated with it. The dbwr trace file contains the most useful information as follows:
ORACLE7 Server Release 7.0.15.5.2 - Production
With the procedural and distributed options
PL/SQL Release 2.0.17.5.2 - Production
ORACLE_HOME = /u/oracle
ORACLE_SID = DEV
Oracle process number: 3 Unix process id: 495
System name: A/UX
Node name: asdev Release: 3.0.1 Version: SVR2 Machine: mc68040
Tue May 10 15:34:37 1994
*** SESSION ID:(2.1)
KCF: write/open error dba=40008d9 block=8d9 online=1
file=1 /u/oracle/dbs/system1DEV.dbf error=7376 txt: 'Macintosh A/UX Error: 11: No more processes'error 1114 detected in background process OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process ORA-01114: IO error writing block to file 1 (block # 2265) ORA-01110: data file 1: '/u/oracle/dbs/system1DEV.dbf' ORA-07376: sfwfb: write error, unable to write database block.Macintosh A/UX Error: 11: No more processes
(Not surprisingly) Oracle support has been grinding on this for a week now with no luck. I realize that I haven't provided all of the information that would be necessary to solve the problem but I'm just trying to get a census as to whether anyone else has tseen the problem. The 'No more processes' message is just the text associated with ERRNO 11 and (I beleive) is misleading. In any case, by advice from Oracle, a variety of system tuning parameters have been modified to no avail. Anyone want to be a hero?
-- * |===| ===\ *============================================================= * | | | * -Andrew Newman * * | |==/ * C&IS Technology & Planning * * | | * Yale University * * | | * (newman-andy_at_yale.edu) * *---------------*=============================================================Received on Tue May 10 1994 - 23:30:48 CEST