killed due to trashed stack - HP UX 11.11 Oracle 10g

[sathis kumar]

Hello,

We are getting the error "Pid 26693 killed due to trashed stack. Pid 26693 was killed due to failure in writing the signal context" when we try to run our application on HP UX 11.11 ( Oracle 10g ). But the same execution is working fine on HPUX 11.11 ( Oracle 9i ). Can anybody let us know the solution for this error message?

Thanks.

[Peter Godron]

Hi,
assuming you have looked at PHKL_27283, can you increase the stacksize, as 10g has a higher usage than 9i.

[sathis kumar]

Hi,

Thanks for your reply. Could you please let me know

a) how to check whether the PHKL_27283 is installed or not?
b) how to increase the stack size ( is there any command used to do this ) ?

Your help on this would really be appreciated.

Thanks in advance.

[Yogeeraj_1]

hi,
a) to check patch:

swlist -l patch|grep -i phkl_27283


hope this helps!

kind regards
yogeeraj

[Steven E. Protter]

Shalom,

Several things should be done prior to oracle installation:

1) Check kmtune output against oracles minimum recommendations.
2) Install a recent bi-annaul patch release.
3) Install oracle patches required beyond a bi-annaul release.

SEP

[sathis kumar]

Hi,

Regarding the patch PHKL_27283, it is not installed in our system. But the patch PHKL_28474 is installed. Can you please let me know if we have to install PHKL_27283 even though we have got PHKL_28474 installed already ?

Thanks in advance.

[John Payne_2]

Sathis,

PHKL_27283 is superceded by PHKL_28474. This means that if you have PHKL_28474 installed, it has replaced your need for PHKL_27283, and in fact, as long as PHKL_28474 remains active on the system, SD tools will try their hardest to prevent you from installing PHKL_27283 on top of it. (Long story short, no, you are ok with PHKL_28474, but it sounds like your problem still exists.)

I wonder if this is a kernel tuning issue. (Although I never reserve judgement when Oracle is involved...) Have you reviewed the kernel parameter settings to verify you are in a tolerable range? (Like maxssiz and maxssiz_64...)

Hope it helps
John