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"
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:
Post a Comment