Re: "ORA-27300: OS system dependent operation:GetThreadTimes failed" Causes Instance Crash 10.2.0.2

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 21 Dec 2006 06:35:14 -0800
Message-ID: <1166711714.585352.83880@n67g2000cwd.googlegroups.com>

hpuxrac wrote:
> Charles Hooper wrote:
> > metatech_at_flashmail.com wrote:
> > > Charles Hooper a écrit :
> > >
> > > > The alert log shows this:
> > > > ---------------------------------
> > > > Sat Oct 28 00:00:34 2006
> > > > Process startup failed, error stack:
> > > > Sat Oct 28 00:00:34 2006
> > > > Errors in file
> > > > d:\oracle\product\10.2.0\admin\DB\bdump\vmfg_psp0_2196.trc:
> > > > ORA-27300: OS system dependent operation:GetThreadTimes failed with
> > > > status: 6
> > > > ORA-27301: OS failure message: The handle is invalid.
> > > > ORA-27302: failure occurred at: skgpspawn
> > > >
> > >
> > > See bug fix 5163569
> > > RDBMS: There is a timing window at background process spawn time that
> > > can cause an ORA-00600 [784].
> > > This is fixed in 10.2.0.2.0 Patch 8 (10.2.0.2.8P) 32-Bit Patch 5502226
> > > 64-Bit (Itanium) Patch 5500894 64-Bit (x64) Patch 5500921
> >
> > I installed patch 9 hoping to cure the problem, and now I can crash the
> > database sessions every 40 hours if desired. I opened an SR on
> > Metalink on 28-NOV-06, and have yet to receive a suggestion from
> > Oracle. I came up with a work around 15 days ago.

>

> Do you have a re-creatable test case ( or can you produce one ) so that
> Oracle can reproduce this at will? If so I would submit that and get
> it after a week or two consider getting it bumped up to sev 1.

>

> I just got oracle to admit to a bug fix in the 9208 patchset ( second
> one for this site ) with a service request that's been open since early
> October. The explanation for the delay was that it was assigned to an
> analyst who was ( apparently ) looking for another job and that person
> wasn't motivated to work on it. ( I did have a workaround but still
> ... maybe I shouldn't have let it sit open at sev 2 for so long ). My
> problem though wasn't nearly as severe as a bug that brings down the
> instance.

I finally received a response from Oracle. Good luck to any one else experiencing ORA-07445 error after applying patch 9 on 10.2.0.2:

---

UPDATE

---

Hi Charles,

Without a testcase I cannot draw a conclusion as this should be investigated by the Development. Since the problem have not occur ed anymore after changing the parameters:

optimizer_features_enable='10.2.0.1'
_optimizer_undo_cost_change='10.1.0.4'
query_rewrite_enabled='FALSE'
cursor_sharing='EXACT'

a workaround which you have discovered I am inactivating this SR. If the problem reproduce within the next two weeks please update the SR. After the specified period of two weeks you have the option to open a new SR.

Best Regards,
Codrut Popescu
Global Customer Services

STATUS

---

Inactivated -- Issue Resolved

---

I waited 23 days for the issue to be resolved, somehow I feel that I did not receive a solution.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Thu Dec 21 2006 - 08:35:14 CST