Resolving Oracle Error ORA-01033

The database shuts down unexpectedly during the import of data. After restarting the machine, Pl/sql-developer cannot log in to the database, error ora-01033:oracle Initializationor shutdown in progress. The steps to resolve are as follows:

2. Run cmd

   C:\users\dell3800>set ORACLE_SID=ORCL

   C:\users\dell3800>sqlplus "/as sysdba"

   Sql*plus:release 12.1.0.2.0 Production on Mon Mar 2 08:52:09 2015

   Copyright (c) 1982, Oracle. All rights reserved.

   
   Connected to:
   Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-production
   With the partitioning, OLAP, Data Mining and Real application testing options

4. Shut down the database and restart
   

   sql> shutdown Immediate
   Ora-01109:database not open

   
   Database dismounted.
   ORACLE instance shut down.
   Sql> Startup
   ORACLE instance started.

   Total System Global area 778387456 bytes
   Fixed Size 1374808 bytes
   Variable Size 318768552 bytes
   Database buffers 452984832 bytes
   Redo buffers 5259264 bytes
   Database mounted.
   Ora-01172:recovery of Thread 1 stuck at block 2937401 of file 7
   Ora-01151:use Media Recovery to recover block, restore backup if needed

6. After starting the report ORA-01172, follow the prompts to recover. Use the command ALTER DATABASE recover

   sql> ALTER DATABASE recover
   2;

   Database altered.

8. Restart the database without error. Pl/sql-developer landed successfully.

   sql> shutdown Immediate
   Ora-01109:database not open

   
   Database dismounted.
   ORACLE instance shut down.
   Sql> Startup
   ORACLE instance started.

   Total System Global area 778387456 bytes
   Fixed Size 1374808 bytes
   Variable Size 318768552 bytes
   Database buffers 452984832 bytes
   Redo buffers 5259264 bytes
   Database mounted.
   Database opened.

Resolving Oracle Error ORA-01033