Customer oracle Database startup error, operating linux, oracle11g due to the lock_sga parameter is set to true when the database restarts error ORA-27102: outofmemory
Customer oracle Database startup error, operating linux, oracle 11g because of the lock_sga parameter is set to true when the database restarts error ORA-27102: out of memory
Customer Oracle Database startup error, operating linux, oracle 11g because of the lock_sga parameter is set to true when the database restarts error ORA-27102: out of memory
SQL> startup nomount
ORA-27102: out of memory
Linux-x86_64 Error: 12: Cannot allocate memory
The reason is that the operation parameter is not set to allow memory of the size specified by sga to be locked.
[Root @ jyrac1 ~] # Ulimit-
Core file size (blocks,-c) 0
Data seg size (kbytes,-d) unlimited
Scheduling priority (-e) 0
File size (blocks,-f) unlimited
Pending signals (-I) 16384
Max locked memory (kbytes,-l) 32
Max memory size (kbytes,-m) unlimited
Open File (-n) 1024
Pipe size (512 bytes,-p) 8
POSIX message queues (bytes,-q) 819200
Real-time priority (-r) 0
Stack size (kbytes,-s) 10240
Cpu time (seconds,-t) unlimited
Max user processes (-u) 16384
Virtual memory (kbytes,-v) unlimited
File locks (-x) unlimited
There are two solutions:
1. ulimit-l unlimited is only valid for the current session before the instance is started.
[Root @ jyrac1 ~] # Ulimit-l unlimited
[Root @ jyrac1 ~] # Su-oracle
[Oracle @ jyrac1 ~] $ Ulimit-
Core file size (blocks,-c) 0
Data seg size (kbytes,-d) unlimited
Scheduling priority (-e) 0
File size (blocks,-f) unlimited
Pending signals (-I) 16384
Max locked memory (kbytes,-l) unlimited
Max memory size (kbytes,-m) unlimited
Open File (-n) 65536
Pipe size (512 bytes,-p) 8
POSIX message queues (bytes,-q) 819200
Real-time priority (-r) 0
Stack size (kbytes,-s) 10240
Cpu time (seconds,-t) unlimited
Max user processes (-u) 16384
Virtual memory (kbytes,-v) unlimited
File locks (-x) unlimited
[Oracle @ jyrac1 ~] $ Sqlplus/as sysdba
SQL * Plus: Release 11.2.0.1.0 Production on Fri Jun 6 12:20:26 2014
Copyright (c) 1982,200 9, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 313159680 bytes
Fixed Size 2212936 bytes
Variable Size 109054904 bytes
Database Buffers 197132288 bytes
Redo Buffers 4759552 bytes
SQL> show parameter lock_sga
NAME TYPE VALUE
----------------------------------------------------------------------------------------
Lock_sga boolean TRUE
-------------------------------------- Split line --------------------------------------
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian
-------------------------------------- Split line --------------------------------------
2. Add the following information to modify/etc/security/limits. conf:
Oracle soft memlock 10485760
Orcale hard memlock 10485760
10 Gb memory can be locked
SQL> startup nomount
ORACLE instance started.
Total System Global Area 730714112 bytes
Fixed Size 2216944 bytes
Variable Size 524291088 bytes
Database Buffers 197132288 bytes
Redo Buffers 7073792 bytes
In addition, when the lock_sga parameter is set to true, automatic memory management cannot be enabled.
SQL> show parameter memory