ORA-27102: outofmemoryLinux-x86_64Error: 12: Cannotalloc

Source: Internet
Author: User
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.