0 Replies Latest reply: Mar 17, 2013 5:52 AM by 997356 RSS

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

    997356
      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

      Yours

      Thamsanqa