1/5用友股份-LE支持服务业务本部技术方案--《aix下使用大页导致启动报错的提示》建立日期:2013-10-20修改日期:xxxx-xx-xx文档属性:客户文控编号:LE-DY-JS-2013-01132/5文档控制创建记录适用范围审阅人日期审阅签字所属部门发布范围发布人姓名所属部门发布时间内部员工伙伴客户日期作者所属部门邮件地址版本2013-10-20白晓宇技术支持部V1.0版本领域模块备注3/5目录aix下使用大页导致启动报错的提示......................................................................4一、问题描述:........................................................................................................4二、问题处理:........................................................................................................4Changes.....................................................................................................................4Cause.........................................................................................................................4Solution.....................................................................................................................4三、解决方法:........................................................................................................54/5aix下使用大页导致启动报错的提示一、问题描述:某项目数据库昨天通过shutdownimmediate后,再执行startup,数据库起不来报错,报错内容为SQL>startupORA-27126:unabletolocksharedmemorysegmentincoreIBMAIXRISCSystem/6000Error:1:Notowner二、问题处理:查看文档,报错的原因如下:ChangesTheOracleHomebinarieshavebeenpatchedto10.2.0.4.0.Cause"oracle"userdoesnothavetherequiredOScapabilities.WhenLOCK_SGAissettoTRUEin10.2.0.4,"oracle"usermusthaveOSlargepagescapabilities.Followingcommandcanbeusedtocheck"oracle"usercapabilities$lsuser-acapabilitiesoracleSolution1.AddtheCAP_BYPASS_RAC_VMMandCAP_PROPAGATEcapabilitiesto"oracle"user#chusercapabilities=CAP_BYPASS_RAC_VMM,CAP_PROPAGATEoracle2.ConfiguretheAIXlargepagepoolbycalculatingthenumberoflargepagesrequiredfortheSGA:num_of_large_pages=INT((total_SGA_size-1)/16MB)+13.Configurethenumberandsizeoflargepages:#vmo-p-olgpg_regions=num_of_large_pages-olgpg_size=16777216这里根据我设置SGA为4000M,进行#vmo-p-olgpg_regions=300-olgpg_size=167772165/5三、解决方法:创建pfile,将参数lock_sga=true修改成lock_sga=false。正常启动。