Skip to Main Content

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ora-01109: database not open

TheHades0210Sep 23 2011 — edited Nov 14 2012
Aloha!

I have created an instance on 11g R2 and about to import a dump. Upon creating a directory, I stumble upon this error;


[oracle@ole5 SBAtemp]$ sqlplus sys/Change12345@orc01 as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 23 19:30:33 2011

Copyright (c) 1982, 2009, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create or replace directory BW_TEMP as '/u01/SBAtemp/';
create or replace directory BW_TEMP as '/u01/SBAtemp/'
*
ERROR at line 1:
ORA-01109: database not open


SQL>

Your advise and comment is greatly appreciated.

Thanks in advance.

Regards,
Hades
This post has been answered by 839439 on Sep 24 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 12 2012
Added on Sep 23 2011
7 comments
35,174 views