Ora 1033 Error

[kkcholan]

Sir

Backend Oracle 9i
Front end VB.Net
O/s Windows 2003 Server

Server Crashed due to power failure

then the following error
displays when connect to oracle database

ORA 1033-Oracle intialization or shutdown in progress

I have search a lot of blogs But I have not yet get the suitable answer

Karikalacholan
[email removed - against site rules]

[debasisdas]

The problem is because the instance of the databse has been shut down. At this time u can't log in,

Open SQL*Plus and connect sys as sysdba and start the database again to work with it.
or
start the services of Oracle Listener, Oracle Agent and the Oracleservice containint the SID of the database.

[ardzimano]

ora 1033

from your c:\ prompt type

sqlplus /nolog

from sqlplus prompt type

>connect /as sysdba

>shutdown

>startup mount

>alter database recover database until cancel;

if the above command fails try
>recover database using backup controlfile until cancel;"

on success type
>ALTER DATABASE OPEN RESETLOGS;

stop and restart oracle service

from

Andrew and Bixon the Ora Gurus

[Shweta Agrawal]

Hi

I had this error too and tried using the solution you told above. first command
sql> alter database recover database until cancel;
It didn't work and gave this error - ORA-00279: change 4736266 generated at 03/19/2011 09:06:24 needed for thread 1
ORA-00289: suggestion :

and then I gave second command
sql> recover database using backup controlfile until cancel;
and then I got this error
ORA-00275: media recovery has already been started

Now what should I do?

I am new to Oracle and have never worked on it before ...

Thanks in advance for your help.

PS- I had a virus in my computer few months back and I got it cleaned , is it something related to any program in my computer which is not running or had been deleted while removing the virus ?? As other basic stuff is not working after removing virus ... like audio and video system not working.

[hemendra singh]

first off all check the status of your instance,its started or mount
,i guess its not open according to your post..by issue this comm
select status from v$instance;
if it is mount then try to open it by
alter databse open;


might be is there any problem with datafiles.
and check the alert log file ...tell me the detail info from the alter log file..so that i can figer out the actual problem