Friday, July 15, 2016

ORA-01033: ORACLE initialization or shutdown in progress or Process ID: 0 & Session ID: 0

ORA-01033: ORACLE initialization or shutdown in progress  or Process ID: 0 & Session ID: 0

Some times database will not mount correctly. we need to mount it manually step by step..

C:\Users\Administrator>sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on Mon Jul 25 14:59:33 2016

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

Enter user-name: system
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0


Enter user-name:

For manual  shutdown and startup the database you need to follow the steps, first Shut down it and start it up then mount.see following commands and how to run the commands.
  1. sqlplus / as sysdba;
  2. shutdown immediate;
  3. startup nomount;
  4. alter database mount;
  5. alter database open;
in case when you run the fist command " sqlplus / as sysdba;"  and if you get any errors like "ERROR:
ORA-01031: insufficient privileges.

then you have to run it as  "sys as sysdba"  and followed by the sequence.


Please check the below image I have executed the commands and able to connect the sysdba user.

Once all the commands were executed successfully, now oracle is mounted and open state and your able to connect the users.
In the above image also I am not able to connect sysdba, the I will use the sys as sysdba to connect.

9 comments:

  1. I am facing same issue : ORA-01033: ORACLE initialization or shutdown in progress or Process ID: 0 & Session ID: 0
    and while trying above solution not able to login as sysdba

    showing this error --
    C:\windows\system32>sqlplus / as sysdba;

    SQL*Plus: Release 12.1.0.1.0 Production on Mon May 13 16:53:40 2019

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

    ERROR:
    ORA-01017: invalid username/password; logon denied

    ReplyDelete
    Replies
    1. Hi,

      I am not able to run this "alter database open;" command

      Error :
      SQL> alter database open;
      alter database open
      *
      ERROR at line 1:
      ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
      ORA-01110: data file 2:
      'D:\DSPLM\PRODUCT\ORACLE\ORADATA\X3DEXP19XX3DPASS_ADMIN.DBF'

      Delete
    2. It seems there is one data file missing from your database.
      try to query this : select NAME from v$datafile where file#=2;
      if the datafile missing or not readable from os .. you will get this error.In this case you have to drop the data file and try to open.

      alter database datafile 2 OFFLINE DROP;

      alter database open;

      Delete
    3. Thanks Murthy for this solution. This worked for me.

      Delete
  2. Hey,
    Step 1 is not working for me
    Error :
    Microsoft Windows [Version 10.0.17134.706]
    (c) 2018 Microsoft Corporation. All rights reserved.

    C:\windows\system32>sqlplus / as sysdba

    SQL*Plus: Release 12.1.0.1.0 Production on Tue May 14 11:37:47 2019

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

    ERROR:
    ORA-01017: invalid username/password; logon denied


    Enter user-name: sys as sysdba
    Enter password:
    ERROR:
    ORA-01017: invalid username/password; logon denied


    Enter user-name:



    Please help..

    ReplyDelete
  3. alter database mount
    *
    ERROR at line 1:
    ORA-00214: control file 'C:\APP\HOME\PRODUCT\18.0.0\ORADATA\XE\CONTROL01.CTL'
    version 24566 inconsistent with file
    'C:\APP\HOME\PRODUCT\18.0.0\ORADATA\XE\CONTROL02.CTL' version 24564
    at step 4 i'm getting this error

    ReplyDelete
  4. shutdown immediate;
    ORA-01507: database not mounted


    ORACLE instance shut down.
    SQL> startup nomount;
    ORACLE instance started.

    Total System Global Area 1068937216 bytes
    Fixed Size 2260048 bytes
    Variable Size 616563632 bytes
    Database Buffers 444596224 bytes
    Redo Buffers 5517312 bytes
    SQL> alter database mount;
    alter database mount
    *
    ERROR at line 1:
    ORA-00205: error in identifying control file, check alert log for more info


    SQL> alter database mount;
    alter database mount
    *
    ERROR at line 1:
    ORA-00205: error in identifying control file, check alert log for more info

    ReplyDelete

Thanks for giving comments!!