Error ORA-04030, Oracle and SAP is stoped

[Former Member]

Dear Gurus

09.00AM on sunday, Service SAP, Oracle on Production is stoped

I remoted to start manual Oracle and SAP, service same to be normal

SM21 show <br>

No free memory available in class PERM . Memory block ID "NTALXX", <br>

Storage request (1020000 bytes) failed <br>

Database error 4030 at EXE<br>

ORA-04030: out of process memory when trying to allocate<br>

Database error 12537 at CON<br>

And after that , all sap work process is stoped

I saw memory, swap by ORCA program on the same time

RAM 64GB, SWAP 104GB is gone, what heppen ?.

On sunday, only 4-5 users is used SAP and validate stucture on DB13 process start on 08.00PM

System:

Solaris 10, SAP ECC6.0, Oracle 10g, RAM 64 GB, SWAP 104GB

Please help me to investigate,

Thank

Edited by: Witoon Dachapitak on Mar 16, 2010 5:29 AM

Edited by: Witoon Dachapitak on Mar 16, 2010 5:31 AM

[former_member524429 · Accepted solution]

Hi,

No free memory available in class PERM . Memory block ID "NTALXX",
Storage request (1020000 bytes) failed

Its pointing to memory bottleneck issue. analyze the Usage of RAM and SWAP Memory.

Also tell about existing ulimit settings.(ulimit -a)

Any changes to Memory parameters (at SAP / ORACLE or at OS level) were done before or after the issue ?

Was your instance started with the non-default values set in its Instance Profile Parameter before ?

On sunday, only 4-5 users is used SAP and validate stucture on DB13 process start on 08.00PM

Background Jobs can also consume memory in this case.

Vale of abap/heap_area_nondia ? If it is not as per the recommendation then decrease its value. Please refer SAP Note 161626 - No memory available in class PERM or SHORT.

Also, Please refer the following SAP Notes to get more configuration information.

SAP Note 570375 - SAP on Sun Solaris: Swap Space and Paging

SAP Note 146289 - Parameter Recommendations for 64-Bit SAP Kernel

SAP Note 830576 - Parameter recommendations for Oracle 10g

SAP Note 425207 - SAP memory management, current parameter ranges

Regards,

Bhavik G. Shroff

[Former Member · Accepted solution]

Hi, Bhavik

I change sap parameter on september 2009,

refer by SAP Note 146289 because shortdump TSV_TNEW_PAGE_ALLOC_FAILED occured.

Before change:

ztta/roll_extension = 2000000000 (2GB) <br>

ztta/roll_extension_dia = 2000000000 (2GB) <br>

ztta/roll_extension_nondia = 2000000000 (2GB) <br>

ztta/roll_area = 6500000 <br>

abap/heap_area_dia = 2000000000 (2GB) <br>

abap/heap_area_nondia = 2000000000 (2GB) <br>

abap/heap_area_total = 2000000000 (2GB) <br>

em/initial_size_MB = 40960 <br>

em/max_size_MB = 4092 <br>

em/address_space_MB = 4092 <br>

After Change (Current)

ztta/roll_extension = 4000000000 (4GB) <br>

ztta/roll_extension_dia = 4000000000 (4GB) <br>

ztta/roll_extension_nondia = 4000000000 (4GB) <br>

ztta/roll_area = 3000000 ( 3000000 on 64 bit) <br>

abap/heap_area_dia = 0 (Unlimited) <br>

abap/heap_area_nondia = 0 (Unlimited) <br>

abap/heap_area_total = 0 (Unlimited) <br>

em/initial_size_MB = 64000 <br>

em/max_size_MB = 100000 <br>

em/address_space_MB = 4096 <br>

This buffer parameter I change by monitor SWAP usage on ST02 and increase 15-50% 2 time on last year.

rsdb/ntab/ftabsize 300000 to 400000 <br>

abap/buffersize 900000 to 1750000 <br>

rsdb/cua/buffersize 30000 to 40000 <br>

zcsa/presentation_buffer_area 20000000 to 40000000 <br>

zcsa/table_buffer_area 100000000 to 150000000 <br>

rtbb/buffer_length 60000 to 100000 <br>

rsdb/obj/buffersize 40000 to 80000 <br>

Change

On sunday, only 4-5 users is used SAP and validate stucture on DB13 process start on 08.00PM

To

On sunday, only 4-5 users is used SAP and validate stucture on DB13 process start on 08.00AM

Thank for advise

Edited by: Witoon Dachapitak on Mar 16, 2010 7:09 AM

Edited by: Witoon Dachapitak on Mar 16, 2010 7:13 AM

[Former Member · Accepted solution]

Hi, are your Oracle on same host ? Look's very interst you have 64GB at all and for example

the em/initial_size_MB = 64000 (same 64 GB) if Oracle on same host look's no so good, but it's not so so important

as this 3 :

abap/heap_area_dia = 0 (Unlimited)

abap/heap_area_nondia = 0 (Unlimited)

abap/heap_area_total = 0 (Unlimited)

You are not control the Private memory on your server ....

Who advised you to set parameters such ?

http://help.sap.com/erp2005_ehp_04/helpdata/EN/02/9626da538111d1891b0000e8322f96/frameset.htm

http://help.sap.com/erp2005_ehp_04/helpdata/EN/02/96279d538111d1891b0000e8322f96/content.htm

Regards.

[Former Member · Accepted solution]

Hi, Sergo

SAP and Oracles is running on the same host,

about "em/initial_size_MB" that you mean = 64GB - ( Oracle +Solaris)

Thank for advise

[Former Member · Accepted solution]

You set the em/initial_size_MB to 64000 MB (~64 gb) , are you read how you can use this parameter ?

Only for example if you have 64 GB main memory ORACLE SGA are 24(for example ~ 40%) , then MAX you can set th 64 -24 40Gb, but you need memory also for OS, sap buffers, paging buffers in memory and reserve for any extremal situation, and ₃₀35 GB are remains for em/initial_size_MB . But i'ts only approximation, .....

Try to check for example now how much Storage you have with your existing configuration (This value does not account for memory consumption by Database) ... --> ST02 --> Detail Analysis meny --> Storage ....

P.S. in any case first set the abap/heap_area***** parameters not unlimit up to 1 TB (0).

Regards.

[Former Member · Accepted solution]

Thank Bhavik , Sergo

Proplem is solved

I saw my proplem on sap help.

"Swap Space Bottleneck During SAP Operation"

http://help.sap.com/erp2005_ehp_04/helpdata/EN/34/d9c8b9c23c11d188b40000e83539c3/frameset.htm

Best Regards,

Edited by: Witoon Dachapitak on Mar 19, 2010 4:13 AM