Internet Developer Suite issues

[soumya]

Hi Erman,

Good morning.

I have few issues which are bugging me lately. I researched on this for quite a long time but not able to find any solution for this.  Before explaining the problem let me describe the environment


DB-11.2.0.4
App: Oracle Developer suite 10.1.2.3
Mem:64Gb
App Server OS: Windows Server 2012 R2
DB Server OS: Windows Server 2012 R2

Issue 1 .

we often see java.lang.Outofmemory error whenever the number of concurrent users count increases.
So to avoid this we exceeded the java heap memory setting using  java -Xms512m -Xmx1200m in startinst.bat file.




Issue 2.
So after increasing the heap memory we are now facing "Too many open files" error in browser



Now we are unable to find any proper solution for this error as our environment is Windows. As most of the times by increasing  ulimit value such error gets resolved but in our case the environment is windows.



Issue 3 . Is there any way we can stop the frmweb_dump_pid file generation. As we see sometimes the size of the dump file is exceeding 1 tb which is causing space issue and application stops working. I understand the dump file generation is related to application crash or bug but customer wants to disable the entire dump file generation.
location :-  frmweb_dump_XXXX files in F:\oracle\developer\forms\trace

It would be really helpful if you could give some insight about the issues i have mentioned.

As always thanks a lot for helping the community.

Regards,

Soumya

[ErmanArslansOracleBlog]

When you fix something, you continue and hit another barrier.. That's normal :)
At the moment, you need to solve "too many open filesystem"  error.
It is the OS that causes this.. But! it may a result of a misbehaving application as well .. In this case the frmservlet.
Wndows Servers have also limitations on maximum open files.. Use net config server to check.. It is set to 16384..

I couldn't see another method than updating the registry to increase the open file limit for windows..
Check it with your Windows admin.. You know what to do..

This coredump generation may also be related with the "too many open files" error bytheway.

you should investigate why your forms are crashing..
FORMS_CATCHTERM may help you on disabling/enabling forms debug..  MOS Note : What does s_forms_catchterm mean? (Doc ID 1530898.1))

MOS note "Tuning Performance on E-Business suite (Doc ID 744143.1)" recommends setting FORMS_CATCHTERM to 0. By doing this you tell OS to do that core dump generation thing. If you disable core dump generation on OS, than you get what you need :)

As for cleanup, you may use the script/one liner provided in the following MOS note : Automatic dump file cleanup in ORACLE_HOME/forms/trace (Doc ID 1674590.1)

*Note that, I didn't test these things and I don't have a windows server (running EBS or forms) to play with at this moment.. So you should consider my comment carefully. The risk is yours..

However; your Forms version is an old one.. So you may be hitting a bug as well...  Check OS logs and forms server logs, there may be a cause for your failing (and core dump generating) forms there..

[soumya]

Hi Erman,

Thanks a lot for your reply. I would like to add my view to your comments ,

I couldn't see another method than updating the registry to increase the open file limit for windows..
 -- We couldn't find anything regarding this. Would be really helpful if you could provide some document.

FORMS_CATCHTERM may help you on disabling/enabling forms debug..  MOS Note : What does s_forms_catchterm mean? (Doc ID 1530898.1))
--- Can we use this for developer suite as the doc id says it applies for EBS.


As for cleanup, you may use the script/one liner provided in the following MOS note : Automatic dump file cleanup in ORACLE_HOME/forms/trace (Doc ID 1674590.1)

--- Yes we are already purging dump files using batch file. only problem arises when a single dumpfile size reaches to TB . For that we need to disable the coredump creation.

Regards,
Soumya

[ErmanArslansOracleBlog]

Well.. You need to check with your OS admin... Here is a similar case -> https://www.ibm.com/support/pages/how-change-registry-values-windows-increase-ulimit-settings

FORMS_CATCHTERM is an Forms related env variable . For instance , it is documented here -> https://docs.oracle.com/cd/B14099_19/hpuxitan.1012/relnotes.1012/relnotes/forms.htm

It seems uou are already purging dump files using a bat file.. that s okay.

[soumya]

Thanks Erman.

I will check with windows admin to fix the issue. Will revert if i have any update.

Thanks

Soumya