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 bytes
kernel.shmmax = 68719476736
# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 4294967296
2,set user quota parameter on file /etc/security/limits.conf, following limit oracle and grid user lock memory upper to 40GBytes.
grid soft memlock 41943040
grid hard memlock 41943040
oracle soft memlock 41943040
oracle hard memlock 41943040
-- logout and relogin as oracle ,check current user limit quotas.
[oracle@stilogdb2 ~]$ ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 540672
max locked memory (kbytes, -l) 41943040
max memory size (kbytes, -m) unlimited
open files (-n) 65536
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/350519/viewspace-1050788/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/350519/viewspace-1050788/