Re: Increasing SGA

From: Chuck Hamilton <chuckh_at_dvol.com>
Date: Mon, 21 Sep 1998 14:55:03 GMT
Message-ID: <3608685a.10667929@news.dvol.com>

On Mon, 21 Sep 1998 11:25:34 GMT, justvrk_at_my-dejanews.com wrote:

>I am working on Oracle 8 loaded on to sun solaris.
>I am facing problems in increasing the size of SGA.
>whenever I change the settings in initefs02.ora (efs02 is the SID)
>I get an error while Database startup
> Shared memory realm already exists.
>Can anbody explain what this means. Also I need some standard steps to be
>followed while increasing the size of SGA
>Thanks in Advance..
>vrk.

First suggestion: shut down the database and see if Oracle still owns a shared memory segment. If it does, delete the segment and try to start up again.

Second suggestion: Make sure your kernel supports the sga size you want. On HP you there's a kernel param called SH_MEM_MAX or something like that. Sun probably has something similar. --
Chuck Hamilton
chuckh_at_dvol.com

If at first you don't succeed, sky diving isn't for you. Received on Mon Sep 21 1998 - 09:55:03 CDT