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
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.1.0.7 - Release: 10.2 to 11.1Information 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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle使用記憶體的錯誤,ORA-27102: out of memoryOracle記憶體
- 資料庫增加SGA,導致ORA-27102: out of memory錯誤資料庫
- 【ORACLE】ORA-27102: out of memory報錯的處理Oracle
- note the ORA-27102: out of memory errorError
- ORA-27102: out of memory故障解決
- 【ERROR】ORA-27102: out of memory 解決方法Error
- ORA-27102: out of memory解決辦法
- oracle啟動遭遇ORA-27102: out of memoryOracle
- ORA-27102 Out of Memory問題處理
- ORA-27102: out of memory 問題解決方法
- dbca -silent -responsefile 建庫由於tmpfs太小報錯ORA-27102: out of memory
- ORA-27102:out of memory Linux-X86_64 .Linux
- ORA-27102: out of memory以及相關係統引數
- ORA-27102: out of memory Linux Error: 28: No space left on deviceLinuxErrordev
- solaris上建立oracle資料庫出現:out of memory 錯誤Oracle資料庫
- ORA-27102:out of memory Linux-x86_64 Error: 12: Cannot allocate memory的處理LinuxError
- 啟動Oracle報錯ORA-27102: out of memory、Linux-x86_64 Error: 28: No space leftOracleLinuxError
- ORA-04030: out of process memory ...(initSubHeap:qk...)的錯誤解決
- Ora-27102: Out Of Memory: Linux Error: 12: [ID 401077.1]LinuxError
- OOM(Out Of Memory)OOM
- java out of memoryJava
- ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on deviceLinuxErrordev
- startup ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on deviceLinuxErrordev
- git post資料過大報錯-Out of memoryGit
- OOM--OUT OF MEMORYOOM
- nginx “504 Gateway Time-out”錯誤NginxGateway
- An out of memory error has occurred.Error
- OOM(Out Of Memory)是什麼?OOM
- Ubuntu Cannot allocate memory 錯誤解決方案Ubuntu
- 資料庫啟動出現ORA-27102錯誤資料庫
- Linux 6下EBS R12.2.4開啟報錯 OutOfMemory(out of memory)Linux
- MySQL過程報 Parameter number N is not an OUT parameter錯誤MySql
- Windows 錯誤程式碼Windows
- Windows Sockets錯誤碼Windows
- 解決MYSQL工具mysqldump 遇到 Out of memory 方法MySql
- 記一次安裝oracle遇到的ORA-27102錯誤Oracle
- mysql memory引擎引起的主從 1032 錯誤MySql
- 雲伺服器使用fastDFS錯誤,readtime out伺服器AST