Friday, July 26, 2013

ORA-01033: ORACLE initialization or shutdown in progress

Cause : Your database are not in open stage. May be your database in startup/mount stage.

Action : Open database the following way.

SQL> CONN MICR/MICR;
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress


Warning: You are no longer connected to ORACLE.
SQL> ALTER DATABASE OPEN;
SP2-0640: Not connected
SQL> CONN /AS SYSDBA
Connected.
SQL> ALTER DATABASE OPEN;

Database altered.


SQL> SELECT STATUS FROM V$INSTANCE;

STATUS
------------
OPEN

SQL> CONN MICR/MICR;
Connected.
SQL>

No comments:

Post a Comment