Home » RDBMS Server » Server Administration » Database can't be started (merged)
Database can't be started (merged) [message #267453] Thu, 13 September 2007 05:49 Go to next message
sunny_ocp
Messages: 15
Registered: September 2007
Location: Pakistan
Junior Member
I am using Oracle 9i Database. My database is not starting and unknown error is coming. When I start the 'sqlplusw' and log in as sysdba and query any table which exists in the user schema, error generates that

ORA-01219: database not open: queries allowed on fixed tables/views only


When I do shutdown this appears:

ORA-01109: database not open


When I do startup or startup force this appears:

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], [], [], [], [],
[], [], []




Well I donot understand what error is this, as I am a student and I do not how to resolve it. I have also restarted the oracle service but database is not opening so what should I do??
Re: Database can't be started. [message #267455 is a reply to message #267453] Thu, 13 September 2007 05:55 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Its a Oracle Bug.
Re: Database can't be started. [message #267458 is a reply to message #267453] Thu, 13 September 2007 06:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-00600 = Oracle bug => search on Metalink and/or call Oracle support

Regards
Michel
What to do? [message #267499 is a reply to message #267453] Thu, 13 September 2007 09:44 Go to previous messageGo to next message
sunny_ocp
Messages: 15
Registered: September 2007
Location: Pakistan
Junior Member
So what to do? I mean oracle bug is virus or what, I reinstall the database again so it be ok or not ?
Re: Database can't be started. [message #267500 is a reply to message #267453] Thu, 13 September 2007 09:45 Go to previous messageGo to next message
sunny_ocp
Messages: 15
Registered: September 2007
Location: Pakistan
Junior Member
So what to do? I mean oracle bug is virus or what, I reinstall the database again so it be ok or not ?
Re: What to do? [message #267501 is a reply to message #267499] Thu, 13 September 2007 09:46 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
So what part of
search on Metalink and/or call Oracle support

have you done so far?
Re: Database can't be started. [message #267505 is a reply to message #267500] Thu, 13 September 2007 10:00 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Check you alert log as well.

Search it on METALINK.ORACLE.COM.
Re: Database can't be started. [message #267525 is a reply to message #267500] Thu, 13 September 2007 10:58 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
So what to do?

Quote:
search on Metalink and/or call Oracle support

Regards
Michel

Previous Topic: RMAN Invalid Objects
Next Topic: What does this LEVEL 3 MEANS IN (ORA-00604: error occurred at recursive SQL level 3)
Goto Forum:
  


Current Time: Sat Nov 30 04:56:11 CST 2024