Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 5 Jan 2005 14:21:27 +0000
From:      Ceri Davies <ceri@submonkey.net>
To:        Alexander Leidinger <Alexander@Leidinger.net>, Andriy Gapon <avg@icyb.net.ua>, current@freebsd.org, re@freebsd.org
Subject:   Re: Oracle & linprocfs (was: Re: linux kernel-land)
Message-ID:  <20050105142127.GH49329@submonkey.net>
In-Reply-To: <20050105112422.GZ49329@submonkey.net>
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>

next in thread | previous in thread | raw e-mail | index | archive | help

--+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 <avg@icyb.net.ua> 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--



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050105142127.GH49329>