- 07 Sep, 2023
- 0 Comments
- 1 Min Read
ORA-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>