Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> maximum number of processes 150 exceeded?
Hi,
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
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.
begin 666 initorcl.ora
M(PHC($-O<'ER:6=H=" H8RD@,3DY,2P@,C P,"!B>2!/<F%C;&4_at_0V]R<&]R
M871I;VX*(PHC(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C M(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,*(R!% M>&%M<&QE($E.250N3U)!(&9I;&4*(PHC(%1H:7,@9FEL92!I<R!P<F]V:61EM9"!B>2!/<F%C;&4_at_0V]R<&]R871I;VX@=&\@:&5L<"!Y;W4_at_8W5S=&]M:7IE M"B,@>6]U<B!21$)-4R!I;G-T86QL871I;VX_at_9F]R('EO=7(@<VET92X@($EM
M<&]R=&%N="!S>7-T96T@<&%R86UE=&5R<PHC(&%R92!D:7-C=7-S960L(&%N M9"!E>&%M<&QE('-E='1I;F=S(&=I=F5N+@HC"B,@4V]M92!P87)A;65T97(@ M<V5T=&EN9W,@87)E(&=E;F5R:6,@=&\@86YY('-I>F4@:6YS=&%L;&%T:6]NM+@HC($9O<B!P87)A;65T97)S('1H870@<F5Q=6ER92!D:69F97)E;G0@=F%L M=65S(&EN(&1I9F9E<F5N="!S:7IE"B,@:6YS=&%L;&%T:6]N<RP@=&AR964@ M<V-E;F%R:6]S(&AA=F4_at_8F5E;B!P<F]V:61E9#H_at_4TU!3$PL($U%1$E530HC M(&%N9"!,05)'12X@($%N>2!P87)A;65T97(@=&AA="!N965D<R!T;R!B92!T M=6YE9"!A8V-O<F1I;F<@=&\*(R!I;G-T86QL871I;VX@<VEZ92!W:6QL(&AA M=F4@=&AR964@<V5T=&EN9W,L(&5A8V@@;VYE(&-O;6UE;G1E9 HC(&%C8V]R M9&EN9R!T;R!I;G-T86QL871I;VX@<VEZ92X*(PHC(%5S92!T:&4_at_9F]L;&]W
M:6YG('1A8FQE('1O(&%P<')O>&EM871E('1H92!31T$@<VEZ92!N965D960@ M9F]R('1H90HC('1H<F5E('-C96YA<FEO=7,@<')O=FED960@:6X@=&AI<R!F M:6QE._at_HC"B,@(" @(" @(" @(" @(" @(" @(" M+2TM+2TM26YS=&%L;&%T M:6]N+T1A=&%B87-E(%-I>F4M+2TM+2T*(R @(" @(" @(" @(" @(" @(" @ M("!334%,3" @(" @(" @(" @345$255-(" @(" @(" @("!,05)'10HC("!" M;&]C:R @(" @(" @(#)+(" @(#0U,#!+(" @(" @(" @(" @-C_at_P,$L@(" @ M(" @(" @(#$W,# P2PHC("!3:7IE(" @(" @(" @(#1+(" @(#4U,#!+(" @ M(" @(" @(" @.#@P,$L@(" @(" @(" @(#(Q,# P2PHC"B,@5&\@<V5T('5PM(&$@9&%T86)A<V4@=&AA="!M=6QT:7!L92!I;G-T86YC97,@=VEL;"!B92!U M<VEN9RP@<&QA8V4*(R!A;&P@:6YS=&%N8V4M<W!E8VEF:6,@<&%R86UE=&5R
M<R!I;B!O;F4_at_9FEL92P@86YD('1H96X@:&%V92!A;&P*(R!O9B!T:&5S92!F M:6QE<R!P;VEN="!T;R!A(&UA<W1E<B!F:6QE('5S:6YG('1H92!)1DE,12!C M;VUM86YD+@HC(%1H:7,@=V%Y+"!W:&5N('EO=2!C:&%N9V4_at_82!P=6)L:6,* M(R!P87)A;65T97(L(&ET('=I;&P_at_875T;VUA=&EC86QL>2!C:&%N9V4@;VX@M86QL(&EN<W1A;F-E<RX@(%1H:7,@:7,*(R!N96-E<W-A<GDL('-I;F-E(&%L M;"!I;G-T86YC97,@;75S="!R=6X@=VET:"!T:&4@<V%M92!V86QU92!F;W(@ M;6%N>0HC('!A<F%M971E<G,N($9O<B!E>&%M<&QE+"!I9B!Y;W4_at_8VAO;W-E M('1O('5S92!P<FEV871E(')O;&QB86-K)R!S96=M96YT<RP*(R!T:&5S92!M M=7-T(&)E('-P96-I9FEE9"!I;B!D:69F97)E;G0_at_9FEL97,L(&)U="!S:6YC M92!A;&P_at_9V-?*@HC('!A<F%M971E<G,@;75S="!B92!T:&4@<V%M92!O;B!A M;&P@:6YS=&%N8V5S+"!T:&5Y('-H;W5L9"!B92!I;B!O;F4_at_9FEL92X*(PHC M($E.4U1254-424].4SH_at_161I="!T:&ES(&9I;&4_at_86YD('1H92!O=&AE<B!) M3DE4(&9I;&5S(&ET(&-A;&QS(&9O<@HC('EO=7(@<VET92P_at_96ET:&5R(&)Y
M('5S:6YG('1H92!V86QU97,@<')O=FED960@:&5R92!O<B!B>2!P<F]V:61I M;F<*(R!Y;W5R(&]W;BX@(%1H96X@<&QA8V4_at_86X@249)3$4](&QI;F4@:6YT M;R!E86-H(&EN<W1A;F-E+7-P96-I9FEC"B,@24Y)5"!F:6QE('1H870@<&]IM;G1S(&%T('1H:7,@9FEL92X*(PHC($Y/5$4Z(%!A<F%M971E<B!V86QU97,@ M<W5G9V5S=&5D(&EN('1H:7,@9FEL92!A<F4_at_8F%S960@;VX_at_8V]N<V5R=F%T
M:79E"B,@97-T:6UA=&5S(&9O<B!C;VUP=71E<B!M96UO<GD_at_879A:6QA8FEL M:71Y+B!9;W4@<VAO=6QD(&%D:G5S="!V86QU97,@=7!W87)D"B,@9F]R(&UO M9&5R;B!M86-H:6YE<RX*(PHC(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C M(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C M(R,C(R,C"@ID8E]N86UE(#T@(F]R8VPB"F1B7V1O;6%I;B ]('=O<FQD"@II M;G-T86YC95]N86UE(#T@;W)C; H*<V5R=FEC95]N86UE<R ](&]R8VPN=V]RM;&0*"@IC;VYT<F]L7V9I;&5S(#T@*"(O;6YT+V]R86-L92]O<F%?861M+V]R M8VPO8V]N=')O;# Q+F-T;"(L("(O;6YT+V]R86-L92]O<F%?861M+V]R8VPO M8V]N=')O;# R+F-T;"(L("(O;6YT+V]R86-L92]O<F%?861M+V]R8VPO8V]N M=')O;# S+F-T;"(I"@IO<&5N7V-U<G-O<G,@/2 S,# *;6%X7V5N86)L961? M<F]L97,@/2 Q,# *9&)?8FQO8VM?8G5F9F5R<R ](#0X,C_at_R"@IS:&%R961? M<&]O;%]S:7IE(#T@,3,R.#DR-#8W"@IL87)G95]P;V]L7W-I>F4@/2 Q,#0X M-3<V,# *:F%V85]P;V]L7W-I>F4@/2 P"@IL;V=?8VAE8VMP;VEN=%]I;G1E M<G9A;" ](#$P,# P"FQO9U]C:&5C:W!O:6YT7W1I;65O=70@/2 Q.# P"@IP M<F]C97-S97,@/2 Q-3 *"FQO9U]B=69F97(@/2 Q-C,X-# P"B-L;V=?8G5F M9F5R(#T@,38S.#0P"@HC(&%U9&ET7W1R86EL(#T_at_9F%L<V4@(",@:68@>6]U M('=A;G0_at_875D:71I;F<*(R!T:6UE9%]S=&%T:7-T:6-S(#T_at_9F%L<V4@(",@
M:68@>6]U('=A;G0@=&EM960@<W1A=&ES=&EC<PHC(&UA>%]D=6UP7V9I;&5? M<VEZ92 ](#$P,# P(" C(&QI;6ET('1R86-E(&9I;&4@<VEZ92!T;R U32!E M86-H"@HC(%5N8V]M;65N=&EN9R!T:&4@;&EN97,@8F5L;W<@=VEL;"!C875SM92!A=71O;6%T:6,@87)C:&EV:6YG(&EF(&%R8VAI=FEN9R!H87,*(R!B965N M(&5N86)L960@=7-I;F<@04Q415(@1$%404)!4T4_at_05)#2$E614Q/1RX*(R!L M;V=?87)C:&EV95]S=&%R=" ]('1R=64*(R!L;V=?87)C:&EV95]D97-T7S$@ M/2 B;&]C871I;VX]+V5X<&]R="]H;VUE+V]R86-L92]A9&UI;B]O<F-L+V%R M8V_at_B"B,@;&]G7V%R8VAI=F5?9F]R;6%T(#T_at_87)C:%\E=%\E<RYA<F,*"@HC M1$)#02!U<V5S('1H92!D969A=6QT(&1A=&%B87-E('9A;'5E("@S,"D_at_9F]R M(&UA>%]R;VQL8F%C:U]S96=M96YT<PHC,3 P(')O;&QB86-K('-E9VUE;G1S M("AO<B!M;W)E*2!M87D_at_8F4@<F5Q=6ER960@:6X@=&AE(&9U='5R90HC56YC
M;VUM96YT('1H92!F;VQL;W=I;F<@96YT<GD@=VAE;B!A9&1I=&EO;F%L(')O M;&QB86-K('-E9VUE;G1S(&%R92!C<F5A=&5D(&%N9"!M861E(&]N;&EN90HC M;6%X7W)O;&QB86-K7W-E9VUE;G1S(#T_at_-3$*(R!)9B!U<VEN9R!P<FEV871EM(')O;&QB86-K('-E9VUE;G1S+"!P;&%C92!L:6YE<R!O9B!T:&4_at_9F]L;&]W M:6YG"B,@9F]R;2!I;B!E86-H(&]F('EO=7(@:6YS=&%N8V4M<W!E8VEF:6,@ M:6YI="YO<F$@9FEL97,Z"B-R;VQL8F%C:U]S96=M96YT<R ]("@@4D)3,"P@ M4D)3,2P_at_4D)3,BP_at_4D)3,RP_at_4D)3-"P_at_4D)3-2P_at_4D)3-BP_at_4D)3-RP_at_4D)3 M."P_at_4D)3.2P_at_4D)3,3 L(%)"4S$Q+"!20E,Q,BP_at_4D)3,3,L(%)"4S$T+"!2 M0E,Q-2P_at_4D)3,38L(%)"4S$W+"!20E,Q."P_at_4D)3,3DL(%)"4S(P+"!20E,R M,2P_at_4D)3,C(L(%)"4S(S+"!20E,R-"P_at_4D)3,C4L(%)"4S(V+"!20E,R-RP@ M4D)3,C@@*0H*(R!';&]B86P_at_3F%M:6YG("TM(&5N9F]R8V4@=&AA="!A(&1B M;&EN:R!H87,@<V%M92!N86UE(&%S('1H92!D8B!I="!C;VYN96-T<R!T;PHC
M(&=L;V)A;%]N86UE<R ](&9A;'-E"@HC(%5N8V]M;65N="!T:&4_at_9F]L;&]W M:6YG(&QI;F4@:68@>6]U('=I<V@@=&\@96YA8FQE('1H92!/<F%C;&4_at_5')A M8V4@<')O9'5C= HC('1O('1R86-E('-E<G9E<B!A8W1I=FET>2X@(%1H:7,@ M96YA8FQE<R!S8VAE9'5L:6YG(&]F('-E<G9E<B!C;VQL96-T:6]N<PHC(&9R M;VT@=&AE($]R86-L92!%;G1E<G!R:7-E($UA;F%G97(@0V]N<V]L92X*(R!!M;'-O+"!I9B!T:&4@;W)A8VQE7W1R86-E7V-O;&QE8W1I;VY?;F%M92!P87)A M;65T97(@:7,@;F]N+6YU;&PL"B,@979E<GD@<V5S<VEO;B!W:6QL('=R:71E M('1O('1H92!N86UE9"!C;VQL96-T:6]N+"!A<R!W96QL(&%S(&5N86)L:6YG M('EO=0HC('1O('-C:&5D=6QE(&9U='5R92!C;VQL96-T:6]N<R!F<F]M('1H M92!C;VYS;VQE+@HC(&]R86-L95]T<F%C95]E;F%B;&4@/2!T<G5E"@HC(&1E M9FEN92!D:7)E8W1O<FEE<R!T;R!S=&]R92!T<F%C92!A;F0_at_86QE<G0_at_9FEL M97,*8F%C:V=R;W5N9%]D=6UP7V1E<W0@/2 O97AP;W)T+VAO;64O;W)A8VQE M+V%D;6EN+V]R8VPO8F1U;7 *8V]R95]D=6UP7V1E<W0@/2 O97AP;W)T+VAO M;64O;W)A8VQE+V%D;6EN+V]R8VPO8V1U;7 *(U5N8V]M;65N="!T:&ES('!A M<F%M971E<B!T;R!E;F%B;&4@<F5S;W5R8V4@;6%N86=E;65N="!F;W(@>6]U M<B!D871A8F%S92X*(U1H92!365-414U?4$Q!3B!I<R!P<F]V:61E9"!B>2!D M969A=6QT('=I=&@@=&AE(&1A=&%B87-E+@HC0VAA;F=E('1H92!P;&%N(&YA M;64@:68@>6]U(&AA=F4_at_8W)E871E9"!Y;W5R(&]W;B!R97-O=7)C92!P;&%N M+B,@<F5S;W5R8V5?;6%N86=E<E]P;&%N(#T@<WES=&5M7W!L86X*=7-E<E]D M=6UP7V1E<W0@/2 O97AP;W)T+VAO;64O;W)A8VQE+V%D;6EN+V]R8VPO=61U M;7 *"F1B7V)L;V-K7W-I>F4@/2 X,3DR"@IR96UO=&5?;&]G:6Y?<&%S<W=O M<F1F:6QE(#T_at_97AC;'5S:79E"@IO<U]A=71H96YT7W!R969I>" ]("(B"@HC M;71S7V1I<W!A=&-H97)S(#T@(BAP<F]T;V-O;#U40U I*&UU;#U/3BDH=&EC M:STQ-2DH<&]O;#UT<G5E*2(*"F-O;7!A=&EB;&4@/2 B."XP+C4B"G-O<G1? M87)E85]S:7IE(#T_at_-C4U,S8*<V]R=%]A<F5A7W)E=&%I;F5D7W-I>F4@/2 V M-34S-_at_H*"B,@061D(#(P,#$N,3(N,C4*<&%R86QL96Q?;6%X7W-E<G9E<G,@ M/2 X"@HC(%5N8V]M;65N=&EN9R!T:&4@;&EN92!B96QO=R!W:6QL(&-A=7-E M(&%U=&]M871I8R!A<F-H:79I;F<@:68_at_87)C:&EV:6YG(&AA<PHC(&)E96X@ M96YA8FQE9"!U<VEN9R!!3%1%4B!$051!0D%312!!4D-(259%3$]'+@IL;V=? M87)C:&EV95]S=&%R=" ]('1R=64*;&]G7V%R8VAI=F5?9&5S=" ]("]M;G0O M;W)A8VQE+V]R861A=&$O87)C:&EV90IL;V=?87)C:&EV95]F;W)M870@/2 B M5"544R53+D%20R(*"B,@5&AE(&9O;&QO=VEN9R!P87)A;65T97)S(&%R92!N M965D960_at_9F]R('1H92!!9'9A;F-E9"!297!L:6-A=&EO;B!/<'1I;VX*:F]B M7W%U975E7W!R;V-E<W-E<R ](#0*:F]B7W%U975E7VEN=&5R=F%L(#T_at_-C * M9&ES=')I8G5T961?=')A;G-A8W1I;VYS(#T@,3 *;W!E;E]L:6YK<R ](#0* D"F1B7V9I;&5?;75L=&EB;&]C:U]R96%D7V-O=6YT(#T@,S(* `