Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 8.1.7 on HP-UX 11.00 - HPUX Error: 12: Not enough space

SOLVED
Go to solution
Pencho Denkov
Occasional Visitor

Oracle 8.1.7 on HP-UX 11.00 - HPUX Error: 12: Not enough space

Hello,
We have Oracle 8.1.7 on HP-UX 11.00.
After migration from 8.1.5 to 8.1.7
in listener.ora shows this 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

Can you help me to solve this problem ?
4 REPLIES
James R. Ferguson
Acclaimed Contributor
Solution

Re: Oracle 8.1.7 on HP-UX 11.00 - HPUX Error: 12: Not enough space

Hi:

Error-12 is a not enough memory error. You man need to configure more swapspace and or set 'swapmem_on=1'. Check you swap utilization with 'swapinfo -ta'. It is also possible that your appication may need more stack space. You may need to increase the kernel 'maxdsiz' ('maxdsiz_64bit' on 64-bit processors).

...JRF...
David Snider
Frequent Advisor

Re: Oracle 8.1.7 on HP-UX 11.00 - HPUX Error: 12: Not enough space

We have had numerous issues with Oracle 8.1.7 on HP-UX. I know that they have just re-released the 8.1.7.2.1 patch that may fix some of these issues. Our current problem is that we are using the max SGA size of 1.75 GB. When we try to shutdown, sqlplus says that the instance is shutdown but we are unable to startup the instance and get the same errors as you, when doing a ps, we see that there are still Oracle Processing going, and an ipcs -ma still shows shared memory for Oracle active. Once those processes finally die on their own, or we kill 'em.. the shared memory is released and we can start our instance back up.

Don't know if this helps.. just my two cents..
A. Clay Stephenson
Acclaimed Contributor

Re: Oracle 8.1.7 on HP-UX 11.00 - HPUX Error: 12: Not enough space

Hi:

The other common thing in Oracle that can cause an ENOMEM (12) is SHMMAX being set too small and thus shmget (shared memory get) fails. I would check that kernel tunable as well.

Clay
If it ain't broke, I can fix that.
Magdi KAMAL
Respected Contributor

Re: Oracle 8.1.7 on HP-UX 11.00 - HPUX Error: 12: Not enough space

Hi Pencho,

I had encountered this problem.

The solution is to increase your swap space.

Good formula is :

Swap space = 4 times the physical memory.


Have a look to the following book :

Essential System Administration
O'Reilly
By Aeleen Frisch

Chaptre : Managing paging space.

Magdi