RE: Oracle-xe memory issues on linux

From: Ruel, Chris <Chris.Ruel_at_lfg.com>
Date: Wed, 12 Mar 2014 13:02:44 +0000
Message-ID: <1AFD62082EEAF0448EF1815139687F131F712F1D_at_NC2PWEX504.us.ad.lfg.com>

I'll jump in and ask if you have checked/set your ulimits. From docs: http://docs.oracle.com/cd/E26370_01/doc.121/e26358/dbinstall.htm

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/pam_limits.so
8. session required pam_limits.so
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 17.fi

Chris Ruel * Oracle Database Administrator cruel_at_lfg.com<mailto:cruel_at_lfg.com> * Desk:317.759.2172 * Cell 317.523.8482

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Dunn Sent: Wednesday, March 12, 2014 8:51 AM
To: fuzzy.graybeard_at_gmail.com; oracle-l_at_freelists.org 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
www.sefas.com<http://www.sefas.com/>

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hans Forbrich Sent: 12 March 2014 12:47
To: oracle-l_at_freelists.org
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

/Hans

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

Any idea what the issue is?

ERROR:
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

John

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.**

--
http://www.freelists.org/webpage/oracle-l

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