Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Create DB and error 07331

Re: Create DB and error 07331

From: Natarajan Malupillai <mnatty_at_ix.netcom.com>
Date: 1998/01/14
Message-ID: <34BD6A73.5F05@ix.netcom.com>#1/1

scw30_at_amdahl.com wrote:
>
> In article <34B97B8F.E3D62FA4_at_spacestar.net>,
> bmotzer_at_spacestar.net wrote:
>
> I've had a similar problem. Solaris 2.5.1, oracle 8.0.3. dbstart
> give the ora-7331 error. I've tried adjusting the db_block_size to
> 2048 and 8192 (same as some other systems) and dbshut/dbstart - no
> change. Getting the same error.
>
> Any advice.
>
> > I've recently installed an Oracle version 7.3.3 database on a sparc LX
> > workstation with 48 megs
> > of ram. When trying to run a create database command I get the following
> > error:
> >
> > ORA-07331 smsnsg: unable to allocate the variable portion of the sga
> > additional information: 4
> >
> > I've tried reducing the number of processes in the init.ora and a couple
> > of other things. Is this crazy to think that
> > I'm going to get Oracle running on a unix platform with so little
> > memory? The error manual suggests reconfiguring
> > the kernal to get a bigger segment size, is this even possible?
> >
> > Thanks,
> > please email to bmotzer_at_spacestar.com
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
The problem might be that there might not be a single shared memory segment or contiguous segments that can house the sga. Re-configure the kernel with SHMMAX, SHMMNL and all those parameters or reduce the parameters that contribute to the SGA. Received on Wed Jan 14 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US