Re: Can NOT start second database

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 Sun Nov 19 2000 - 11:41:08 CST