From owner-freebsd-database@FreeBSD.ORG Sat Dec 18 08:39:41 2004 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id A102D16A4CF; Sat, 18 Dec 2004 08:39:41 +0000 (GMT) Received: from www.svzserv.kemerovo.su (www.svzserv.kemerovo.su [213.184.65.80]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9054743D5A; Sat, 18 Dec 2004 08:39:40 +0000 (GMT) (envelope-from eugen@www.svzserv.kemerovo.su) Received: from www.svzserv.kemerovo.su (eugen@localhost [127.0.0.1]) iBI8dbBE001854; Sat, 18 Dec 2004 15:39:37 +0700 (KRAT) (envelope-from eugen@www.svzserv.kemerovo.su) Received: (from eugen@localhost) by www.svzserv.kemerovo.su (8.12.11/8.12.11/Submit) id iBI8dbpe001853; Sat, 18 Dec 2004 15:39:37 +0700 (KRAT) (envelope-from eugen) Date: Sat, 18 Dec 2004 15:39:37 +0700 From: Eugene Grosbein To: emulation@freebsd.org Message-ID: <20041218083937.GA1253@svzserv.kemerovo.su> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.1i cc: database@freebsd.org Subject: Oracle 9.2.0.1.0 upgraded to 9.2.0.5.0 can't parse linprocfs? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 18 Dec 2004 08:39:41 -0000 Hi! We were running Oracle 9i (9.2.0.1.0) with FreeBSD 5.0-CURRENT (then 5.2.1-R, then 5.3-STABLE) for a year without a problem. Lately he hit one of Oracle's internal bugs and were forced to upgrade Oracle 9i upto 9.2.0.5.0 using patchset. Upgrade went just OK, though I was forced to replace /compat/linux/etc/redhat-release with new content for Oracle Installer start to work: Red Hat Enterprise Linux AS release 3 (Taroon). Now Oracle can't start properly. It seems it fails to parse a file from linprocfs. kdump shows that it reads /compat/linux/proc/10494/stat (where 10494 is a PID of newly started child) and breaks immediately saying that sscanf is failed: 10476 oracle CALL open(0xbfbfb72c,0,0) 10476 oracle NAMI "/compat/linux/proc/10494/stat" 10476 oracle NAMI "/compat/linux" 10476 oracle NAMI "/compat/linux/proc/10494/stat" 10476 oracle RET open 10/0xa 10476 oracle CALL read(0xa,0xbfbfb764,0x3e7) 10476 oracle GIO fd 10 read 113 bytes "10494 (oracle) 0 10493 10494 10494 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 311\ 750656 25752 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 " 10476 oracle RET read 113/0x71 10476 oracle CALL close(0xa) 10476 oracle RET close 0 10476 oracle CALL mincore(0xbfbfb6f0,0) 10476 oracle RET mincore 0 10476 oracle CALL close(0x6) 10476 oracle RET close 0 10476 oracle CALL open(0x5001a53c,0x8441,0x1b4) 10476 oracle NAMI "/compat/linux/home/oracle/9.2.0.1.0/admin/orcl/bdump" 10476 oracle NAMI "/home/oracle/9.2.0.1.0/admin/orcl/bdump/alert_ORCL.log" 10476 oracle RET open 6 10476 oracle CALL old.killpg(0x6,0xbfbfb6f4,0x2) 10476 oracle GIO fd 6 wrote 79 bytes "skgpspawn failed:category = 27143, depinfo = 22, op = sscanf, loc = sk\ gpstime5 " So I ask, does contents of /compat/linux/proc/10494/stat shown above looks right? I do not have a RedHat box to compare format. Perhaps, I should upgrade installed linux_base-7.1_7/linux_devtools-7.1 upto linux_base-8.0? Eugene Grosbein