Database Administration (MOSC)

MOSC Banner

ORA-01033: ORACLE initialization or shutdown in progress

edited Aug 17, 2015 10:01AM in Database Administration (MOSC) 14 commentsAnswered

An instance I have here is in a strange state. (Windows Server 2012, Oracle 11.2.0.4).

When I open a CMD-prompt and enter sqlplus user/password@sid I'm getting

an ORA-01033.

When I do a SET SID=<sid> and enter SqlPlus user/password I can connect fine and

do normal databse operations. This is the picture:

SQL*Plus: Release 11.2.0.4.0 Production on Mo Aug 10 11:28:51 2015

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

Benutzernamen eingeben: / as sysdba

Verbunden mit:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select status, database_status from v$instance;

STATUS       DATABASE_STATUS
------------ -----------------
OPEN         ACTIVE

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE

SQL>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center