From owner-freebsd-current@FreeBSD.ORG Wed Jan 5 14:21:38 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 AE91D16A4CF; Wed, 5 Jan 2005 14:21:38 +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 19FB243D31; Wed, 5 Jan 2005 14:21:38 +0000 (GMT) (envelope-from setantae@submonkey.net) Received: from setantae by shrike.submonkey.net with local (Exim 4.43 (FreeBSD)) id 1CmC2R-0002ST-Uv; Wed, 05 Jan 2005 14:21:27 +0000 Date: Wed, 5 Jan 2005 14:21:27 +0000 From: Ceri Davies To: Alexander Leidinger , Andriy Gapon , current@freebsd.org, re@freebsd.org Message-ID: <20050105142127.GH49329@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> <20050105112422.GZ49329@submonkey.net> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="+mSjbC2tVdWE/Wop" Content-Disposition: inline In-Reply-To: <20050105112422.GZ49329@submonkey.net> X-PGP: finger ceri@FreeBSD.org User-Agent: Mutt/1.5.6i Sender: Ceri Davies 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 14:21:38 -0000 --+mSjbC2tVdWE/Wop Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Jan 05, 2005 at 11:24:22AM +0000, Ceri Davies wrote: > 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 prob= lem > > > with linux_base-8 a while ago: > > > http://lists.freebsd.org/pipermail/freebsd-database/2004-February/000= 149.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 play= ing > > > 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). >=20 > 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). It looks like there is actually more time than I thought before the release, so I will definitely have time to check this out on a 4.x system. Won't be today, as mentioned. Ceri --=20 Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. -- Einstein (attrib.) --+mSjbC2tVdWE/Wop Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (FreeBSD) iD8DBQFB2/fnocfcwTS3JF8RAmiSAJ4uciYoXJlBqY3mYyMaOpLMTy8eKACbBxGf v5c12yEQAZug7SfYcGWjJXs= =X3Sr -----END PGP SIGNATURE----- --+mSjbC2tVdWE/Wop--