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>
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