From owner-freebsd-current@FreeBSD.ORG Wed Jan 5 11:11:03 2005 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 3147E16A4CF; Wed, 5 Jan 2005 11:11:03 +0000 (GMT) Received: from mailout07.sul.t-online.com (mailout07.sul.t-online.com [194.25.134.83]) by mx1.FreeBSD.org (Postfix) with ESMTP id 804EF43D49; Wed, 5 Jan 2005 11:11:02 +0000 (GMT) (envelope-from Alexander@Leidinger.net) Received: from fwd04.aul.t-online.de by mailout07.sul.t-online.com with smtp id 1Cm948-0000RQ-02; Wed, 05 Jan 2005 12:11:00 +0100 Received: from Andro-Beta.Leidinger.net (rSm3jZZSreQsBKhtlPIl5I9zCl+xU9BpEZnbzLe3vfcNMiT2YuTEEq@[217.83.31.124]) by fmrl04.sul.t-online.com with esmtp id 1Cm93z-1ISSEC0; Wed, 5 Jan 2005 12:10:51 +0100 Received: from Magellan.Leidinger.net (Magellan.Leidinger.net [192.168.1.1]) j05BAGe5010236; Wed, 5 Jan 2005 12:10:16 +0100 (CET) (envelope-from Alexander@Leidinger.net) Date: Wed, 5 Jan 2005 12:11:10 +0100 From: Alexander Leidinger To: Andriy Gapon Message-ID: <20050105121110.43e3209a@Magellan.Leidinger.net> In-Reply-To: <41DACE3E.3070904@icyb.net.ua> References: <41C38A7C.3070809@icyb.net.ua> <20041218174400.4b9af118@Magellan.Leidinger.net> <41DA9B7A.3000909@icyb.net.ua> <20050104153811.75258cba@Magellan.Leidinger.net> <41DACE3E.3070904@icyb.net.ua> X-Mailer: Sylpheed-Claws 0.9.13 (GTK+ 1.2.10; i386-portbld-freebsd6.0) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-ID: rSm3jZZSreQsBKhtlPIl5I9zCl+xU9BpEZnbzLe3vfcNMiT2YuTEEq@t-dialin.net X-TOI-MSGID: 60cc3f68-74cc-463c-9d50-d4fb361c35e2 cc: ceri@freebsd.org cc: re@freebsd.org cc: current@freebsd.org Subject: Oracle & linprocfs (was: Re: linux kernel-land) X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 05 Jan 2005 11:11:03 -0000 On Tue, 04 Jan 2005 19:11:26 +0200 Andriy Gapon wrote: [Full quote for the benefit of the people in the CC] > BTW, I've got another linux kernel-land thingy: I have Oracle > installation made with previous default linux base (7), now after > upgrade to linux_base-8 (and linux_devtools-8) I can not start oracle > server (actually database instance) with the following error: > > oracle$ ./dbora.sh start > > SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jan 4 18:49:51 2005 > > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. > > SQL> Connected to an idle instance. > SQL> ORA-00600: internal error code, arguments: [kcbbnwa_1], [0], [0], > [], [], [], [], [] > SQL> Disconnected > > I see that there was at least another person who had the similar problem > with linux_base-8 a while ago: > http://lists.freebsd.org/pipermail/freebsd-database/2004-February/000149.html Summary: don't mount linprocfs if you want to run Oracle with linux_base-8. > Using ktrace I tracked it down to reading "/proc/stat" and after playing > around a little bit I found out that Oracle (or some redhat 8 lib that > Oracle used) probably missed one line there: > > cpu 2010442 17367 694544 14507692 > + cpu0 2010442 17367 694544 14507692 > page 131869 24567 > swap 1570 51873 > intr 772076592 > ctxt 1512209526 > btime 1104346761 > > I see that "real linux" (Fedora Core 2) has this line too (yes, even in > the single CPU case). > > After I fixed sys/compat/linprocfs/linprocfs.c to always produce cpu%d > line(s) my oracle started to behave again. > > I am not sure if this is actually linux_base or linux_devtools related > or if this affects fresh Oracle installations. I think this is a serious issue. Please send-pr the patch and tell us at current@ (CCed) the PR number. A src-committer should have a look at it. I don't think it's linux_devtools related (it's easy to test it, right :-) ). Do you have a 4.x system (or maybe ceri@ can test it on a 4.x system)? I like to know if we have the problem there too now (re@ CCed because they may decide to take this issue into account regarding the upcoming 4.11 release... at least there should be a note somewhere to not use linprocfs and Oracle at the same time). Bye, Alexander. -- Speak softly and carry a cellular phone. http://www.Leidinger.net Alexander @ Leidinger.net GPG fingerprint = C518 BC70 E67F 143F BE91 3365 79E2 9C60 B006 3FE7