From owner-freebsd-current@FreeBSD.ORG Wed Jan 5 11:24:34 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 D41F916A4CE; Wed, 5 Jan 2005 11:24:34 +0000 (GMT) Received: from shrike.submonkey.net (cpc2-cdif3-6-0-cust204.cdif.cable.ntl.com [81.103.67.204]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4DB7C43D31; Wed, 5 Jan 2005 11:24:34 +0000 (GMT) (envelope-from setantae@submonkey.net) Received: from setantae by shrike.submonkey.net with local (Exim 4.43 (FreeBSD)) id 1Cm9H4-000CcQ-Nw; Wed, 05 Jan 2005 11:24:22 +0000 Date: Wed, 5 Jan 2005 11:24:22 +0000 From: Ceri Davies To: Alexander Leidinger Message-ID: <20050105112422.GZ49329@submonkey.net> Mail-Followup-To: Ceri Davies , Alexander Leidinger , Andriy Gapon , current@freebsd.org, re@freebsd.org 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> <20050105121110.43e3209a@Magellan.Leidinger.net> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="eHmdSDY+kY2au76U" Content-Disposition: inline In-Reply-To: <20050105121110.43e3209a@Magellan.Leidinger.net> X-PGP: finger ceri@FreeBSD.org User-Agent: Mutt/1.5.6i Sender: Ceri Davies cc: re@freebsd.org cc: Andriy Gapon cc: current@freebsd.org Subject: Re: 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:24:35 -0000 --eHmdSDY+kY2au76U Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Jan 05, 2005 at 12:11:10PM +0100, Alexander Leidinger wrote: > On Tue, 04 Jan 2005 19:11:26 +0200 > Andriy Gapon wrote: >=20 > [Full quote for the benefit of the people in the CC] >=20 > > 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: > >=20 > > oracle$ ./dbora.sh start > >=20 > > SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jan 4 18:49:51 2005 > >=20 > > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. > >=20 > > SQL> Connected to an idle instance. > > SQL> ORA-00600: internal error code, arguments: [kcbbnwa_1], [0], [0], > > [], [], [], [], [] > > SQL> Disconnected > >=20 > > 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/00014= 9.html >=20 > Summary: don't mount linprocfs if you want to run Oracle with > linux_base-8. >=20 > > 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: > >=20 > > cpu 2010442 17367 694544 14507692 > > + cpu0 2010442 17367 694544 14507692 > > page 131869 24567 > > swap 1570 51873 > > intr 772076592 > > ctxt 1512209526 > > btime 1104346761 > >=20 > > I see that "real linux" (Fedora Core 2) has this line too (yes, even in > > the single CPU case). > >=20 > > After I fixed sys/compat/linprocfs/linprocfs.c to always produce cpu%d > > line(s) my oracle started to behave again. > >=20 > > I am not sure if this is actually linux_base or linux_devtools related > > or if this affects fresh Oracle installations. >=20 > 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. >=20 > I don't think it's linux_devtools related (it's easy to test it, right > :-) ). >=20 > 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). I don't have one running Oracle at the moment, and ten minutes ago I just offered to work this evening. I'll try to get out of this but otherwise it will have be tomorrow evening (~36 hours time). Ceri --=20 Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. -- Einstein (attrib.) --eHmdSDY+kY2au76U Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (FreeBSD) iD8DBQFB285mocfcwTS3JF8RAu4CAJwO+Yv8qTwQOrWaM7y75LQEFp7S4QCdE4Qw GIbTGibDkfjDoqNU7Jhy/fw= =RkWd -----END PGP SIGNATURE----- --eHmdSDY+kY2au76U--