Ora 1033 Error

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]

re: Ora 1033 Error

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.

re: Ora 1033 Error

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