Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: startup failed with ora-600

Re: startup failed with ora-600

From: yls177 <yls177_at_hotmail.com>
Date: 21 Nov 2004 18:47:32 -0800
Message-ID: <c06e4d68.0411211847.5d889ba8@posting.google.com>


"Michael Lohmar" <michael.lohmar_at_gmail.com> wrote in message news:<1100254416.901765.264810_at_f14g2000cwb.googlegroups.com>...
> Hello,
>
> I found the metalink note: 28929.1 which seems to describe your error.
>
> DESCRIPTION:
>
> A data block SCN is ahead of the current SCN.
>
> The ORA-600 [2662] occurs when an SCN is compared to the dependent SCN
> stored in a UGA variable.
>
> If the SCN is less than the dependent SCN then we signal the ORA-600
> [2662] internal error.
>
> SUGGESTIONS:
>
> There are different situations where ORA-600 [2662] can be raised.
>
> It can be raised on startup or doing database operation.
>
> If not using Parallel Server, check that 2 instances have not mounted
> the same database.
>
> Check for SMON traces and have the alert.log and trace files ready to
> send to support. Check the SCN difference [argument d]-[argument b].
>
>
> If the SCNs in the error are very close, then try to shutdown and
> startup the instance several times.
>
> In some situations, the SCN increment during startup may permit the
> database to open. Keep track of the number of times you attempted a
> startup.
>
> If the Known Issues section below does not help in terms of identifying
> a solution, please submit the trace files and alert.log to Oracle
> Support Services for further analysis.
>
> Greetings,
> Michael

from what i could understand, u are saying that i need to startup a few times? Received on Sun Nov 21 2004 - 20:47:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US