ora-01109: database not open
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