ORA-27515: INADEQUATE MEMLOCK LIMIT OR DRIVER SETTINGS DURING EXACHK RUN ON 24.11 AHF RELEASE (Doc ID 3079665.1)

Last updated on APRIL 01, 2025

Applies to:

Symptoms

AHF Version is 24.11.0.

<<<< alert_XXXXX1.log

2025-03-31T01:01:10.749972+08:00
ARC3 (PID:90158): Archived Log entry 5819 added for B-1146122351.T-1.S-3121 LOS:0x000000177bab9a23 NXS:0x000000177bab9a31 NAB:2 ID 0x1f165d6f LAD:1
2025-03-31T01:03:46.347450+08:00
ksmsq q create: failed with status 2, error 25
Errors in file /u01/app/oracle/diag/rdbms/xxxxx/XXXXX1/trace/XXXXX1_ora_24709.trc (incident=452321) (PDBNAME=CDB$ROOT):
ORA-00603: ORACLE server session terminated by fatal error
ORA-27515: inadequate memlock limit or driver settings
Incident details in: /u01/app/oracle/diag/rdbms/xxxxx/XXXXX1/incident/incdir_452321/XXXXX1_ora_24709_i452321.trc
2025-03-31T01:03:47.443399+08:00

..........
2025-03-31T01:03:51.430741+08:00
opiodr aborting process unknown ospid (24709) as a result of ORA-603
2025-03-31T02:06:27.909121+08:00
ksmsq q create: failed with status 2, error 25
Errors in file /u01/app/oracle/diag/rdbms/xxxxx/XXXXX1/trace/XXXXX1_ora_97014.trc (incident=452273) (PDBNAME=CDB$ROOT):
ORA-00603: ORACLE server session terminated by fatal error
ORA-27515: inadequate memlock limit or driver settings
ORA-01017: invalid username/password; logon denied
Incident details in: /u01/app/oracle/diag/rdbms/xxxxx/XXXXX1/incident/incdir_452273/XXXXX1_ora_97014_i452273.trc
opiodr aborting process unknown ospid (97014) as a result of ORA-603

<<<< XXXXX1_ora_24709_i452321.trc

** 2025-03-31T01:03:46.422326+08:00
*** SESSION ID:(13.56917) 2025-03-31T01:03:46.422336+08:00
*** CLIENT ID:(AHF_SQL_AGENT) 2025-03-31T01:03:46.422340+08:00 <<<<<<<<<<<<<<<
*** SERVICE NAME:(SYS$USERS) 2025-03-31T01:03:46.422344+08:00
*** MODULE NAME:(python3@xxxxxxxxxx.xxxxx.xxxxx (TNS V1-V3)) 2025-03-31T01:03:46.422348+08:00
*** ACTION NAME:() 2025-03-31T01:03:46.422351+08:00
*** CLIENT DRIVER:(python-oracledb thk : 2.0.1) 2025-03-31T01:03:46.422353+08:00
*** CONTAINER ID:(1) 2025-03-31T01:03:46.422356+08:00

[TOC00000]
Jump to table of contents
Dump continued from file: /u01/app/oracle/diag/rdbms/xxxxx/XXXXX1/trace/XXXXX1_ora_24709.trc
[TOC00001]
ORA-00603: ORACLE server session terminated by fatal error
ORA-27515: inadequate memlock limit or driver settings

[TOC00001-END]
[TOC00002]
========= Dump for incident 452321 (ORA 603) ========

*** 2025-03-31T01:03:46.422772+08:00
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
[TOC00003]
----- Current SQL Statement for this session (sql_id=fh5ufah919kun) -----
select /*+ index(idl_sb4$ i_idl_sb41) */ piece#,length,piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
[TOC00004]
----- Parser State -----
Parser state1: len1=0 len2=2388 pos1=0 pos2=7
Parser state2: flg=0x0 xflg=0x4200000 xxflg=0x400
Parser state3: tty=0 tlen=7
Parser string: prx=0x7fb07087fd60 base=(nil) cur=0x7fb06a219637
[TOC00004-END]
[TOC00003-END]

....

Incident ID: 452321
Error Descriptor: ORA-603 [] [] [] [] [] [] [] [] [] [] [] []
Error class: 0
Problem Key # of args: 0
Number of actions: 15
----- Incident Context Dump -----
Address: 0x7fb07070e9f0
Incident ID: 452321
Problem Key: ORA 603
Error: ORA-603 [] [] [] [] [] [] [] [] [] [] [] []
[00]: dbgexProcessError [diag_dde]
[01]: dbgePostErrorKGE [diag_dde]
[02]: dbkePostKGE_kgsf [rdbms_dde]
[03]: kgeade []
[04]: kgefecl []
[05]: ksmsq_handle_oseerr [KSMSQ]<-- Signaling <<<<<<
[06]: ksmsq_create [KSMSQ]
[07]: ipc_recreate_que []
[08]: kclgclks []
[09]: kcbzib [CACHE_RCV]
[10]: kcbgtcr [CACHE_RCV]
[11]: ktrget2 [Transactions]
[12]: qeilbk1 []
[13]: qeilsr []
[14]: qerixtFetch [SQL_Execution]

