miércoles, 23 de enero de 2013

ORA-011033: ORACLE initialization or shutdown in progress


It may be the case, the database did not stop correctly.
Try out following.
Open Dos command Prompt
c:> sqlplus /nolog
sql> connect sys/manager as sysdba
sql>shutdown immediate
sql> startup
sql> exit
While startup it may show error message like some of the parameter is missing. Note down that parameter and update in initSID.ora file.



or 



fter some googling I found the advice to do the following:
> sqlplus /nolog
> SQL> connect / as sysdba
Connected.
> SQL> shutdown abort
ORACLE Instance shut down.
> SQL> startup nomount
ORACLE Instance started
> SQL> alter database mount;
> SQL> alter database open;
Which still gave the error:
ORA-00600: internal error code, arguments: [kcratr1_lostwrt]
I then found the advice to do the following:
> SQL> startup mount
ORACLE Instance started
> SQL> recover database
Media recovery complete
> SQL> alter database open
Database altered

0 comentarios:

Publicar un comentario