Re: startup failed with ora-600

From: Michael Lohmar <michael.lohmar_at_gmail.com>
Date: 12 Nov 2004 02:13:36 -0800
Message-ID: <1100254416.901765.264810@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 Received on Fri Nov 12 2004 - 04:13:36 CST