DBCA fails with error ORA-27104
(Doc ID 1922934.1)
Last updated on JULY 01, 2024
Applies to:
Oracle Database Configuration Assistant - Version 12.1.0.1 and laterOracle Database - Standard Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
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
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 |