Database shutdown fails: ORA-00449: background process 'MMON' unexpectedly terminated with error 448
(Doc ID 2111305.1)
Last updated on JULY 30, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
IBM AIX on POWER Systems (64-bit)
Symptoms
12.1.0.2 on AIX 7.1 TL4 SP1 (or AIX 7.2 TL0), database shutdown fails with ORA-00449:
Database alert.log:
Stopping background process SMCO
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process CJQ0
Stopping background process MMON
License high water mark = 4
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-449 signalled during: ALTER DATABASE CLOSE NORMAL...
The issue can also cause DBCA failure while creating a database.
In the case of installing/upgrading to 12.1.0.2 Grid Infrastructure, as installer creates GIMR database, it could fail during step of "Creating Container Database for Oracle Grid Infrastructure Management Repository" with error INS-20802:
Registering database with Oracle Grid Infrastructure
DBCA_PROGRESS : 5%
Copying database files
DBCA_PROGRESS : 7%
DBCA_PROGRESS : 9%
DBCA_PROGRESS : 16%
DBCA_PROGRESS : 23%
DBCA_PROGRESS : 30%
DBCA_PROGRESS : 41%
Creating and starting Oracle instance
DBCA_PROGRESS : 43%
DBCA_PROGRESS : 48%
DBCA_PROGRESS : 49%
DBCA_PROGRESS : 50%
DBCA_PROGRESS : 55%
DBCA_PROGRESS : 60%
DBCA_PROGRESS : 61%
DBCA_PROGRESS : 64%
Completing Database Creation
DBCA_PROGRESS : 68%
DBCA_PROGRESS : 79%
ORA-00449: background process 'MMON' unexpectedly terminated with error 448
ORA-01034: ORACLE not available
DBCA_PROGRESS : 80%
ORA-01034: ORACLE not available
ORA-01034: ORACLE not available
DBCA_PROGRESS : DBCA Operation failed.
OR
ORA-01012: not logged on
Error while executing "<GI_HOME>/rdbms/admin/dbmssml.sql". Refer to "<ORACLE_BASE>/cfgtoollogs/dbca/_mgmtdb/dbmssml0.log" for more details. Error in Process: <GI_HOME>/perl/bin/perl
DBCA_PROGRESS : DBCA Operation failed.
Changes
The issue is happening on AIX 7.1 TL4 SP1 (7100-04-01-1543) onward, there's no confirmed case for earlier TL.
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 |
Changes |
Cause |
Solution |
References |