From owner-freebsd-current@FreeBSD.ORG Thu Jan 6 23:03:40 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 B953216A4CE; Thu, 6 Jan 2005 23:03:40 +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 2FBFB43D1F; Thu, 6 Jan 2005 23:03:40 +0000 (GMT) (envelope-from setantae@submonkey.net) Received: from setantae by shrike.submonkey.net with local (Exim 4.43 (FreeBSD)) id 1CmgfD-000FzC-Ak; Thu, 06 Jan 2005 23:03:31 +0000 Date: Thu, 6 Jan 2005 23:03:31 +0000 From: Ceri Davies To: Alexander Leidinger , Andriy Gapon , current@freebsd.org, re@freebsd.org Message-ID: <20050106230331.GB49329@submonkey.net> Mail-Followup-To: Ceri Davies , Alexander Leidinger , Andriy Gapon , current@freebsd.org, re@freebsd.org, marcel@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> <20050105142127.GH49329@submonkey.net> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="NP12RPW2Q08TId7w" Content-Disposition: inline In-Reply-To: <20050105142127.GH49329@submonkey.net> X-PGP: finger ceri@FreeBSD.org User-Agent: Mutt/1.5.6i Sender: Ceri Davies cc: marcel@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: Thu, 06 Jan 2005 23:03:40 -0000 --NP12RPW2Q08TId7w Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Jan 05, 2005 at 02:21:27PM +0000, Ceri Davies wrote: > 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 orac= le > > > > 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 pr= oblem > > > > with linux_base-8 a while ago: > > > > http://lists.freebsd.org/pipermail/freebsd-database/2004-February/0= 00149.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 pl= aying > > > > around a little bit I found out that Oracle (or some redhat 8 lib t= hat > > > > 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, eve= n in > > > > the single CPU case). > > > >=20 > > > > After I fixed sys/compat/linprocfs/linprocfs.c to always produce cp= u%d > > > > line(s) my oracle started to behave again. > > > >=20 > > > > I am not sure if this is actually linux_base or linux_devtools rela= ted > > > > 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 t= hey > > > 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 ju= st > > offered to work this evening. I'll try to get out of this but otherwise > > it will have be tomorrow evening (~36 hours time). >=20 > 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. There doesn't seem to be a significant regression for Oracle on 4.x. I've spent 4 hours on this this evening and the installer *still* doesn't work properly on 4.x, with or without an "equivalent" patch to linprocfs_misc.c. This isn't new with the linux8 patch, and it's widely believed that RELENG_5 or greater is a basic requirement for Oracle to work under linux emulation (for 9i at least - I don't have earlier versions to hand - marcel wrote the handbook section on this and may be able to test Oracle 8.x). Ceri --=20 Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. -- Einstein (attrib.) --NP12RPW2Q08TId7w Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (FreeBSD) iD8DBQFB3cPDocfcwTS3JF8RAnxSAJ9JhGxGCy+0/loI08YICP2qXCtQ1QCfXKZL T7F0MVnW5TmL5hl+fYNGd0M= =oHas -----END PGP SIGNATURE----- --NP12RPW2Q08TId7w--