My Oracle Support Banner

Restarting a database during backup job fails with "ORA-27515: inadequate memlock limit or driver settings" (Doc ID 2644901.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Linux x86-64

Symptoms

Restart of a 19c Database fails during backup Job:

BR0280I BRBACKUP time stamp: 2020-02-28 15:49:22
BR0330I Starting and mounting database instance TEST ...
BR0278E Command output of 'LD_LIBRARY_PATH=/oracle/TEST/19/lib /oracle/TEST/19/bin/sqlplus /nolog < /oracle/TEST/sapbackup/.bfdfwkan.spi':

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Feb 28 15:49:22 2020
Version 19.6.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

@> Connected to an idle instance.
_USER'@'_CONNECT_IDENTIFIER>
PUBLIC@TEST> SQL> SQL> SQL> SQL> SQL> ORA-00603: ORACLE server session terminated by fatal error
ORA-27515: inadequate memlock limit or driver settings

Max Locked Memory Settings have been increased to UNLIMTED for both oracle and root user in /etc/security/limits.conf:

#Changes because of presteps for 19c

oracle soft memlock unlimited
oracle hard memlock unlimited
orarom soft memlock unlimited
orarom hard memlock unlimited
@oinstall soft memlock unlimited
@oinstall hard memlock unlimited
root soft memlock unlimited
root hard memlock unlimited

Changes

 Database has been upgraded from 12.1.0.2 to 19.6

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.