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

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.

Thanks for providing an update on this topic.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Thu Dec 21 2006 - 05:50:32 CST