howdy,
i've been running oracle for a bunch of student classes for about
5 months; today oracle wouldn't start up after being shutdown (and even
after the machine was rebooted) with the following messages:
> acf5# runas -oracle /usr/app/oracle/product/7.3.2/bin/dbstart
>
> Oracle Server Manager Release 2.3.2.0.0 - Production
>
> Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
>
> Oracle7 Server Release 7.3.2.1.0 with the 64-bit option - Production Release
> PL/SQL Release 2.3.2.0.0 - Production
>
> SVRMGR> Connected to an idle instance.
> SVRMGR> ORA-07337: smsmat: shmat error, unable to attach sga.
> DEC OSF/1 (AXP) Error: 12: Not enough space
> Additional information: 2
> SVRMGR>
> Server Manager complete.
>
> Database "SCE" warm started.
>
> Oracle Server Manager Release 2.3.2.0.0 - Production
>
> Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
>
> Oracle7 Server Release 7.3.2.1.0 with the 64-bit option - Production Release
> PL/SQL Release 2.3.2.0.0 - Production
>
> SVRMGR> Connected to an idle instance.
> SVRMGR> ORA-07337: smsmat: shmat error, unable to attach sga.
> DEC OSF/1 (AXP) Error: 12: Not enough space
> Additional information: 2
> SVRMGR>
> Server Manager complete.
>
> Database "DBA" warm started.
>
i checked the alpha list for references; just for the record, the ownership
on $ORACLE_HOME/bin et. al. are correct (haven't changed in months), oracle
is setuid:
-rwsr-s--x 1 oracle dba 15458304 Sep 27 1996 /usr/app/oracle/product/7.3.2/bin/oracle
i haven't modified the kernel to add any shared memory parameters; right now,
things are set as:
> acf5# sysconfig -q ipc
> msg-max = 8192
> msg-mnb = 16384
> msg-mni = 64
> msg-tql = 40
> shm-max = 4194304
> shm-min = 1
> shm-mni = 128
> shm-seg = 32
> sem-mni = 16
> sem-msl = 25
> sem-opm = 10
> sem-ume = 10
> sem-vmx = 32767
> sem-aem = 16384
> num-of-sems = 60
> max-kernel-ports = 93911
> port-hash-max-num = 4695550
> port-reserved-max-num = 93911
> set-max-num = 24837
>
and "ipcs" reports:
> acf5# ipcs -m
>
> Shared Memory:
> T ID KEY MODE OWNER GROUP
> m 0 1234 --rw------- root system
>
> acf5# ipcs
>
> Message Queues:
> T ID KEY MODE OWNER GROUP
> q 0 1090549178 --rw------- root system
>
> Shared Memory:
> T ID KEY MODE OWNER GROUP
> m 0 1234 --rw------- root system
>
> Semaphores:
> T ID KEY MODE OWNER GROUP
> s 0 1090549178 --ra------- root system
any suggestions on how to fix this?
thanks,
gary
Received on Sat Jun 07 1997 - 03:59:44 NZST