ORA-27126: unable to lock shared memory segment in core ORACLE 报错 故障修复 远程处理

文档解释

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