Re: WOO HOO, FIXED IT - WAS - RE: Ora-00600 fun

Looks like memory leak, and fixing it by restarting Oracle service proves it.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, February 14, 2003 7:23 AM

> Someone suggested a reboot so I figured I would start by just shutting
down the Oracle database service. I restarted the service and the database is up and running. You gotta love the windoze OS. When in doubt reboot the service or the server.
>
> Dave
>
> -----Original Message-----
> Sent: Friday, February 14, 2003 5:34 AM
> To: Multiple recipients of list ORACLE-L
>
>
> After my nightly cold backup and during the database startup I got this
error;
>
> ksedmp: internal or fatal error
> ORA-00600: internal error code, arguments: [3051], [82], [73], [], [], [],
[], []
> ORA-04030: out of process memory when trying to allocate 8389132 bytes
(pga heap,THREAD RECOVERY)
>
> The database mounts but does not startup. I already filed a TAR with
Oracle but was wondering if any of you might have a clue on this one. This is suppose to happen on Monday, not Friday.
>
> Thanks,
>
> Dave
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Farnsworth, Dave
> INET: DFarnsworth_at_Ashleyfurniture.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Farnsworth, Dave
> INET: DFarnsworth_at_Ashleyfurniture.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).