This discussion is archived
7 Replies Latest reply: Nov 14, 2012 7:31 AM by 974241 RSS

ora-01109: database not open

TheHades0210 Newbie
Currently Being Moderated
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
  • 1. Re: ora-01109: database not open
    19426 Guru
    Currently Being Moderated
    What about 'alter database open;' ? Maybe the database has a problem and can't be opened.

    Werner
  • 2. Re: ora-01109: database not open
    Helios-GunesEROL Oracle ACE
    Currently Being Moderated
    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
  • 3. Re: ora-01109: database not open
    839439 Pro
    Currently Being Moderated
    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                                                                                                                                                                                                                                                                                                                           
  • 4. Re: ora-01109: database not open
    TheHades0210 Newbie
    Currently Being Moderated
    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
  • 5. Re: ora-01109: database not open
    839439 Pro
    Currently Being Moderated
    try this ...

    $ sqlplus sys/Change12345@orc01 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                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
  • 6. Re: ora-01109: database not open
    TheHades0210 Newbie
    Currently Being Moderated
    Thanks a lot!
  • 7. Re: ora-01109: database not open
    974241 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points