Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    6

    Unanswered: Could not start database

    When I try to open my database as SYSTEM I get the following message:
    ORA-01033 Oracle initialization or shutdown in progress.

    When I try to open the database as SYS it works fine.

    Does anybody have suggestions?

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Check your alertlog .. you may find that the database is on exclusive or
    that the database is just mounted and not open (may need recovery)...

    Post the last part of your alertlog ...

    Gregg

  3. #3
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    You can find out the status of your database with the following command:

    select status from v$instance;

    This will at least let you know if the database is mounted, open etc.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  4. #4
    Join Date
    Sep 2003
    Posts
    6

    Unhappy Database is mounted

    The database is just mounted and not open. There is probably a problem with the system datafile. Is the only way replacing a backup or are there other recovery solutions?

  5. #5
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Again, post the last bit of your alertlog so we can see what's going on ...
    If there is a file that needs recovery, you'll see it in v$recover_file;
    select * from v$recover_file;

    Gregg

Posting Permissions

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