DBCA Failed to Create Management Database MGMTDB due to ORA-27125 (Memory issues identified through CVU ) (Doc ID 2251798.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Linux x86-64
Linux x86
IBM: Linux on System z

Symptoms

During upgrade from 11.2.0.4 to 12.1.0.2, ran into memory issues when creating the MGMTDB repository during Grid infrastructure upgrade.

DBCA failed to create the management database MGMTDB and gets "ORA-27125: unable to create shared memory segment".

Continue to get the same error after adding memory to the node.

( _mgmtdb.log )

+OCR_VOTE has enough space. Required space is 1566 MB , available space is 76364 MB.
File Validations Successful.

Validation of server pool succeeded.
Registering database with Oracle Grid Infrastructure
DBCA_PROGRESS : 5%
Copying database files
DBCA_PROGRESS : 7%
DBCA_PROGRESS : 8%
ORA-27125: unable to create shared memory segment

DBCA_PROGRESS : 9%
DBCA_PROGRESS : 10%
ORA-01034: ORACLE not available

ORA-01034: ORACLE not available

DBCA_PROGRESS : DBCA Operation failed.

 

( trace.log )

[Thread-107] [ 2017-03-27 13:37:34.085 EDT ] [Util.getCRSHome:612] getCRSHome: ret=/u01/app/12.1.0/grid
[Thread-107] [ 2017-03-27 13:37:34.116 EDT ] [DatabaseAction.<init>:80] Created Database Action
[Thread-107] [ 2017-03-27 13:37:34.140 EDT ] [MgmtDatabaseImpl.create:326] Initialized db opt args
[Thread-107] [ 2017-03-27 13:37:34.140 EDT ] [MgmtDatabaseImpl.create:328] instName=-MGMTDB
[Thread-107] [ 2017-03-27 13:37:34.160 EDT ] [MgmtDatabaseImpl.create:338] Checking for ora.mgmtdb.type
[Thread-107] [ 2017-03-27 13:37:34.180 EDT ] [MgmtDatabaseImpl.create:367] Resource type already present
[Thread-107] [ 2017-03-27 13:37:34.203 EDT ] [MgmtDatabaseImpl.create:373] Updating database attributes
[Thread-107] [ 2017-03-27 13:37:34.204 EDT ] [MgmtDatabaseImpl.create:392] dbUniqueName = _mgmtdb
[Thread-107] [ 2017-03-27 13:37:34.204 EDT ] [Version.isPre:610] version to be checked 12.1.0.2.0 major version to check against 11
[Thread-107] [ 2017-03-27 13:37:34.204 EDT ] [Version.isPre:621] isPre.java: Returning FALSE
[Thread-107] [ 2017-03-27 13:37:34.204 EDT ] [Version.isPre:691] version to be checked 12.1.0.2.0 major version to check against 11 minor version to check against 2 patchset version to check against 2
....


[Thread-107] [ 2017-03-27 13:37:34.390 EDT ] [BasicStep.configureSettings:353] messageHandler being set=oracle.sysman.assistants.util.SilentMessageHandler@61efb003
[Thread-107] [ 2017-03-27 13:37:34.390 EDT ] [StepContext$ModeRunner.run:2873] ---- Progress Needed:=true
[Thread-107] [ 2017-03-27 13:37:34.390 EDT ] [BasicStep.execute:250] Executing Step : CLONE_DB_CREATION_RMAN_RESTORE
[Thread-107] [ 2017-03-27 13:37:34.390 EDT ] [StepErrorHandler.setFatalErrors:323] setting Fatal Error: ORA-01092
[Thread-107] [ 2017-03-27 13:37:34.390 EDT ] [StepErrorHandler.setFatalErrors:323] setting Fatal Error: ORA-01034
[Thread-107] [ 2017-03-27 13:37:34.390 EDT ] [StepErrorHandler.setFatalErrors:323] setting Fatal Error: ORA-03114
[Thread-107] [ 2017-03-27 13:37:34.390 EDT ] [StepErrorHandler.setFatalErrors:323] setting Fatal Error: ORA-12560
[Thread-107] [ 2017-03-27 13:37:34.390 EDT ] [StepErrorHandler.setIgnorableErrors:251] setting Ignorable Error: ORA-01109
[Thread-107] [ 2017-03-27 13:37:34.391 EDT ] [BasicStep.configureSettings:353] messageHandler being set=null
[Thread-107] [ 2017-03-27 13:37:34.391 EDT ] [Host.getRMANConnectionInfo:1171] Connect to Instance -MGMTDB
[Thread-107] [ 2017-03-27 13:37:34.393 EDT ] [BasicStep.execute:250] Executing Step : INSTANCE_CREATION

...

[Thread-107] [ 2017-03-27 13:37:35.544 EDT ] [SQLEngine.setSpool:2057] Setting Spool = /u01/app/grid/cfgtoollogs/dbca/_mgmtdb/CloneRmanRestore.log
[Thread-107] [ 2017-03-27 13:37:35.544 EDT ] [SQLEngine.setSpool:2058] Is spool appendable? --> true
[Thread-107] [ 2017-03-27 13:37:35.545 EDT ] [CloneRmanRestoreStep.executeImpl:323] _diag_hm_rc_enabled to false
[Thread-107] [ 2017-03-27 13:37:35.545 EDT ] [CloneRmanRestoreStep.executeImpl:358] Using control file: /u01/app/12.1.0/grid/assistants/dbca/templates/MGMTSeed_Database.ctl; sourceDBName: mgmtseed
[Thread-107] [ 2017-03-27 13:37:35.545 EDT ] [OsUtilsBase.copyFile:1505] OsUtilsBase.copyFile:
[Thread-107] [ 2017-03-27 13:37:35.570 EDT ] [OsUtilsBase.copyFile:1553] **write of file at destination complete...
[Thread-107] [ 2017-03-27 13:37:35.577 EDT ] [OsUtilsBase.copyFile:1588] **file copy status:= true
[Thread-122] [ 2017-03-27 13:37:35.656 EDT ] [BasicStep.handleNonIgnorableError:479] oracle.sysman.assistants.util.SilentMessageHandler@61efb003:messageHandler
[Thread-122] [ 2017-03-27 13:37:35.656 EDT ] [BasicStep.handleNonIgnorableError:480] ORA-27125: unable to create shared memory segment
:msg
[Thread-107] [ 2017-03-27 13:37:35.657 EDT ] [CloneRmanRestoreStep.executeImpl:399] update db alert log File
[Thread-107] [ 2017-03-27 13:37:35.658 EDT ] [CloneRmanRestoreStep.executeImpl:402] Clearing v$datafile_copy entries
[Thread-107] [ 2017-03-27 13:37:35.659 EDT ] [SQLEngine.done:2278] Done called
[Thread-107] [ 2017-03-27 13:37:35.659 EDT ] [SQLEngine.spoolOff:2124] Setting spool off = /u01/app/grid/cfgtoollogs/dbca/_mgmtdb/CloneRmanRestore.log
[Thread-107] [ 2017-03-27 13:37:35.659 EDT ] [CloneRmanRestoreStep.executeImpl:522] ORA-01034: ORACLE not available  

Changes

 GI upgrade from 11.2.0.4 to 12.1.0.2

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms