1、alter system set lock_sga=true scope=spfile
2、shutdown immediate
3、su - root
ulimit -l nolimited
su - oracle
ulimit -l nolimited
sqlplus / as sysdba
sql>startup
sql>exit
4、su - root
echo 'oracle soft memlock -1' >> /etc/security/limits.conf
echo 'oracle hard memlock -1' >> /etc/security/limits.conf
使memlock 无限制永久有效!
-1为无限制,可改成期望的大小 (单位为KB)。
不做这一步,系统重启后,启动ORACLE将导致 ORA-27102
效果:
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 32768 oracle 644 790528 2 dest
0x00000000 65537 oracle 644 790528 2 dest
0x00000000 98306 oracle 644 790528 2 dest
0x00000000 163843 oracle 600 393216 2 dest
0x00000000 196612 oracle 600 393216 2 dest
0x00000000 229381 oracle 600 393216 2 dest
0x00000000 262150 oracle 600 393216 2 dest
0x00000000 294919 oracle 600 393216 2 dest
0x00000000 327688 oracle 600 393216 2 dest
0x00000000 360457 oracle 600 393216 2 dest
0x00000000 393226 oracle 600 393216 2 dest
0x00000000 425995 oracle 600 393216 2 dest
0x13db3eec 458764 oracle 640 132120576 16
0x5a6e4de4 491533 oracle 640 367001600 25 locked
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9683969/viewspace-659768/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9683969/viewspace-659768/