[OCI] After startup of database Instance, the Instance terminated by PMON process with error 12752
(Doc ID 2769706.1)
Last updated on SEPTEMBER 10, 2023
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A and laterInformation 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"
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
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 |