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 laterLinux 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 |