Home » RDBMS Server » Server Administration » Database is not opening
Database is not opening [message #134859] Sun, 28 August 2005 06:40 Go to next message
hamdard
Messages: 37
Registered: July 2005
Member
hi,
Please help in solving this issue.
I have Oracle Database Release 9.2.0.1.0 on Windows XP system. I removed some programs from Add/Remove programs in Windows XP. And after I restarted my computer my database is not opening.
I receive the following error message
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

Services are running. I can connect to SQL* Plus as sysdba.
Please check this.
SQL*Plus: Release 9.2.0.1.0 - Production on Sun Aug 28 12:51:03 2005

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

Enter user-name: scott
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

SQL> conn / as sysdba
Connected.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.

Total System Global Area  143727516 bytes
Fixed Size                   453532 bytes
Variable Size             109051904 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
SQL> alter database mount;

Database altered.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], [],
[], [], []

SQL> conn / as sysdba
Connected.
SQL> SELECT * FROM tab;
SELECT * FROM tab
              *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> STARTUP
ORACLE instance started.

Total System Global Area  143727516 bytes
Fixed Size                   453532 bytes
Variable Size             109051904 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], [],
[], [], []


On checking this error ORA-00600, it says that database files may be corrupted. I didn't play with database files. I didn't remove anything related to database.

Please help me. What should I do now?

I searched this forum first and found the above mentioned procedure but it didn't work.

Thank you and regards.

Re: Database is not opening [message #134862 is a reply to message #134859] Sun, 28 August 2005 08:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Database is corrupted.
try this.

sql> startup mount;
sql> recover database;
sql> alter database open;
Re: Database is not opening [message #134865 is a reply to message #134862] Sun, 28 August 2005 09:27 Go to previous message
hamdard
Messages: 37
Registered: July 2005
Member
hi,
Thank you so much Sir. It worked like magic. You don't know how much you have helped me. I just don't have the words for this great help.
Thank you so much again and regards.
Previous Topic: Best way to move 8.1.6 to 9i - new server
Next Topic: OEM
Goto Forum:
  


Current Time: Sun Jan 26 11:23:31 CST 2025