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.
Received on Thu Sep 26 2002 - 19:55:07 CDT
