4 Replies Latest reply on May 11, 2014 7:10 PM by Frak!!!

    ORA-01109: database not open


      Installed Oracle Database 11g Express Edition.

      Started the Database

      Opened Run SQL Command line

      Connected to system as sysdba


      but when i try to create user

      SQL> Create User  <username> identified by <pwd>;


      The system gives error ORA-01109: database not open


      When i check the status SQL> select status from v$instance;, the status comes as "STARTED"


      What i need to resolve ORA-01109. Please suggest