Tuesday, October 26, 2021

Database Startup issue after HUGEPAGES Changed

 Database Startup issue after HUGEPAGES Changed


Faced an issue after changing the DB memory parameters.

After the Parameters were changed, Database failed to start with the below error:


             "ORA-27106: system pages not available to allocate memory

              Additional information: 6048

              Additional information: 1"


If the Cloned Oracle DB won't start due to insufficient HugePages:
sqlplus / as sysdba
SQL> startup

ORA-27106 system pages not available to allocate memory

For Resolving the issue 

Issue: 

As part of Parameter changes, we changed the "USE_LARGE_PAGES" setting to "ONLY"


Solution:

 USE_LARGE_PAGES was be set to "ONLY".After reverting back "USE_LARGE_PAGES" parameter value to "TRUE" DB came up.

No comments: