From owner-freebsd-bugs@FreeBSD.ORG Wed Jan 5 11:50:25 2005 Return-Path: Delivered-To: freebsd-bugs@hub.freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 79C3816A4CF for ; Wed, 5 Jan 2005 11:50:25 +0000 (GMT) Received: from freefall.freebsd.org (freefall.freebsd.org [216.136.204.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4380843D1F for ; Wed, 5 Jan 2005 11:50:25 +0000 (GMT) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.13.1/8.13.1) with ESMTP id j05BoP4B022817 for ; Wed, 5 Jan 2005 11:50:25 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.13.1/8.13.1/Submit) id j05BoPtM022811; Wed, 5 Jan 2005 11:50:25 GMT (envelope-from gnats) Resent-Date: Wed, 5 Jan 2005 11:50:25 GMT Resent-Message-Id: <200501051150.j05BoPtM022811@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Andriy Gapon Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 43A3A16A4CE for ; Wed, 5 Jan 2005 11:46:25 +0000 (GMT) Received: from citadel.icyb.net.ua (citadel.icyb.net.ua [212.40.38.140]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5C34443D1D for ; Wed, 5 Jan 2005 11:46:22 +0000 (GMT) (envelope-from avg@topspin.kiev.ua) Received: from oddity.topspin.kiev.ua (oddity.topspin.kiev.ua [212.40.38.87]) by citadel.icyb.net.ua (8.8.8p3/ICyb-2.3exp) with ESMTP id NAA18261 for ; Wed, 05 Jan 2005 13:46:19 +0200 (EET) (envelope-from avg@topspin.kiev.ua) Received: from oddity.topspin.kiev.ua (localhost [127.0.0.1]) j05BkI2d057192 for ; Wed, 5 Jan 2005 13:46:18 +0200 (EET) (envelope-from avg@oddity.topspin.kiev.ua) Received: (from avg@localhost) by oddity.topspin.kiev.ua (8.12.10/8.12.10/Submit) id j05BkIXn057191; Wed, 5 Jan 2005 13:46:18 +0200 (EET) (envelope-from avg) Message-Id: <200501051146.j05BkIXn057191@oddity.topspin.kiev.ua> Date: Wed, 5 Jan 2005 13:46:18 +0200 (EET) From: Andriy Gapon To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Subject: kern/75848: linux emulation: linprocfs-related oracle problem with linu_base-8 X-BeenThere: freebsd-bugs@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 05 Jan 2005 11:50:25 -0000 >Number: 75848 >Category: kern >Synopsis: linux emulation: linprocfs-related oracle problem with linu_base-8 >Confidential: no >Severity: serious >Priority: medium >Responsible: freebsd-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: sw-bug >Submitter-Id: current-users >Arrival-Date: Wed Jan 05 11:50:24 GMT 2005 >Closed-Date: >Last-Modified: >Originator: Andriy Gapon >Release: FreeBSD 5.2.1-RELEASE-p13 i386 >Organization: >Environment: System: FreeBSD 5.2.1-RELEASE-p13 #32: Wed Dec 22 02:44:07 EET 2004 i386 linux_base-8-8.0_4 linux_devtools-8.0_3 >Description: 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 one other person who had the similar problem with linux_base-8 a while ago: http://lists.freebsd.org/pipermail/freebsd-database/2004-February/000149.html 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. >How-To-Repeat: please see above >Fix: --- linprocfs.patch begins here --- --- sys/compat/linprocfs/linprocfs.c Wed Dec 1 23:34:43 2004 +++ sys/compat/linprocfs/linprocfs.c.new Wed Jan 5 13:38:33 2005 @@ -426,13 +426,12 @@ T2J(cp_time[CP_NICE]), T2J(cp_time[CP_SYS] /*+ cp_time[CP_INTR]*/), T2J(cp_time[CP_IDLE])); - if (ncpu > 1) - for (i = 0; i < ncpu; ++i) - sbuf_printf(sb, "cpu%d %ld %ld %ld %ld\n", i, - T2J(cp_time[CP_USER]) / ncpu, - T2J(cp_time[CP_NICE]) / ncpu, - T2J(cp_time[CP_SYS]) / ncpu, - T2J(cp_time[CP_IDLE]) / ncpu); + for (i = 0; i < ncpu; ++i) + sbuf_printf(sb, "cpu%d %ld %ld %ld %ld\n", i, + T2J(cp_time[CP_USER]) / ncpu, + T2J(cp_time[CP_NICE]) / ncpu, + T2J(cp_time[CP_SYS]) / ncpu, + T2J(cp_time[CP_IDLE]) / ncpu); sbuf_printf(sb, "disk 0 0 0 0\n" "page %u %u\n" --- linprocfs.patch ends here --- >Release-Note: >Audit-Trail: >Unformatted: