We tried to start the database but got “ORA 27102 out of memory” errors. There was a DB activity to perform and we normally shut down the database after completion. We got the below errors
SQL> startup nomount;
ORA-27102: out of memory
Solaris-AMD64 Error: 12: Not enough space
Additional information: 1671
Additional information: 2147483648
Additional information: 34292629504
SQL>
OR
SQL> startup mount;
ORA-27102: out of memory
Solaris-AMD64 Error: 12: Not enough space
Additional information: 1671
Additional information: 2147483648
Additional information: 34292629504
SQL>
OR
SQL> startup;
ORA-27102: out of memory
Solaris-AMD64 Error: 12: Not enough space
Additional information: 1671
Additional information: 2147483648
Additional information: 34292629504
SQL>
ORA 27102 out of memory Solution:
We need to set parameter project.max-shm-memory perfectly.
oracle@prod:~$ prtconf | grep Mem
Memory size: 65536 Megabytes
oracle@prod:~$ id -p
uid=59008(oracle) gid=10001(dba) projid=3(default)
oracle@prod:~$ prctl -n project.max-shm-memory -i project 3
project: 3: default
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
project.max-shm-memory privileged 35.GB – deny –
system 40.GB max deny –
OR
oracle@prod:~$ prctl -n project.max-shm-memory -v 45gb -r -i project user.oracle
Start your database now:
oracle@prod:~$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Oct 9 13:46:01 2024
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 3.4360E+10 bytes
Fixed Size 5383504 bytes
Variable Size 4429187760 bytes
Database Buffers 2.9863E+10 bytes
Redo Buffers 61722624 bytes
SQL>
SQL> alter database mount;
Database altered.
SQL> alter database open;
Database altered.
SQL> exit
Disconnected from Oracle Database 12c Standard Edition Release 12.1.0.2.0 – 64bit Production
oracle@prod:~$
Now, you can see ORA 27102 out of memory did not come and start up the database also.
Fixed the error “ORA 27102 out of memory“.