HP-UX Error: 12: Not enough space

[Itanium2_1]

How do I resolve the following error, when connecting from a client after 170 connections are reached, to a 9i Release 2 db..

> > ORA-27102 error "out of memory"
> > HP-UX Error: 12: Not enough space

When I look in the listener.ora log files, I see the following error..

TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
HPUX Error: 12: Not enough space

The input of swapinfo -tm is as follows :
root@atlhp1 >swapinfo -tm
Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 4096 0 4096 0% 0 - 1 /dev/vg00/lvol2
reserve - 158 -158
memory 19712 623 19089 3%
total 23808 781 23027 3% - 0 -


Thx much in advance

[Rajeev Tyagi]

Saty,

It is problem with your kernel parameters. You need to increase your shmmax kernel parameter.

Rajeev

[pap]

Hi Check the file system sizes or else give the bdf output.

ALso check the database spaces.

Thanks,

-pap.

[Clemens van Everdingen]

Hi,

You should also check these threads:

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xd0e9d211e18ad5118ff10090279cd0f9,00.html

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x90c153921f1ad5118fef0090279cd0f9,00.html

Also check your dbc_max_pct kernel parm.
Possible on default value of 50% should be lowered for example to 5 or 10%

C.

[James R. Ferguson]

Hi:

Error 12 (out-of-memory) generally points to insufficient swap or too small a 'masxdiz'.

You appear to need more stack space. You can increase the kernel 'maxdsiz' ('maxdsiz_64bit' on 64-bit processors) to affect this.

Regards!

...JRF...

[MANOJ SRIVASTAVA]

Hi Saty

from the forum:

ENOMEM can be caused by maxdsiz being setting too small but this sounds more like not enough swapspace or swapmem_on needing to be enabled.


Manoj Srivastava

[David Burgess]

Hi,

Take a look at http://dbforums.com/archive/49/2001/12/1/216039

and
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x5694c3d7fb78d4118fef0090279cd0f9,00.html

and

http://groups.google.com/groups?q=HPUX+%2BError+%2B12&hl=en&selm=20000309002643.01939.00002836%40ng-dc1.aol.com&rnum=2

It seems to point to shmmax. What value do you have for this?

A rule of thumb is to double it!

HTH

Dave.

[Rita C Workman]

Here's one more suggestion...on the Oracle side:

You could reduce your 'large_pool_size' value in your init.ora


I remember this was a suggestion from Oracle on the 27102 error....

Just a thought,
Rita

[Vivek_9]

Hi guys,

me too gets this error

HP-UX Error: 12: Not enough space

There Swap space is : 1 gig

SHMMAX = maximum physical memory available ( 512 Meg).

Reboot doesnt work for me .

There are no other apps on this box and only one Oracle instance.

Regards

[T G Manikandan]

This is a very old theard.
Please raise a new thread.

The problem should be the shared memory kernel parameter.


Thanks