[FATAL] [DBT-11211] 19c DBCA: The AMM option is not allowed while the physical memory is greater than 4GB

This article explains the steps to change the Automatic Memory Management option to the Automatic SHARED Memory Management option within the response File.

1. Oracle Error “physical memory is greater than 4GB”:

While installing an Oracle database 19c, on Oracle Linux 7 and while the physical memory is greater than 4GB.

$ /u01/app/oracle/product/19.3.0.0/dbhome_1/bin/dbca -silent -createDatabase -responseFile /tmp/dbca19c.rsp

[FATAL] [DBT-11211] The Automatic Memory Management option is not allowed when the total physical memory is greater than 4GB.
    CAUSE: The current total physical memory is 11GB.

2. Solution: Change Oracle memory management from AMM to ASMM in the response file:

Step 1: Update the initialization parameters:

From

 initParams=……,memory_target=800MB,….

To

 initParams=……,SGA_TARGET=600MB,PGA_AGGREGATE_TARGET=200MB….

Step 2: Comment the memory Percentage

From:

 memoryPercentage=40

To

# memoryPercentage=40

Step 3: Update the option automatic Memory Management:

From

 automaticMemoryManagement=true

To

 automaticMemoryManagement=false

Step 4: Run the creation steps again.

$ /u01/app/oracle/product/19.3.0.0/dbhome_1/bin/dbca -silent -createDatabase -responseFile /tmp/dbca19c.rsp

 [WARNING] [DBT-09251] The listener configuration is not selected for the database. EM DB Express URL will not be accessible.
    CAUSE: The database should be registered with a listener in order to access the EM DB Express URL.
    ACTION: Select a listener to be registered or created with the database.
 Prepare for db operation
 10% complete
 Copying database files
 40% complete
 Creating and starting Oracle instance
 42% complete
 46% complete
 50% complete
 54% complete
 58% complete
 60% complete
 Completing Database Creation
 66% complete
 70% complete
 Executing Post Configuration Actions
 100% complete
 Database creation complete. For details check the logfiles at:
  /u01/app/oracle/cfgtoollogs/dbca/orcl.
 Database Information:
 Global Database Name:orcl
 System Identifier(SID):orcl
 Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.

Conclusion:

Oracle 19c: Oracle does not support AMM management when the physical memogy is more than 4Gb.