Date: Tue, 22 Jan 2002 11:09:10 -0800 From: "John Fitzgibbon" <fitz@jfitz.com> To: <qa@FreeBSD.org> Subject: RC 4.5 and Oracle Message-ID: <004b01c1a378$5f41b7f0$070ca8c0@FITZLT>
next in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?004b01c1a378$5f41b7f0$070ca8c0>