RE: Oracle-xe memory issues on linux
- From: "Ruel, Chris" <Chris.Ruel@xxxxxxx>
- To: "JDunn@xxxxxxxxx" <JDunn@xxxxxxxxx>, "fuzzy.graybeard@xxxxxxxxx" <fuzzy.graybeard@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 12 Mar 2014 13:02:44 +0000
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
1. 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
1. 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
11. if [ $SHELL = "/bin/ksh" ]; then
12. ulimit -p 16384
13. ulimit -n 65536
14. else
15. ulimit -u 16384 -n 65536
16. fi
17.fi
Chris Ruel * Oracle Database Administrator
cruel@xxxxxxx<mailto:cruel@xxxxxxx> * Desk:317.759.2172 * Cell 317.523.8482
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of John Dunn
Sent: Wednesday, March 12, 2014 8:51 AM
To: fuzzy.graybeard@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Hans Forbrich
Sent: 12 March 2014 12:47
To: oracle-l@xxxxxxxxxxxxx
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.**
Other related posts:
