Help! ORA-27123: unable to attach to shared memory segment.
From: Stover Babcock <stover_at_sbsg.net>
Date: 1999/10/23
Message-ID: <38120B5C.1DB945C3_at_sbsg.net>#1/1
Date: 1999/10/23
Message-ID: <38120B5C.1DB945C3_at_sbsg.net>#1/1
Hi All,
I just rebuilt my Oracle kernel on a Sun Ultra 10 running Solaris 2.7
and Oracle 8i Enterprise.
I cannot get the new kernel to use the shared memory correctly. Am I
addressing the SGA correctly?
I keep getting the message "ORA-27123: unable to attach to shared memory
segment."
Thanks in advance,
Stover
Here is what I did :
- $ tstshm Number of segments gotten by shmget() = 50 Number of segments attached by shmat() = 6 Segments attach at lower addresses Maximum size segments are not attached contiguously! Segment separation = 4293394432 bytes Default shared memory address = 0xfe900000 Lowest shared memory address = 0xfff00000 Highest shared memory address = 0xfe900000 Total shared memory range = 4272947200 Total shared memory attached = 6291456 Largest single segment size = 1048576 Segment boundaries (SHMLBA) = 8192 (0x2000) $
- genksms -b 0xfe900000 > ksms.s // Is this correct for the SGA, If not what should it be?
- make -f ins_rdbms.mk ksms.o
$ make -f ins_rdbms.mk ioracle
- Linking Oracle
..etc...
mv -f /export/home/oracle/bin/oracle /export/home/oracle/bin/oracleO
mv /export/home/oracle/rdbms/lib/oracle /export/home/oracle/bin/oracle
chmod 6751 /export/home/oracle/bin/oracle
$ dbstart
- Linking Oracle
..etc...
mv -f /export/home/oracle/bin/oracle /export/home/oracle/bin/oracleO
mv /export/home/oracle/rdbms/lib/oracle /export/home/oracle/bin/oracle
chmod 6751 /export/home/oracle/bin/oracle
SQL*Plus: Release 8.1.5.0.0 - Production on Sat Oct 23 15:10:45 1999
(c) Copyright 1999 Oracle Corporation. All rights reserved.
SQL> Connected to an idle instance.
SQL> ORA-27123: unable to attach to shared memory segment
SVR4 Error: 22: Invalid argument
SQL> Disconnected
Database "SBSG" warm started. Received on Sat Oct 23 1999 - 00:00:00 CEST