My Oracle Support Banner

INS-35171 Reported While Creating AMM Enabled Database (Doc ID 1052555.1)

Last updated on OCTOBER 31, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Generic Linux

Symptoms

INS-35171 reported while creating Automatic Memory Management (AMM) enabled database with MEMORY_TARGET of 33GB on a dedicated database node with 64GB of physical memory and 16GB of swap space:

SEVERE: [FATAL] [INS-35171] Target database memory (33792MB) exceeds at least one of the selected nodes available shared memory (31725 MB).
  CAUSE: The total available shared memory on at least one of the selected nodes (31725 MB) was less than the chosen target database memory (33792 MB).
  ACTION: Enter a value for the target database memory less than 31725 MB.

A look at /proc/meminfo shows 48GB of memory is allocated for Hugepages:

cat /proc/meminfo
MemTotal:      67108864 kB      ## ==> 64GB
..
SwapTotal:     16777216 kB      ## ==> 16GB
..
HugePages_Total:  24576       ## ==> 48GB
HugePages_Free:     24576
Hugepagesize:     2048 kB

If MEMORY_TARGET is set to below 32GB (Physical Memory + Swap Space - Hugepages), database creation succeeds but may cause severe performance issue when database comes up if SGA is considerable bigger than physical available memory (Physical Memory - Hugepages) due to swap.



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
 Scalability RAC Community
References


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