问题:四节点RAC,启动到第三个节点的ASM时,发现前面2台的ASM都抛出错误:
ORA-00604: error occurred at recursive SQL level 3
ORA-04031: unable to allocate 216 bytes of shared memory ("shared pool","selectp.inst_id, p.free_spa...","sql area","KGHSC_ALLOC_BUF:buf")
解决办法:
加大ASM的shared_pool_size值:
- vi /u01/app/oracle/admin/+asm/pfile/init.ora
-
shared_pool_size=500M
重启RAC:
一切OK。
Normal
0
7.8 磅
0
2
false
false
false
EN-US
ZH-CN
X-NONE
MicrosoftInternetExplorer4
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:普通表格;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.5pt;
mso-bidi-font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:宋体;
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;
mso-font-kerning:1.0pt;}
阅读(2322) | 评论(0) | 转发(0) |