Database startup through sqlplus and srvctl have different "Per process system memlock (soft) limit" (Doc ID 1964194.1)

Last updated on APRIL 13, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Database instance startup via sqlplus and srvctl shows different per process system memlock limit values.

For instance started via sqlplus, alert log shows:

Mon Jan 19 22:41:12 2015
Starting ORACLE instance (normal) (OS id: 19702)
Mon Jan 19 22:41:13 2015
CLI notifier numLatches:7 maxDescs:2252
.
Mon Jan 19 22:41:13 2015
Per process system memlock (soft) limit = 29G
Mon Jan 19 22:41:13 2015
Expected per process system memlock (soft) limit to lock
SHARED GLOBAL AREA (SGA) into memory: 8194M


For instance started via srvctl, alert log shows:

Mon Jan 19 22:42:29 2015
Starting ORACLE instance (normal) (OS id: 20602)
Mon Jan 19 22:42:29 2015
CLI notifier numLatches:7 maxDescs:2252
.
Mon Jan 19 22:42:29 2015
Per process system memlock (soft) limit = UNLIMITED
Mon Jan 19 22:42:29 2015
Expected per process system memlock (soft) limit to lock
SHARED GLOBAL AREA (SGA) into memory: 8194M 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms