Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    70

    Exclamation Unanswered: Alter Database Open

    Hi All,

    My Database is in a Mount State. I confirmed it from
    doing
    SELECT * FROM V$INSTANCE;

    Now to open the database, I am doing
    ALTER DATABASE OPEN;

    But it says that
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01531: a database already open by the instance

    I checked v$session also, no other session is running. Can anyone tell why and when such situation come,
    and how to open the database without shuting down and restarting it.


    Regards,
    qAnand

  2. #2
    Join Date
    Jul 2003
    Posts
    70

    Exclamation Alter Database Open

    I forgot to add this info:

    Actually the database was open previously. I did ALTER DATABASE CLOSE NORMAL
    which went to MOUNT state. Now when I try to open it using ALTER DATABASE OPEN;
    it doesn't work.

    Please help

    Regards,
    qAnand

  3. #3
    Join Date
    Nov 2002
    Posts
    833
    it sounds some background processes are (still) running...

    shutdown immediate

    and then try to startup again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •