Re: cleanup the failed instance's SGA ??? HOW ??

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 13 Sep 1999 10:27:17 +0100
Message-ID: <937215367.29387.3.nnrp-06.9e984b29@news.demon.co.uk>

Look up the ipcs and ipcrm commans (operating system) for details.

Also, even when there appears to be no Oracle instance running

    svrmgrl
    connect internal
    shutdown abort

may do the job anyway.

NB It may be that you have two instances which actually do want to use the same shared memory segment. In which case one of the instances will have to be changed. Commonest problem was with long instance names which matched to the first 4 characters - but I can't remember which version of Oracle and which platforms this affected.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Gregor Loock wrote in message <7ria9d$pln$1_at_news.sfb.de>...
>Had a ORA-27100 : shared memory realm already exists
>
>
>:-(
>
>Action: Use a different instance name, or cleanup the failed instance's
SGA.
>
>How to cleanup the failed instance's SGA ?????
>
>
>
>
Received on Mon Sep 13 1999 - 04:27:17 CDT