y!|7w5P-T8}0fromhttp://panfuy.iteye.com/blog/1258452
yK&?/UX&P^0@)cCgZj:X*p w:N~:z0在IBM 3825(24虚拟CPU)上安装Oracle,创建数据库到95%时,发生如下错误:
s#M:q(ir)Ds0ORA-12801: error signaled in parallel query server P073.51Testing软件测试网
NI*M:r^
KS
ORA-00018: maximum number of sessions exceeded
4F*L/@*t,m_0ORA-06512: at "SYS.UTL_RECOMP", line 62951Testing软件测试网^0K~6{N!l
ORA-06512: at "SYS.UTL_RECOMP", line 671
gUy6\Q~-aV O
D0ORA-06512: at line 151Testing软件测试网ZmB
c-B"bp
k
8qa0UE"m
z$HU"C0经google,发现有如下问题:51Testing软件测试网%h,X/O4Ll#A
1.CPU数量太多51Testing软件测试网n"L2[9mw2Ev1P*K
2.session数量不够
|RY"T.s]Zn051Testing软件测试网3g
@z[1Wv(EzB
参考资料51Testing软件测试网)I I9tMSXR7UsDR
http://www.keyongtech.com/5021009-oracle-11-1-0-on
2]V_o|0http://blogs.sun.com/pomah/entry/too_many_cpu51Testing软件测试网KX P^4O2^zwO(d
http://blogs.sun.com/glennf/entry/virtual_cpus_effect_on_oracle51Testing软件测试网J&\lhxP
n:jd
a7bv0b0
%U$d2Za$p$dX*v0解决:51Testing软件测试网9i5Ef!W&M:x0I
修改文件D:\app\dmadmin\product\11.1.0\db_1/assistants/dbca/templates/General_Purpose.dbc
{&Yl#b:Lj(f0在其中InitParams部分增加
disXtT0 <initParam name="sessions" value="1500"/>51Testing软件测试网lhb([i5L7nQF
nXM;D#L4YC0 <initParam name="processes" value="500"/>51Testing软件测试网$qG;s-yT3b q_?Pq
51Testing软件测试网G"dm:f2B3g[4u
MiscParams部分增加
Dy8Bp"H;C0 <sessions>500</sessions>51Testing软件测试网U9m?k$A$k+K6E
SDjf)gn1t#l0reboot os
7M/x9\(vt*cw(E;pE!pE051Testing软件测试网*C)Z P
\Nn
重新配置数据库实例
5S8n7s bM}K0使用Configure Assistant 删除orcl实例,重新创建orcl实例,OK。
I0DN+k
lx-n}2O0