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


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 :

  1. $ 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) $
  2. genksms -b 0xfe900000 > ksms.s // Is this correct for the SGA, If not what should it be?
  3. 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

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

Original text of this message