Re: Error when startup DB

On Thu, 29 Oct 1998 20:54:15 +0100, Karim Amezouj <karim.amezouj_at_gemeentekrediet.be> wrote:
> Hi ,
>
>
>I do some modification in my unix box and (of course) I can't startup
>again my DB.
>
>this the message
>
>HRMmig:orapro 2> svrmgrl
>
>Oracle Server Manager Release 2.1.4.0.0 - Production
>
>Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
>
>Oracle7 Server Release 7.2.3.0.0 - Production Release
>PL/SQL Release 2.2.3.0.0 - Production
>
>SVRMGR> connect internal
>Connected to an idle instance.
>SVRMGR> startup mount
>ORA-07307: sms1sg: shmat error, unable to attach sga.
>DEC OSF/1 (AXP) Error: 22: Invalid argument
>Additional information: 1
>SVRMGR>
>
>I need some help

It is possible that you have changed something that requires more shared memory than you have configured, or more contiguous memory.

First of all, use ipcs to see if there are some segments owned by oracle already before you start oracle up. It may not be able to attach to shared memory because some previous orphaned process still has the memory (for example, if oracle was shutdown incorrectly). I've also seen some unix that leave files around in /tmp that impact on shared memory, but don't recall if OSF was one of those. Do a df -k to be sure you aren't running out of room on a disk somewhere.

Second, be sure you have followed the installation recommendations for shared memory configuration in the Oracle install guide. If you've mucked around with shmmat or shmmax or something like that, you might have caused such a problem. The oracle metalink, if you have access to it, has some papers on shared memory that can be helpful (may also be on your documentation disk).

The "Invalid Argument" error... perhaps you've changed oracles default shell? (A wild shot in the dark, here).

Beyond that, you will have to tell us what you did.

>
>Thk
>
>Karim
>
>--
>UNIX is user-friendly... it's just selective about who its friends are.
>
>

--
These opinions are my own.
http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com Available for Oracle DBA work. Received on Sun Nov 01 1998 - 01:06:31 CST