ORA-27126: unable to lock shared memory segment in core

文档解释

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

你可能感兴趣的