windows 32位ORA-27102: out of memory錯誤

warehouse發表於2012-07-17

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




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 :

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 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
64-Bit (x64) where the bug is fixed.

References

- 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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章