<<<< XXXXX1_ora_97014_i452273.trc

[TOC00000]
Jump to table of contents
Dump continued from file: /u01/app/oracle/diag/rdbms/xxxxx/XXXXX1/trace/XXXXX1_ora_97014.trc
[TOC00001]
ORA-00603: ORACLE server session terminated by fatal error
ORA-27515: inadequate memlock limit or driver settings
ORA-01017: invalid username/password; logon denied

[TOC00001-END]
[TOC00002]
========= Dump for incident 452273 (ORA 603) ========

*** 2025-03-31T02:06:27.995488+08:00
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
[TOC00003]
----- Current SQL Statement for this session (sql_id=b3853arjnybzv) -----
INSERT INTO AUDSYS.AUD$UNIFIED (AUDIT_TYPE, SESSIONID, PROXY_SESSIONID, OS_USER, HOST_NAME, TERMINAL, INSTANCE_ID, DBID, AUTHENTICATION_TYPE, USERID, PROXY_USERID, EXTERNAL_USERID, GLOBAL_USERID, CLIENT_PROGRAM_NAME, DBLINK_INFO, XS_USER_NAME, XS_SESSIONID, ENTRY_ID, STATEMENT_ID, EVENT_TIMESTAMP, ACTION, RETURN_CODE, OS_PROCESS, TRANSACTION_ID, SCN, EXECUTION_ID, OBJ_OWNER, OBJ_NAME, CLIENT_IDENTIFIER, NEW_OWNER, NEW_NAME, OBJECT_EDITION, SYSTEM_PRIVILEGE_USED, SYSTEM_PRIVILEGE, AUDIT_OPTION, OBJECT_PRIVILEGES, ROLE, TARGET_USER, EXCLUDED_USER, EXCLUDED_SCHEMA, EXCLUDED_OBJECT, CURRENT_USER, ADDITIONAL_INFO, UNIFIED_AUDIT_POLICIES) values (:AUDIT_TYPE, :SESSIONID, :PROXY_SESSIONID, :OS_USER, :HOST_NAME, :TERMINAL, :INSTANCE_ID, :DBID, :AUTHENTICATION_TYPE, :USERID, :PROXY_USERID, :EXTERNAL_USERID, :GLOBAL_USERID, :CLIENT_PROGRAM_NAME, :DBLINK_INFO, :XS_USER_NAME, :XS_SESSIONID, :ENTRY_ID, :STATEMENT_ID, :EVENT_TIMESTAMP, :ACTION, :RETURN_CODE, :OS_PROCESS, :TRANSACTION_ID, :SCN, :EXECUTION_ID, :OBJ_OWNER, :OBJ_NAME, :CLIENT_IDENTIFIER, :NEW_OWNER, :NEW_NAME, :OBJECT_EDITION, :SYSTEM_PRIVILEGE_USED, :SYSTEM_PRIVILEGE, :AUDIT_OPTION, :OBJECT_PRIVILEGES, :ROLE, :TARGET_USER, :EXCLUDED_USER, :EXCLUDED_SCHEMA, :EXCLUDED_OBJECT, :CURRENT_USER, :ADDITIONAL_INFO, :UNIFIED_AUDIT_POLICIES)
[TOC00004]
----- Parser State -----
Parser state1: len1=0 len2=0 pos1=0 pos2=0
Parser state2: flg=0x0 xflg=0x0 xxflg=0x400
Parser state3: tty=0 tlen=0
Parser string: prx=0x7fedbea97d60 base=(nil) cur=(nil)
[TOC00004-END]
[TOC00003-END]

....

Number of actions: 15
----- Incident Context Dump -----
Address: 0x7fedbe9269f0
Incident ID: 452273
Problem Key: ORA 603
Error: ORA-603 [] [] [] [] [] [] [] [] [] [] [] []
[00]: dbgexProcessError [diag_dde]
[01]: dbgePostErrorKGE [diag_dde]
[02]: dbkePostKGE_kgsf [rdbms_dde]
[03]: kgeade []
[04]: kgefecl []
[05]: ksmsq_handle_oseerr [KSMSQ]<-- Signaling <<<<<<<<
[06]: ksmsq_create [KSMSQ]
[07]: ipc_recreate_que []
[08]: kcbgcur [CACHE_RCV]
[09]: ktecgsc [Space]
[10]: ktecgetsh [Space]
[11]: ktecgshx [Space]
[12]: ktspisc [Space]

Changes

 None

Cause

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