windows 下ORA-27102: out of memory错误_ora27102 out of memory windows

---

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.1.0.7 - Release: 10.2 to 11.1
Information in this document applies to any platform.

Symptoms

Instance fails to start with the errors:

ORA-27102: out of memory
OSD-00025: additional error information
O/S-Error: (OS 1453) Insufficient quota to complete the requested service.

LOCK_SGA is set to TRUE.

Cause

The cause of this problem has been identified in  Bug 7687937:

A ORA-27102 error can occur on startup when the LOCK_SGA initialization parameter is set to true for a large SGA size. Here the ORA-27102 occurs due to failure of VirtualLock with an error, which indicates that there is not enough minimum working set to lock the memory .

Solution

1. upgrade to 11.2 release where  Bug 7687937 is fixed

2. or use the workaround setting the following in the registry:

ORA_WORKINGSETMIN = Total SGA being locked + overhead (0.3% or higher of total SGA) in 
MBytes or check if it's available 10.2.0.4.0 Patch bundle 21 (10.2.0.4.21P) 32-Bit  Patch 8541774 
64-Bit (x64)  Patch 8541781 where the bug is fixed.