ORA-27125: unable to create shared memory segment Linux-x86_64 Error: 2: No such file or directory


Error Description:
Database startup failed with following error after increasing the value for SGA_TARGET and SGA_MAX_SIZE
ORA-27125: unable to create shared memory segment

Linux-x86_64 Error: 2: No such file or directory

Alert log shows following error details.

Starting ORACLE instance (normal)
****************** Huge Pages Information *****************
Huge Pages memory pool detected (total: 36600 free: 6709)
Huge Pages allocation failed (free: 32026 required: 4197)
Startup will fail as use_large_pages is set to "ONLY"

Solution Description
You can check the current Huge page detail for the server using following command.
grep Huge /proc/meminfo
HugePages_Total: 36600
HugePages_Free:   6709
HugePages_Rsvd:   4674
Hugepagesize:     2048 kB

Option a
Reset the value for the parameter use_large_pages to default (TURE) and start the database.

Option b
Increase the value for vm.nr_hugepages in /etc/sysctl.conf file and bounce the unix server. Set the value for the parameter vm.nr_hugepages at least 36226(32026+4197) or more. This option/solution requires the server bounce.

It help you to solve this error. Is it helpful?
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google