0 Replies Latest reply on Mar 17, 2013 10:52 AM by 997356

    ERROR: ORA-01033: ORACLE initialization or shutdown in progress

      I am new to Oracle database having worked with SQL servers(2000, 2005, 2008, & 2012) for quite sometime though.I installed Oracle 11g on my Windows 8 64-bit laptop and initially could login via SQL Plus using DBSNMP account name and the password I set during installation. I tried running SQL Developer with no success since it requires JAVA Runtime therefore I downloaded the SQL Developer with JAva from oracle.com and unpacked the zipped file to the D: drive as i could not extract it to C:\Program Files as per suggestions i got. The application starts perfectly but when i try to login to my database i get this error message : ERROR: ORA-01033: ORACLE initialization or shutdown in progress

      I have tried to restart the service using the following commands from SQL PLUS

      -connect sys as sysdba
      - connect / as sysdba
      - shutdown abort

      From SQL Plus it seems am now connected but SQL Developer still throws the same error. Please advise me on how to proceed and manage my database graphically.

      Thanks in advance