ERPstuff - Oracle EBS Community

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.

dear,

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

regards,
anwar

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