LOCK_SGA on Windows fails with ORA-27102
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 10.1.0.2 [Release 9.2 to 10.1]
Microsoft Windows (32-bit)
Microsoft Windows Itanium (64-bit)
***Checked for relevance on 30-Apr-2012***
In order to lock the SGA in physical memory, the DBA has set the parameter LOCK_SGA in the init.ora. While trying to open the database, the STARTUP command fails with ORA-27102.
SQL*Plus: Release 184.108.40.206.0 - Production on Mon May 24 14:01:46 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup pfile = 'D:\oracle\admin\db9205\pfile\init.ora'
ORA-27102: out of memory
OSD-00025: Message 25 not found; product=RDBMS; facility=SOSD
O/S-Error: (OS 8) Not enough storage is available to process this command.
The parameter LOCK_SGA has been set in the init.ora file
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms