linux lock_sga

来源：互联网发布：天天特价淘宝编辑：程序博客网时间：2024/06/17 14:05

修改 lock_sga=true 后报错

ORA-27102: out of memory

Linux-x86_64 Error: 12: Cannot allocate memory on startup

超出内存不能分配。内存空闲较多，查询MOS 为 locked内存限制。

查看 ullimit

# ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 20
file size (blocks, -f) unlimited
pending signals (-i) 16382
max locked memory (kbytes, -l) 64 # <<<<<<<
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) unlimited
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

修改锁定内存限制

/etc/security/limits.conf 下增加最大锁定内存 KB 下面是 20GB

ora10 soft memlock 20000000

ora10 hard memlock 20000000

/etc/profile 修改 ulimit

ulimit -l 20000000

查看内存标记为 locked。

[ora10@redhat249 ~]$ ipcs -ma

------ Shared Memory Segments --------
key        shmid      owner      perms      bytes      nattch     status
0xcf06c6d8 65537      ora11      660        4096       0
0x72d62788 15335461   ora10      640        4297064448 51                locked

------ Semaphore Arrays --------
key        semid      owner      perms      nsems
0x03fd7650 4718594    ora10      640        201
0x03fd7651 4751363    ora10      640        201
0x03fd7652 4784132    ora10      640        201
0x03fd7653 4816901    ora10      640        201
0x03fd7654 4849670    ora10      640        201
0x47109584 491527     ora11      660        201
0x47109585 524296     ora11      660        201
0x47109586 557065     ora11      660        201
0x47109587 589834     ora11      660        201
0x47109588 622603     ora11      660        201

0 0