4 Replies Latest reply: May 11, 2014 2:10 PM by Frak!!! RSS

    ORA-01109: database not open

    1053446

      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