Home » RDBMS Server » Server Administration » database corruption on 9i
database corruption on 9i [message #52405] Fri, 19 July 2002 04:14 Go to next message
Nirmal
Messages: 39
Registered: November 2000
Member
My database is not opening.
In Sql error message is " oracle initialization or shutdown in progress"
My database is mounting but not opening.

Report message to a moderator

Re: database corruption on 9i [message #52408 is a reply to message #52405] Fri, 19 July 2002 05:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
this is a very generic error.
do a clean shutdown and startup again.
if clean shutdown is not possible, use shutdown abort.
(you may require to do some media recovery later).
look into logs for any specific messages.

Report message to a moderator

Re: database corruption on 9i [message #52419 is a reply to message #52405] Fri, 19 July 2002 15:20 Go to previous messageGo to next message
ctg
Messages: 146
Registered: July 2002
Senior Member
make sure you are connect "AS SYSDBA" (ex: connect sys/oracle as sysdba). Once you get connected, Select instance_name, status from V$instance; to find out what mode you are in. Then try and get the db open to see why it is not opening.

Report message to a moderator

Re: database corruption on 9i [message #52423 is a reply to message #52405] Fri, 19 July 2002 21:25 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
hi,
Do What Mr.Mahesh said..or else incase if some files are missing...u will get that information from the trace Files...so open it and check the information..

byee
sai

Report message to a moderator

Previous Topic: Oracle on another drive
Next Topic: connectivity
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 18 21:40:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.