Re: Can NOT start second database

Also, don't go by your swap space to determine how much memory Oracle is taking. Look at articles on SunWorld to see why actually determining memory usage is a lot more complicated thatn that.

"Kevin Haas" <kahaas_at_carolina.rr.com> wrote in message news:3A1810CF.B0145A05_at_carolina.rr.com...
> Thanks.
>
> I fixed it, but I don't think that was the number holding me back. I
 updated
> shmmax to the Oracle recommended number of 4 billion something.
>
> The other thing I did was add more swap space. It seems Oracle grabs a lot
 of
> memory at startup some RAM and some SWAP. Here is how I did it as root:
>
> 1. mkfile -v 300m /solarissswapfile <--creates a 300MB file
> 2. swap -a /solarusswapfile. <--tells Solaris to use this file for swap
>
> This gave Solaris enough swap space to work with.
>
> "R. Schierbeek" wrote:
>
> > Hello Kevin,
> >
> > correct, shmmax=64MB is much too small.
> > The 2 SGA's should fit into your 256 MB RAM, so be careful about size of
> >
> > db_block_buffer
> > shared_pool_size
> >
> > Each user process get one semaphore, so lower
> >
> > processes to < 20 (or increase semmni)
> >
> > Good luck,
> > Roelof
> >
> > R. Schierbeek, DBA
> > email : info_at_bytelife.com
> > www : www.bytelife.com
> > Kevin Haas <kahaas_at_carolina.rr.com> schreef in berichtnieuws
> > 3A172260.C3FED288_at_carolina.rr.com...
> > > Hello fellow Oracle professionals!
> > >
> > > I can not start two (2) separate databases (instances) on my box.
 While
> > > trying to start the second database the command always fails with
> > > "Unable to start "SON." I know this is memory issue, because I was
 not
> > > able to start the first database back when I only had 128 MB RAM. Now
 I
> > > have 256 MB.
> > > .......
>
Received on Mon Nov 20 2000 - 09:44:04 CST