Re: maximum number of processes 150 exceeded?

"lfree" <windows-free_at_163.com:s/windows/linux/> wrote in message news:<an0a9k$2s5g$1_at_mail.cn99.com>...
> I modify /etc/system and initorcl.ora.
>
> # diff system.ORG system
> 79c79,80
> < set shmsys:shminfo_shmmax=268435456
> ---
> > * set shmsys:shminfo_shmmax=268435456
> > set shmsys:shminfo_shmmax=650117120
> 83c84,85
> < set semsys:seminfo_semmns=200
> ---
> > * set semsys:seminfo_semmns=200
> > set semsys:seminfo_semmns=840
>
>
> # diff initorcl.ora.ORG initorcl.ora
> 59c59,60
> < db_block_buffers = 48282
> ---
> > #db_block_buffers = 48282
> > db_block_buffers = 60000
> 63c64,65
> < large_pool_size = 104857600
> ---
> > #large_pool_size = 104857600
> > large_pool_size = 1048576
> 69c71
> < processes = 150
> ---
> > processes = 650
>
> oracle instance is OK.
> when I modify processes = 700,prompt 'ORA-03113: end-of-file on
> communication channel.'
> why?
>
>
> >
> > I am installing oracle 8i on solaris 2.8...
> > My company use Sun Enterprise 250,hareware configuration as fellow:
> > memory :1G swap:1G
> > OS: SunOS oracleserver 5.8 Generic_108528-12 sun4u sparc SUNW,Ultra-250
> >
> > run oracle 8.1.7,occur :
> > maximum number of processes 150 exceeded.
> >
> > I know I must be modify /etc/system and initorcl.ora ,
> > add processes to 800.
> >
> > /etc/system:
> > set shmsys:shminfo_shmmax=268435456
> > set shmsys:shminfo_shmmin=1
> > set shmsys:shminfo_shmmni=100
> > set shmsys:shminfo_shmseg=10
> > set semsys:seminfo_semmns=200
> > set semsys:seminfo_semmni=70
> > set maxphys=8388608
> >
> > initorcl.ora in accessories:
> >
> > Anyone can give me some clues on what's the meaning of all the parameters
> > and how to calculate those values?
> >
> > or show me where i can find the answer?
> >
> > Thank in advance.

semmns needs to be 2 * processes + 10
This is described in the Unix|platform - specific documentation. Insufficient semaphores result in 3113

Hth

Sybrand Bakker
Senior Oracle DBA Received on Fri Sep 27 2002 - 02:57:22 CDT