database stuck up after opening
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: database stuck up after opening

  1. #1
    Join Date
    Jul 2000
    Location
    India
    Posts
    60
    hi,

    whenever i start my database instance, the alert file shows that the database has been mounted in exclusive mode. it also shows "alter database open". but after that, the oracle instance simply keeps on processing but the the instance does startup completely. while connecting, it shows, "initisaisation or shutdown in progress". this goes on for hours. how can i rectify this ?

    satish

  2. #2
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Can you shutdown your db with normal/immediate option?

    If not, shutdown with abort option then try
    startup mount
    recover database;

    If there is a media failure recovered:
    alter database open noresetlogs; /*or resetlogs*/

    otherwise
    alter database open;

    But as usual make a backup first, before anything else.

    If you can post more details of your problem like after an instance started
    is your database mounted, and opened normally, error codes, specs of your db and platform, etc. Then this will give more info to troubleshoot your problem.




  3. #3
    Join Date
    Oct 2000
    Posts
    467
    What oracle ./OS version r u running. Check out your alert log and related trace files and post them here.

    Cheers
    Vinit

Posting Permissions

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


Click Here to Expand Forum to Full Width