Re: ORA-0600 in 10g

On Nov 12, 6:49 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Nov 12, 3:00 pm, "if_inves..._at_yahoo.com"
>
>
>
>
>
> <basis_consult..._at_hotmail.com> wrote:
> > Hi,
>
> > On a 10g Win2003 system, when I startup the database, the
> > following appears; I cannot find much on this specific ORA-0600
> > error. Are there any options besides a recovering from a backup?
>
> > Total System Global Area 272629760 bytes
> > Fixed Size 1248504 bytes
> > Variable Size 146801416 bytes
> > Database Buffers 121634816 bytes
> > Redo Buffers 2945024 bytes
> > Database mounted.
> > ORA-00600: internal error code, arguments: [kcrf_rsw_init-2],
> > [2359344], [621],
>
> > Thanks,
> > IF
>
> See metalink Note:260459.1 for how to deal with ora-600 errors. You
> would be well-advised to open an SR with support. If you are getting
> it after the db is mounted but not yet open, you might be having a
> problem with redo - guessing kcrf is like x$kcrfx athttp://rootshell.be/~yong321/computer/x$table.html. So you might try
> taking a backup of what you have, then open resetlogs (you will have
> to recover first if the last shutdown wasn't normal - see your backup
> controfile to trace for an example). Oh, and you might look at the
> hardware where your redo and controlfiles are, too.
>
> jg
> --
> @home.com is bogus.http://www.hagerty.com/RoadSignRally/- Hide quoted text -
>
> - Show quoted text -

The very first thing I think you should do is check the alert log and bdump directory trace files for any information related to your error. Second check that no tape backup or other process has the control file. Being that this is a Windows platform I would check the services screen for the Oracle service. In fact if the error did in fact stop the database from mounting the control file I would probably reboot before continuing if there was no useful information in the alert log or trace files just because so many problems disappear on Windows if you just reboot. I suspect pending patches or incomplete installs are often the actual problem.

HTH -- Mark D Powell -- Received on Mon Nov 12 2007 - 18:33:44 CST