Wednesday, May 16, 2018

Resolve ORA-011033: ORACLE initialization or shutdown in progress

Two way to resolve:

go to cmd prompt :



1.  Run below query

sqlplus system/Oracle_1@pdborcl as sysdba;
alter database open;

If it not work

2. Run below query..



> 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

No comments:

Post a Comment