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博客

linux 下oracle 启用lock_sga