Upon startup of Linux database get ORA-27102: out of memory Linux-X86_64 error: 28: no space left on

Source: Internet
Author: User

 

Upon startup of Linux database get ORA-27102: out of memory Linux-X86_64 error: 28: no space left on device [ID 301830.1]

 

Applies:

Oracle Server-Enterprise Edition-version: 9.2.0.4 to 11.2.0.2-release: 9.2 to 11.2
Red Hat Enterprise Linux Advanced Server x86-64 (AMD opteron Architecture)
X86 64 bit (for Enterprise Linux only)
X86-64 SuSE/unitedlinux

Symptoms

When trying to increase the SGA to approach half available RAM with an oracle 64bit version on a Linux 64bit operating system, even though shmmax is set to match half the amount of RAM, you get the following error when trying to start the instance:

SQL> startup nomount
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device

Changes

Shmall is too small, most likely is set to the default setting of 2097152

$ CAT/proc/sys/kernel/Shmall
2097152

Cause

Shmall is the total amount of shared memory, in pages, that the system can use at one time.

Solution

Set Shmall equal to the sum of all the SGAs on the system, divided by the page size.

The page size can be determined using the following command:

$ getconf PAGE_SIZE
4096

For example, if the sum of all the SGAs on the system is 16 GB and the result of '$ getconf page_size' is 4096 (4 kb) then set Shmall to 4194304 pages

As the root user set the Shmall to 4194304 in the/etc/sysctl. conf file:

Kernel. Shmall = 4194304

Then run the following command:

# sysctl -p
# cat /proc/sys/kernel/shmall
4194304

Note:

The above command loads the new value and a reboot is not necessary

Switch back to being the Oracle user and retry the startup command.

 

 

 

 

From Oracle

Bytes -------------------------------------------------------------------------------------------------------

Blog: http://blog.csdn.net/tianlesoftware

Email: dvd.dba@gmail.com

Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)

Super DBA group: 63306533 (full); dba4 group: 83829929 dba5 group: 142216823

Dba6 group: 158654907 chat group: 40132017 chat group 2: 69087192

-- Add the group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, the application is rejected.

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.