ORA-27126: unable to lock shared memory segment in core
Cause: insufficient privileges to lock shared memory segment in core
Action: make sure process is running with necessary privileges.
ORA-27126错误是一个UPS如果无法锁定共享内存而发布的error。官方解释如下:
ORA-27126: unable to lock shared memory segment string in core
Cause: Unable to lock a memory region, unable to map to address space, not enough resources and/or memory corruption.
Action: Re-create the shared memory segment. Check system logs for any problems.
有时,ORA-27126会随着事务处理中断(TNS)而发生,因为这是一个应用程序分配和释放内存的最常见的错误之一。
1.使用vmmap命令重置共享内存段:
vmmap -vm //bin/oracle
2.使用ipcrm命令从内存缓存中释放所有Oracle shared memory的ID:
# ipcrm –m
3.使用系统变量SHMMAX和SHMALL设置正确的共享内存大小:
# echo SHMMAX=128M >>/etc/sysctl.conf
# echo SHMALL=128M >>/etc/sysctl.conf
4.重新启动服务器进程以激活变更:
# sysctl –p
5.在服务器中启动Listener。
# lsnrctl start