ora-01109: database not open

TheHades0210

Aloha!

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


[[email protected] SBAtemp]$ sqlplus sys/[email protected] 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

839439

try this ...

$ sqlplus sys/[email protected] as sysdba

SQL> shut immediate

SQL>startup

and to check the instance status :

SQL> select status from v$instance;

let me know the result (in case correct or helpful mark it so that this thread can be close)

--neeraj

oradba

What about 'alter database open;' ? Maybe the database has a problem and can't be opened.

Werner

Helios-GunesEROL

Hi

1. Check alert log db is up or not or have any error message?
2.
Error: ORA 1109
Text: database not open
-------------------------------------------------------------------------------
Cause: An attempt was made to perform an operation on an unopened database.
Action: Open the database, then retry the operation.

Regard
Helios

839439

fire the command to check the status of instance where it is opened or not ?

SQL> select status from v$instance;

Hope this help you

--neeraj

TheHades0210

Aloha!

I have tried the v$instance and I got an error, sorry i cant post the result now since im on mobile. I'll post it later, but let say the DB is close(since im receiving an error prompt when I ran the v$instance), how can i open it?

Thanks for your time.

Hades,

Edited by: TheHades0210 on Sep 24, 2011 4:40 PM

839439

try this ...

$ sqlplus sys/[email protected] as sysdba

SQL> shut immediate

SQL>startup

and to check the instance status :

SQL> select status from v$instance;

let me know the result (in case correct or helpful mark it so that this thread can be close)

--neeraj

TheHades0210

Thanks a lot!

974241

Hi !.... i have the same problem, but, when i do : alter database open,... i receive a new msg : ORA-01221.... how can i solve it?
tks