ORA-27102: out of memory lock_sga
ORA-27102: out of memory with lock_sga=true.出现这个错误,32位平台可能是因为SGA设置得过大。但64位平台也可能出现,在LINUX系统下,如果当前ORACLE用户权限不足,就会出现这个错误。解决办法如下:1, change system wide parameter in file : /etc/sysctl.conf# Controls the maximum shared segment size, in byteskernel.shmmax = 68719476736# Controls the maximum number of shared memory segments, in pageskernel.shmall = 42949672962,set user quota parameter on file /etc/security/limits.conf, following limit oracl
11.2.0.2 upgrade step
summary:shutdown db , and start upgrade.shutdown listener.@?/rdbms/admin/catupgrd.sql@?/rdbms/admin/utlu112s.sql@?/rdbms/admin/catuppst.sql@?/rdbms/admin/utlrp.sqlref:http://sky13and23.blog.163.com/blog/static/28693084201132032641442/http://hi.baidu.com/redflower1004/blog/item/4c2b6443e0f7a10572f05df5.htmlhttp://download.oracle.com/docs/cd/E11882_01/server.112/e17222/upgrade.htm#i1011398[@more@]
AIX 6.1, ORACLE 11G LOCK_SGA, LAGE_PAGE_SIZE(16MB) IMPORTANT!!!
网上找了一大堆垃圾文章,没有一个人负责任地将关键的地方讲出来,害得我郁闷了三天,还把其中一个系统给搞垮了,彻底启动不了了,还得IBM工程师重装系统。。。妈的,哪想到有时候学到芝麻一点的IT技术竟然如此多的障碍,高手在哪里?? 都隐居了,改行了,退出江湖了???现在公司根本招不到像样的人才,都是一群SB在干活,写的代码错误百出,而且竟都是低级错误,一点常识都没有,害得架构师们天天陪着加班到凌晨,甚至3点都还在加班。这是什么世道。。。。。好了,言归正传,本人经历过血的代价后,现在将这微不足道的技能贡献出来,希
Oracle ORION IO 测试工具
Oracle ORION IO 测试工具 http://blog.csdn.net/tianlesoftware/archive/2010/10/25/5965331.aspx[@more@]
安装oracle
Linux下安装oracle的简要步骤笔记 http://blog.chinaunix.net/u2/84422/showart_2315133.html今天手工创建10G数据库失败,报ORA-12701错误http://empo007.itpub.net/post/12076/496062[@more@]
Oracle 10g各版本之间的区别!
Oracle 10g各版本之间的区别!http://xiebh.javaeye.com/blog/348040[@more@]
raid1+0 and raid0+1
Some suspect about the crash probability of raid0+1 and raid1+0 ................ N............... N[@more@]Some suspect about the crash probability of raid0+1 and raid1+0 ................ N............... N0+1 crash probability :all = 2n*(2n-1)/2bad = n*ncrash rate = n*n/ (2n*n -n) = n/(2n-1) --> n/2*(n-1)4 4/68 8/1416 16/3032 32/62crash limit -> 50%............... N............... N1+0 crash probability :all = 2n*(2n-1)/2bad = ncrash rate =n/ (2n*n -n) = 1/(2n-1) --> 1/(n-1)4 1/3
IBM X SERVER 安装 WINDOWS
IBM X SERVER 安装 WINDOWS[@more@]安装 WINDOWS, 很简单,这里简述一下IBM X SERVER 上安装WINDOWS 与PC上的操作差异。1,首先插入并安装 驱动盘(引导盘)即:service guide(setup and installation).将IBM X SERVER Service Guide 插入光驱,系统会引导,进行一些初始化工作,包括:磁盘分区,配置WINDOWS 应答文件,时区,语言,拷贝驱动等选项,配置完之后,系统会提示插入WINDOWS 2003 安装盘, 接下来就会自动安装, 装好后进入 WINDOWS,所有的服务器驱动已经装好,避免了用户手工一个个安装驱动的麻烦。总结: IBM X SERVER 上