windows 32位ORA-27102: out of memory错误

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

oracle的解释是触发了oracle的bug

[@more@]

metalink上解释：

ORA-27102 OSD-00025 O/S-Error: (OS 1453) When Lock_sga is Set to True [ID 1292225.1]

2011-03-16 13:51:15| 分类： Oracle | 标签： |字号大中小 订阅

		Modified 09-FEB-2011 Type PROBLEM Status PUBLISHED

In this Document
Symptoms
Cause
Solution
References

---

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

2. 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.

References

BUG:7687937 - ORA-27102 OCCURS ON STARTUP WHEN LOCK_SGA=TRUE

出现这个错误之后需要把windows服务中的oracle服务停止然后重新启动一下之后才能启动oracle，但是使用一段时侯之后没有规律的再次出现ORA-27102，查了一下发现时由于LOCK_SGA is set to TRUE的缘故。

SQL> show parameter sga
ORA-01034: ORACLE not available

SQL> startup
ORA-03113: end-of-file on communication channel
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

C:>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 17 19:27:37 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 209715200 bytes
Fixed Size 1248116 bytes
Variable Size 104858764 bytes
Database Buffers 96468992 bytes
Redo Buffers 7139328 bytes
Database mounted.
Database opened.
SQL> show parameter sga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean TRUE
pre_page_sga boolean FALSE
sga_max_size big integer 200M
sga_target big integer 200M
SQL> alter system set lock_sga=false;
alter system set lock_sga=false
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

SQL> alter system set lock_sga=false scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 209715200 bytes
Fixed Size 1248116 bytes
Variable Size 104858764 bytes
Database Buffers 96468992 bytes
Redo Buffers 7139328 bytes
Database mounted.
Database opened.
SQL> show parameter sga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 200M
sga_target big integer 200M
SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/19602/viewspace-1058834/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/19602/viewspace-1058834/