From owner-freebsd-qa Tue Jan 22 11:10: 0 2002 Delivered-To: freebsd-qa@freebsd.org Received: from jfitz.com (adsl-63-194-217-126.dsl.snfc21.pacbell.net [63.194.217.126]) by hub.freebsd.org (Postfix) with SMTP id DA8B237B405 for ; Tue, 22 Jan 2002 11:09:53 -0800 (PST) Received: (qmail 56558 invoked from network); 22 Jan 2002 19:09:52 -0000 Received: from localhost.jfitz.com (HELO FITZLT) (127.0.0.1) by localhost.jfitz.com with SMTP; 22 Jan 2002 19:09:52 -0000 Message-ID: <004b01c1a378$5f41b7f0$070ca8c0@FITZLT> From: "John Fitzgibbon" To: Subject: RC 4.5 and Oracle Date: Tue, 22 Jan 2002 11:09:10 -0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 Sender: owner-freebsd-qa@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Hi, On 01/16 I cvsup'd my source up to RC 4.5, (from RELENG_4), and rebuilt world and kernel. Since doing that, I can't start Oracle databases, or create new databases. Details are below. I'd be interested to know if others have succeeded with this. Thanks, Fitz. Details: When starting an existing database I get the following error: ORA-01102: cannot mount database in EXCLUSIVE mode This error would "normally" occur if an attempt was made to start an already-running database with different environment settings, (for example, same database with a different ORACLE_HOME). I get a similar message if I try to create a new database from scratch: CREATE DATABASE "somedb" * ORA-01501: CREATE DATABASE failed ORA-01101: database being created currently mounted by some other instance I was running Oracle 8.1.7 for Linux using linux 7.1 from usr/ports/emulator. I reinstalled linux 7.1 -- this had no impact. Getting Oracle 8.1.7 installed in the first place took a bit of hacking, but it had worked fine up to now. To get Oracle installed originally, I copied it directly from a known good Red Hat install, installed the linux 7.1 port, and rebuilt the kernel with Oracle-specific shared memory/semaphore settings: options SYSVSHM #SYSV-style shared memory options SYSVMSG #SYSV-style message queues options SYSVSEM #SYSV-style semaphores options SHMMAXPGS=50000 options SHMMIN=1 options SHMMNI=100 options SHMSEG=10 options SEMMNI=100 options SEMMSL=310 options SEMMNS=610 options SEMOPM=100 #options SEMVMX=32767 Interestingly, after attempting to start the db, Oracle's background processes seem to be running ok, (see the output below). It looks like the mount operation is having trouble talking to the server processes. I suspect this may be a problem with the shared memory/semaphore settings in the new kernel, (I seem to remember similar problems when I first tried installing without fixing the kernel), but I don't know enough about what's changed in the kernel to figure out if this is the problem, or how to fix it. SVRMGR> connect internal Connected. SVRMGR> startup ORACLE instance started. Total System Global Area 25858208 bytes Fixed Size 73888 bytes Variable Size 15339520 bytes Database Buffers 8388608 bytes Redo Buffers 2056192 bytes ORA-01102: cannot mount database in EXCLUSIVE mode SVRMGR> exit Server Manager complete. su-2.04$ ps -aux USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND ... oracle 55920 0.7 3.2 53500 16720 ?? Ss 10:45AM 0:00.07 ora_pmon_mydb (oracle) oracle 55922 0.0 3.2 52796 16612 ?? Ss 10:45AM 0:00.05 ora_dbw0_mydb (oracle) oracle 55924 0.0 3.1 52672 16308 ?? Ss 10:45AM 0:00.05 ora_lgwr_mydb (oracle) oracle 55926 0.0 3.1 52676 16352 ?? Ss 10:45AM 0:00.05 ora_ckpt_mydb (oracle) oracle 55929 0.3 3.1 52660 16312 ?? Ss 10:45AM 0:00.05 ora_smon_mydb (oracle) oracle 55931 0.3 3.1 52660 16300 ?? Ss 10:45AM 0:00.05 ora_reco_mydb (oracle) oracle 55933 0.3 3.1 52816 16380 ?? Ss 10:45AM 0:00.05 ora_arc0_mydb (oracle) ... su-2.04$ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-qa" in the body of the message