RE: Oracle-xe memory issues on linux

From: Ruel, Chris <>
Date: Wed, 12 Mar 2014 13:02:44 +0000
Message-ID: <>

I'll jump in and ask if you have checked/set your ulimits. From docs:

Setting Shell Limits for the Oracle User

  1. To improve the performance of the software, you must increase the shell limits for the oracle user. Add the following lines to the /etc/security/limits.conf file:
  2. oracle soft nproc 2047
  3. oracle hard nproc 16384
  4. oracle soft nofile 1024
  5. oracle hard nofile 65536
  6. If not already present, add the following lines to the /etc/pam.d/login file:
  7. session required /lib64/security/
  8. session required
  9. Depending on the oracle user's default shell, you need to make changes to it. For the Bourne, Bash, or Korn shell, add the following lines to the bottom of the /etc/profile file: 10.if [ $USER = "oracle" ]; then
  10. if [ $SHELL = "/bin/ksh" ]; then
  11. ulimit -p 16384
  12. ulimit -n 65536
  13. else
  14. ulimit -u 16384 -n 65536
  15. fi

Chris Ruel * Oracle Database Administrator<> * Desk:317.759.2172 * Cell 317.523.8482

From: [] On Behalf Of John Dunn Sent: Wednesday, March 12, 2014 8:51 AM
To:; Subject: RE: Oracle-xe memory issues on linux

This is what I have :

# Controls the maximum shared segment size, in bytes
kernel.shmmax = 68719476736

# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 4294967296
# Oracle Database 11g Express Edition Recommended Values
kernel.sem = 250 32000 100 128
fs.file-max = 6815744

John Dunn
Product Consultant
Sefas Innovation Limited.
Tel: + 44 (0) 117 910 0529<>

From: [] On Behalf Of Hans Forbrich Sent: 12 March 2014 12:47
Subject: Re: Oracle-xe memory issues on linux

Is this a new installation or has it worked before?

First guess is that you do not have the shared memory and semaphores configured - should be in /etc/sysctl.conf


On 12/03/2014 4:51 AM, John Dunn wrote:
I am getting the following error on RHEL 5.4 Oracle XE

Any idea what the issue is?

ORA-01034: ORACLE not available
ORA-27102: out of memory

Linux-x86_64 Error: 12: Cannot allocate memory
Additional information: 1
Additional information: 786432
Additional information: 8

Process ID: 0
Session ID: 0 Serial number: 0


Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**

Received on Wed Mar 12 2014 - 14:02:44 CET

Original text of this message