Forum Stats

  • 3,757,560 Users
  • 2,251,244 Discussions
  • 7,869,866 Comments

Discussions

ora-01109: database not open

TheHades0210
TheHades0210 Member Posts: 205
edited Nov 14, 2012 10:31AM in General Database Discussions
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
Tagged:
Mauricio Chavarry-Oracle

Best Answer

  • 839439
    839439 Member Posts: 568
    edited Sep 24, 2011 5:30AM Accepted Answer
    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
    Mauricio Chavarry-Oracle

Answers

This discussion has been closed.