Error message: ORA-27104: system-defined limits for shared memory was misconfigured Disconnected . SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation)

Linux and Unix-Like Red Hat
1

Dears,
Please assist us with the above subject error.

Full error message:

An error occurred while processing option SAP NetWeaver 7.0 including Enhancement Package 1 Support Release 1 > SAP Application Server ABAP > Oracle > Central System > Central System (Last error reported by the step: SQL statement or script failed. DETAILS: Error message: ORA-27104: system-defined limits for shared memory was misconfigured Disconnected . SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation)

Here is the log result.
ora_sql_results.log

Process ID: 0
Session ID: 0 Serial number: 0


Disconnected


SAPINST: End of output of SQL executing program /oracle/ERD/122/bin/sqlplus.

SAPINST found errors.
SAPINST The current process environment may be found in sapinst_ora_environment.log.

2024-06-21, 11:10:14 SAPINST ORACLE stop logging






================================================================================
2024-06-21, 11:10:14 SAPINST ORACLE start logging for 

STARTUP NOMOUNT;

exit;

Output of SQL executing program:



SQL*Plus: Release 12.2.0.1.0 Production on Fri Jun 21 11:10:14 2024

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

Connected to an idle instance.

ORA-27104: system-defined limits for shared memory was misconfigured
Disconnected


SAPINST: End of output of SQL executing program /oracle/ERD/122/bin/sqlplus.

SAPINST found errors.
SAPINST The current process environment may be found in sapinst_ora_environment.log.

2024-06-21, 11:10:15 SAPINST ORACLE stop logging

Regards

2

This is the error:

Google finds:
DBCA fails with error ORA-27104 (oracle.com)
Compare with your system settings that you get with command

sysctl -a | fgrep kernel.shm

kernel.shmmax (value is in bytes) is the "maximum system shared memory size". It may not exceed the kernel.shmall (value is in pages, on x86 computers a page is 4096 bytes).
You might need to adapt the system settings or the settings in the text file /etc/sysconfig/oracle
(Not being an Oracle expert, I am surprised that such a file exists.)

1 Like