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

Oracle 9i+HP-UX Error: 12: Not enough space

Oracle 9i+HP-UX Error: 12: Not enough space

I am having problem with Oracle 9i database which is installed in a A-class server running on HP-UX 11i(64 bit).
There are 2 instances running and both getting started and while it running it is getting the following error.
ORA-27102 error "out of memory"
HP-UX Error: 12: Not enough space

This machine / kernal parameters as follows.

Physical memory- 1GB
Swap - 2GB
SHMMAX - 4GB
dbc_max_pct- 10%


total SGA is 400MB.
Is there any parameters to be configured/modified to resolve it.
To get out of a difficulty, one usually must go through it
10 REPLIES
Ravi_8
Honored Contributor

Re: Oracle 9i+HP-UX Error: 12: Not enough space

Hi,

check the oracle file system, whether it has enough space left in it (bdf),
second issue is the swap. try to increase it by another 500MB
never give up
T G Manikandan
Honored Contributor

Re: Oracle 9i+HP-UX Error: 12: Not enough space

It is time to use

#swapinfo -ta

to check the memory and swap usage.
I think the system is running out of memory.
If that is the case you should increase the swap to equal the amount of memory


Revert
T G Manikandan
Honored Contributor

Re: Oracle 9i+HP-UX Error: 12: Not enough space

check the trace file for any hint.


Thanks
Anthony deRito
Respected Contributor

Re: Oracle 9i+HP-UX Error: 12: Not enough space

Re: Oracle 9i+HP-UX Error: 12: Not enough space

This is clearly a kernel and sizing issue.

Consider resizing your shared memory parameters in the system file. (shmmax)

Consider resizing all your SGA parameters (large_pool_size etc)

Good luck.

Kim
Rammig Claus
Frequent Advisor

Re: Oracle 9i+HP-UX Error: 12: Not enough space

Hi Nuwan,

is your oracle 9 application a 32 bit application?
A 32 bit application can handle only
"4GB-1Byte"
shared memory.

So the shmmax parameter should be set lower (at least to 1 Byte).
With hpux 11i you don't need a reboot to change the shmmax.

Best regards ...
Claus
No risc no fun
Wilfred Chau_1
Respected Contributor

Re: Oracle 9i+HP-UX Error: 12: Not enough space

what do you set for your maxdsiz?

try type ulimt -a (in posix shell) and see how much is set for data. or use kmtune |grep maxdsiz (you may need to convert hex to dec)

You may want to up that to a higher value.
Steven E. Protter
Exalted Contributor

Re: Oracle 9i+HP-UX Error: 12: Not enough space

Its kernel time.

metalink.oracle.com has a tool called rda. It checks the kernel for an existing instance and lets you know the minimums.

Download it.

Run it.

Exceed the kernel minimums by as far as practical.

Thats step 1.

Step two is a recent quality pack from HP.

Step 3 is the HP patch list for HP-Ux 11.11, which I have attached.

Next step is make sure java is patched appropriatelly.
http://www.hp.com/products1/unix/java/infolibrary/patches.html

Make sure the database is shut down and backed up prior to installing the java patches. They REALLY should go in before database installation.

We are currently suffering from a problem with the java objects on the db corrupted by one of the patches. We are going to have to export, drop the instance, create a new db and import, then add the java apps back.

Fortuneately its not a production db.

Why do the patches in spite of our trouble, which happenend right after the java patch? Because Oracle won't support you without current patches.

In fact the patch install might have just brought a problem to light that eventually would have bit us hard anyway.

Steve

Attached is the current patch list for all supported HP-UX from metalink.


Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com

Re: Oracle 9i+HP-UX Error: 12: Not enough space

Hi all,
Thanks for your replys to my issue. How ever so far we have identified this issue as a oracle 9i (9.2.0.1) bug. Because this is a known problems for most of the UNIX platform users of Oracle 9i.
As a solution some people have installed the new oracle patch (9.2.0.2). It has worked for them. I am tring to update the version and see.
Oracle each process uses about 70 Mb of memeory in the Oracle 9i version 9.2.0.1. This should be the problem.

Thanks again for every one.
To get out of a difficulty, one usually must go through it
T G Manikandan
Honored Contributor

Re: Oracle 9i+HP-UX Error: 12: Not enough space

It generally indicates that the new versions client spawns a Oracle process worth using around xxMB on the Oracle server.

So it is that the problem is due to the insufficient swap or memory.

The problem was that.
Updating the latest patches ultimately resolves or reduces the bugs.

Thanks