DBCA fails with error ORA-27104 (Doc ID 1922934.1)

Last updated on JULY 01, 2024

Applies to:

Symptoms

Running DBCA in silent mode, the following error is seen:
ORA-27104: system-defined limits for shared memory was misconfigured

The alert log shows:

Tue Sep 02 09:30:39 2014
Starting ORACLE instance (normal)
Tue Sep 02 09:30:39 2014
CLI notifier numLatches:3 maxDescs:519
Tue Sep 02 09:30:39 2014
System cannot support SGA size of 12650020864 bytes
Tue Sep 02 09:30:39 2014
Current maximum shared memory configured 8589934592 bytes
Tue Sep 02 09:30:39 2014
Increase the system shared memory size to atleast 12650020864 bytes

DBCA Trace Log:
[Thread-697] [ 2012-06-15 01:16:13.762 PDT ] [ValidationPage.check:1473]  
cluster check msg: Info Cluster Verification check "OS Kernel Parameter:
semmni" succeeded on nodes: rwsal02,rwsal01.
[Thread-697] [ 2012-06-15 01:16:13.762 PDT ] [ValidationPage.check:1473]  
cluster check msg: Info Cluster Verification check "OS Kernel Parameter:
shmmax" succeeded on nodes: rwsal02,rwsal01.
[Thread-697] [ 2012-06-15 01:16:13.763 PDT ] [ValidationPage.check:1473]  
cluster check msg: Info Cluster Verification check "OS Kernel Parameter:
shmmni" succeeded on nodes: rwsal02,rwsal01.
[Thread-697] [ 2012-06-15 01:16:13.763 PDT ] [ValidationPage.check:1473]  
cluster check msg: Info Cluster Verification check "OS Kernel Parameter:
shmall" succeeded on nodes: rwsal02,rwsal01.
<====memory-related ckeck are succeed.

<====but report error ORA-27104 here.
[Thread-1384] [ 2012-06-15 01:17:09.803 PDT ]
[BasicStep.handleNonIgnorableError:470]  ORA-27104: system-defined limits for
shared memory was misconfigured

the default SGA was computed to 22 GB But, the .dbc file is only asking for a 2Gb SGA.

Changes

Cause

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