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

advertisements

_____________________________________________________________________________________________________________________

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?

_____________________________________________________________________________________________________________________

Website Stats