topic Re: Unable to Allocate extra memory -- Oracle11i ERP in Operating System - HP-UX

Unable to Allocate extra memory -- Oracle11i ERP

Basheer_2 — Tue, 09 May 2006 16:02:40 GMT

maxdsiz is set to 2GB
ulimit is 2GB
oracle sent a c program, after running it gives
this mesg.
(our mem is 24GB)

Unable to Allocate extra memory..
Due To : Not enough space
Counter : 6755581
Total memory allocated : 870836

Any way to fix this.
Thanks

Re: Unable to Allocate extra memory -- Oracle11i ERP

Steven E. Protter — Tue, 09 May 2006 16:17:33 GMT

Shalom,

Need to know a few things.

Oracle 11i ERP. 32 bit or 64 bit.

if its 32 bit you may have problems if it can't use HP-UX memory windows.

If its 64 bit,you have been adjusting the wrong parameter, maxdsiz has a 64 bit equivalent on 64 bit systems.

You also fail to mention the operating system of the HP system you are running on.

Always include OS, most recent patch package, hardware basics and system model type.

Makes it much easier to help.

:-)

SEP

Re: Unable to Allocate extra memory -- Oracle11i ERP

Basheer_2 — Tue, 09 May 2006 16:29:07 GMT

Thanks Steve

11.23
RP7420
cpus = 8
ram = 24GB
app = MFG module

oracle 11i ERP 11.5.10.2 and DB 9.2.0.6
I think its 64 bit.
also dont understand why our DBAs/oracleerp is running 32 Bit.

Re: Unable to Allocate extra memory -- Oracle11i ERP

Bill Hassell — Tue, 09 May 2006 17:19:22 GMT

You need to identify the actual program giving the error message. Oracle may be 64bit but the C program may have been compiled as a 32bit program. Assuming that the C program is the problem, did you compile it with 64bit flags? If so, then the maxdsiz_64 value is too small. maxdsiz is for 32bit programs and is typically set to 500 - 2000 megs. But maxdsiz_64 should be much loarger, perhaps 4 to 8 Gb.

Now for 32bit programs, there are a *LOT* of limitations for allocating local memory. You've already handled maxdsiz and ulimit, but when the program is compiled, unless the program was compiled with EXEC_MAGIC flags, you'll never get more than 960 megs. The error (unfortunately) says "not enough space" but it really means: 32bit quadrant 2 is used up with no alternate mapping. If you compile the program with the flags -Wl -N then the 1st and second quadrants can be used for data and you'll get up to 1700 megs.

Now all of this assumes that the program is supposed to be 32bits. If not, recompile it to 64bits with +DD64 and make maxdsiz_64 large enough to accomodate the program's requirements (you did get a description of the program's special needs, right?)

Re: Unable to Allocate extra memory -- Oracle11i ERP

Steven E. Protter — Tue, 09 May 2006 18:35:14 GMT

Thanks for the additional information.

Your system is 64 bit only and I'd love to work with a box that fast some day.

The database is probably 64 bit, but you need to check because that release of Oracle is available in 32 bit or 64 bit mode for most platforms.

I suspect based on your second post that the 32 bit version is insalled. For performance and many other reasons, I'd rip it out and replace it with the 64 bit version. You'll be happy with the results.

Oracle 11i ERP seems to come in two flavors as well. I was amazed in late 2004 when we were testing Oracle ias10G that it was possible to do (and may have been) 32 bit for HP-UX 11i. I think thats becasue the OS will install on 32 bit machines. I've got it running on two here in my apartment.

You have great 64 bit hardware. I'm envious of it to be honest. I strongly recommend you determine the versions of the software you have and go with 64 bit versions.

If you got the physical media, you will find that sometimes the bit size is on the cd or case/cover.

SEP

Re: Unable to Allocate extra memory -- Oracle11i ERP

Basheer_2 — Wed, 10 May 2006 10:35:13 GMT

Thanks
Bill/Steve

maxdsiz = 2GB
maxdsiz = 4GB

I will try compiling that c program with 64 bit.

Re: Unable to Allocate extra memory -- Oracle11i ERP

Basheer_2 — Wed, 10 May 2006 10:36:06 GMT

Ooops

maxdsiz = 2GB
2nd one is maxdsiz_64bit = 4GB

Re: Unable to Allocate extra memory -- Oracle11i ERP

Basheer_2 — Wed, 10 May 2006 10:38:57 GMT

Bill

can you tell me the 64bit flags to compile that c program.

Re: Unable to Allocate extra memory -- Oracle11i ERP

Bill Hassell — Wed, 10 May 2006 12:02:52 GMT

+dd64 will get you a 64bit program, assuming you have the HP aCC compiler. Note that if this program references Oracle's SGA or otherwise needs to access Oracle data directly in memory, the program must match Oracle's "bitness". Oracle will store integers based on the data type associated with the program (32 or 64 bits). All of this should be well documented in the program's README file. If the docs do not state anything, the program may not access Oracle data directly in memory.