Printable View
Hi,
I have a Server:
O.S: Linux RHEL AS 3.0 Update 5 Taroon
RAM: 16 GB
SGA: 2.8 GB
Oracle: 9.2.0.1.0
My Server gives me Out of Process Memory Error at times.
I am using Normal Kernel for Booting and not Huge Mem Kernel.
Please advise, if booting from HugeMem Kernel may solve the Problem?
use automatic pga allocation
Hi,
What does Automatic pga allocation exactly mean, is it oracle 9i feature or oracle 10g
Post the results of ulimit -a and let's take it from there...
Dear Ken,Quote:
Originally Posted by KenEwald
ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) 4
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 7168
virtual memory (kbytes, -v) unlimited
Any Updates from anybody ?
you should use SMP or Huge Mem Kernel if you have 16GB Memory
Hi,
Does it require, the Server to be booted with Huge Mem Kernel prior to oracle software installation
OR
is it Ok, if i do boot the Server now after oracle software installation, the latter i have tried and failed to resolve the problem.
first of all show us the EXACT error message
Hi,
When i successfully booted from Huge Mem Kernel and tried starting my database:
It gave me an error:
Unable to attach shared memory segment.
We tried to lower the SGA_max_size and tried again, but with same error.
Please advise
shows us your kernel parameters
Quote:
Originally Posted by pando
Hi,
Physical RAM Is 16GB
4P Intel(R) Xeon(TM) MP CPU 2.20GHz
---> /etc/sysctl.conf
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.sem = 250 32000 100 150
fs.file-max = 65536
----> /etc/security/limits.conf
oracle hard nofile 65536
oracle hard nproc 16384
---> SQL> show sga
Total System Global Area 1662588704 bytes
Fixed Size 452384 bytes
Variable Size 587202560 bytes
Database Buffers 1073741824 bytes
Redo Buffers 1191936 bytes
didnt you say your SGA is 2.8GB...?
show us the EXACT error and the error which appears in your alert.log
I Also, said, i have reduced the SGA now that i faced that problem.Quote:
Originally Posted by pando
WHile startup a database, I got the following error:
ORA-27123: unable to attach to shared memory segment
reduce to less than 1.6GB and try
Hi,Quote:
Originally Posted by pando
Tried making SGA < 1.6 GB and booted through Huge Mem Kernel, still same error:
print/show us the init.ora
Hi,Quote:
Originally Posted by yxez
Let me ask my question in a different way.
1. The question is, when i am booting the Linux using Normal Kernel, my database is taking upto 2.8GB of SGA max size. Now, inspite of 2.8 GB Sga, i am facing a problem of "Out of Memory Error".
Linux Kernel allocates memory to each and every request it recieves (malloc).
2. Now, i boot my Server using Huge Mem Kernel and the database itself refuses to start gives:
ORA-27123: unable to attach to shared memory segment
Now, if you are going to tell me go on decreasing SGA, that itself is not going to help my cause. Even if i do that, my database doesnt start under Huge Mem Kernel.
I think, i am more clear now.
Hi
Did your oracel instance shutdown properly ?
Can you try a reboot of the server is that a Viable option
Alternatively you can try and list the shared memory segments using ipcs -mt and remove them using ipcs -st
You might also want to
cd $ORACLE_HOME/rdbms/lib
genksms -s 0x50000000 >ksms.s (lower SGA base to 0x15000000)
make -f ins_rdbms.mk ksms.o (compile in new SGA base address)
make -f ins_rdbms.mk ioracle (relink)
if you had originally used genksms -s 0x15000000 >ksms.s to lower the SGA base to support greater then 1.7Gb SGA.
regards
Hrishy
yeah...ur memory might have been locked up by the previously
aborted instance