Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01109: database not open

1053446May 10 2014 — edited May 11 2014

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2014
Added on May 10 2014
4 comments
5,972 views