Database is not opening [message #134859] |
Sun, 28 August 2005 06:40 |
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 #134865 is a reply to message #134862] |
Sun, 28 August 2005 09:27 |
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.
|
|
|