Oracle -Problme Patching memory exhausted

[mohssinm]

Oracle E-Business Suite

we have two web tiers on of them in DMZ zone
and database server .

WEB Tier and DB in Server zone.


The problem pathing web tier need connect to database and do some activity .

database connection work fine but after while for doing some activity

message appear

memory exhausted
ORA-03113: end-of-file on communication channel
ORA-24323: value not allowed
Error accessing package DBMS_APPLICATION_INFO
ERROR: ORA-03114: not connected to ORACLE


we Open case with oracle . Oracle says it network issue. we open case with HP HW fine also connectivty fine . same instance with diffrent port working fine .

I don't know it is may be OS issue.or if there is any tool to test connectivity between Sever and DMZ. and we move this server to server zone wokring fine.


your adive where probelm may in any area ??

[mohssinm]

any suggestions.

[Steven E. Protter]

Shalom,

Try and reduce memory use and run again.

I find it interesting that Oracle support says its a network error when the program they provide says its out of memory.

Perhaps analyze the system with a memory leak detector.

http://www.hpux.ws/?p=8

SEP

[mohssinm]

Hi Shalom

Thanks . but is there is any managment tool for Memory on HP-UX 11.11

[Dennis Handly]

>is there is any management tool for Memory on HP-UX 11.11?

"swapinfo -tam" can give you a gross idea.
There is also top and ps(1).

[Volker Borowski]

. same instance with diffrent port working fine .


Well, this suggests to use a diffrent port :-)

Which port works and which one does not ?

May be, you have some kind of active network component in between (filter, firewall, loadbalancer, ...) that keeps track how long a session is established and that forces a
session disconnect after a specific (idle?) timeout.
This would be a security feature to avoid
that someone can "steal" an authorized/identified session that is no longer used.
Esp. if the "original" port you use is port 80 or 443 this feature could be a standard behavior on a loadbalancer.

Some other things to hunt for:
-Check the listener log for strange messages.
-Check "lsnrctl services" for an extremly hight amount of sessions.

Volker