My Oracle Support Banner

[OCI] After startup of database Instance, the Instance terminated by PMON process with error 12752 (Doc ID 2769706.1)

Last updated on MAY 12, 2021

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

In OCI VMDB system, after the change shape, the Instance being continuously terminated by the PMON process.

 

Instance Critical Process (pid: 9, ospid: 18191, SA00) died unexpectedly

PMON (ospid: 18158): terminating the instance due to error 12752

The following message observed the database alert log file 

Using parameter settings in server-side spfile +DATA/ORCL_IAD1MC/PARAMETERFILE/spfile.269.991775541
System parameters with non-default values:
processes = 3200
cpu_count = 32
_enable_NUMA_support = FALSE
use_large_pages = "false"
Reconfiguration complete (total time 1.4 secs)
2021-04-16T23:19:45.320580+00:00
Errors in file /u01/app/oracle/diag/rdbms/orcl_iad1mc/ORCL/trace/ORCL_ora_25219.trc:
ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL_IAD1MC/PASSWORD/pwdorcl_iad1mc.259.991775053
ORA-01034: ORACLE not available
ORA-27102: out of memory
Linux-x86_64 Error: 12: Cannot allocate memory
Additional information: 2731
Additional information: 65536
Additional information: 1627389952
2021-04-16T23:19:46.017395+00:00
Instance Critical Process (pid: 9, ospid: 18191, SA00) died unexpectedly
PMON (ospid: 18158): terminating the instance due to error 12752
2021-04-16T23:19:46.187462+00:00
System state dump requested by (instance=1, osid=18158 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/orcl_iad1mc/ORCL/trace/ORCL_diag_18203_20210416231946.trc
2021-04-16T23:19:49.572337+00:00
License high water mark = 47
2021-04-16T23:19:51.051677+00:00
Dumping diagnostic data in directory=[cdmp_20210416231946], requested by (instance=1, osid=18158 (PMON)), summary=[abnormal instance termination].
2021-04-16T23:19:52.163859+00:00
Instance terminated by PMON, pid = 18158
2021-04-16T23:19:52.165526+00:00
Warning: 2 processes are still attach to shmid 393227:
(size: 36864 bytes, creator pid: 17553, last attach/detach pid: 18203)
2021-04-16T23:19:52.574262+00:00
USER (ospid: 27944): terminating the instance
2021-04-16T23:19:52.581511+00:00
Instance terminated by USER, pid = 27944
2021-04-16T23:20:04.771429+00:00

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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