Re: Create DB and error 07331

On Solaris 2.5 (Oracle 7.3.3) I received this from Oracle support, which solved my problem:  

1. Shutdown the database.
2. Change your location to the "rdbms/lib" directory

     % cd $ORACLE_HOME/rdbms/lib       

3. Modify the "ksms.s" file       

   (changing the attached address starting at 0x80000000 to 0xe0000000 )       

     % $ORACLE_HOME/bin/genksms | sed -e s/0x80000000/0xe0000000/g > ksms.s       

4. Make a backup copy of the "env_rdbms.mk" file       

     % cp env_rdbms.mk env_rdbms.mk.ksms       

5. Modify the "env_rdbms.mk" file       

     Change: $(ORACLE_HOME)/bin/genksms > $(KSMSS)       

     To: $(ORACLE_HOME)/bin/genksms > $(KSMSS).sga       

6. Relink       

     % make -f ins_rdbms.mk ioracle  

Regards,

Bo Meyer

> 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.
>
>
> > 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
> >
Received on Thu Jan 15 1998 - 00:00:00 CST