ORA-00600 how to resolve this error?

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
kamran.it
Posts: 34
Joined: Tue Aug 01, 2006 7:43 am
Location: Pakistan

ORA-00600 how to resolve this error?

Post by kamran.it »

I was working on my Oracle 9i database and 6i form server. windows 2003

my server suddenly restarted and after that oracle showing the error ORA-01033: ORACLE initialization or shutdown in progress...


I try to resolve this error through this method. I received above mentioned error. please help how to resolve this error. ORA-00600.


C:\>sqlplus


SQL*Plus: Release 9.2.0.1.0 -


Copyright (c) 1982, 2005, Oracle Corporation. All rights reserved.


Enter user-name: sys as sysdba

Enter password :password


Shutdown Database


SQL> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.


Startup Database (force)


SQL> startup force;

ORACLE instance started.


Total System Global Area 135338868 bytes

Fixed Size 453492 bytes

Variable Size 109051904 bytes

Database Buffers 25165824 bytes

Redo Buffers 667648 bytes

Database mounted.

ORA-00600: internal error code, arguments: kcratr1_lostwrt],[,],[..................

Please note I dont have metalink Id to access.
miananwar
Posts: 40
Joined: Wed Jun 18, 2008 12:09 pm
Location: Pakistan

Post by miananwar »

dear,

send me the logfile of your database at my gmail id "mmanwerkeen@gmail.com".

regards,
anwar
amirtai
Posts: 138
Joined: Sat Apr 08, 2006 5:54 pm
Location: Canada
Contact:

Post by amirtai »

Hi there

What's the use of database, it's TEST or PROD? It looks like some data file(s) got corrupted.

If it's PROD then should be in ARCHIVED LOG mode try to use following commands sequence to recover database before it got crashed.

SQL> STARTUP MOUNT;
SQL> RECOVER DATABASE UNTIL TIME '2008-12-15:23:59:00' USING BACKUP CONTROLFILE;

If it's not PROD then I would suggest to drop your database with DBCA and recreate it.

Thanks
Amir
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests