Kiran Dalvi07 Sep, 20230 Comments1 Min ReadORA-27106: system pages not available to allocate memory ORA-27106: system pages not available to allocate memory Run the IPCS command to list Interprocess Communication (IPC) status as follows. [root@node1 ~]# ipcs -a Now find the process of destroyed process using their shmid as follows. [root@node1 ~]# lsof | grep 399835141 oracle_19 194509 oracle DEL REG 0,15 399835141 /SYSV00000000 oracle_24 247335 oracle DEL REG 0,15 399835141 /SYSV00000000 [root@node1 ~]# Now kill these process : [root@node1 ~]# kill -9 194509 247335 [root@node1 ~]# [root@node1 ~]# [root@node1 ~]# lsof | grep 399835141 [root@node1 ~]# [root@node1 ~]# ipcs -a Now our memory space released, we can startup the database. sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 22 13:25:46 2022 Version 19.14.0.0.0 Copyright (c) 1982, 2021, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 2.1446E+11 bytes Fixed Size 37223248 bytes Variable Size 1.3314E+11 bytes Database Buffers 8.1068E+10 bytes Redo Buffers 207720448 bytes Database mounted. Database opened. SQL> Hope it helps! Oracle DBAShare: ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMITCheck last user login