Cause of error ORA-04030: out of process memory?

Question

Oracle

Good afternoon.

The question is not as simple as it might seem at first sight. We have a Solaris x64 environment. There is one (at least there should be one) Orakla instance.

RAM: 132Gb

We are trying to set the following parameters:

= DB_CACHE_ADVICE 'OFF'
NLS_LENGTH_SEMANTICS = CHAR
MEMORY_MAX_TARGET = 0
MEMORY_TARGET = 0
SGA_MAX_SIZE = 10G
SGA_TARGET = 10G
PGA_AGGREGATE_TARGET = 4GB
DB_CACHE_SIZE = 5G
SHARED_POOL_SIZE = 1G
SHARED_POOL_RESERVED_SIZE = 35M
RESULT_CACHE_MAX_SIZE = 25M
DB_KEEP_CACHE_SIZE = 100M

But after restarting the server does not start, crashing with the error ORA-04030: out of process memory when trying to allocate 256 bytes (Heap0: KGL,kglob).

What was googled was immediately checked:

[email protected] $ prctl -n project.max-shm-memory -i project default
project: 3: default
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
project.max-shm-memory
privileged 31.4GB - deny -
system 16.0EB max deny

[email protected] [UAT Active] /root# swap -l
swapfile dev swaplo blocks free
/dev/swap 0.0 16 76523504 76523504

[email protected] [UAT Active] /root# prtconf |grep -i mem
prtconf:
Memory size: 131072 Megabytes

[email protected] server1 [UAT Active] /root# cat /etc/system
set noexec_user_stack=1
set noexec_user_stack_log=1

Limits checked:

server1 [UAT Active] /root# ulimit -H -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) 65536
vmemory(kbytes) unlimited

Tell me the way where to dig! Quite a stupor.

Answer 1

I will clarify. I'll add it here.
The problem is further complicated by the fact that the server belongs to the British and they do not allow us to steer on it. We send them commands - they execute - they send the result.

Answer 2

ulimit from under oracle
[oracle][email protected] $ ulimit -Ha
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) 65536
vmemory(kbytes) unlimited

Answer 3

Version: Oracle 11.1

Answer 4

I'll leave the answer here. Suddenly someone will come in handy.
Everything works if you do not set the parameter
DB_KEEP_CACHE_SIZE = 100M

Answer 5

Why - xs. Clearly an Oracle bug.

Answer 6

I got the same error. Try decreasing PGA_AGGREGATE_TARGET and/or increasing SWAP.