Database Shutdown Problem!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Database Shutdown Problem!

  1. #1
    Join Date
    Nov 2001
    Location
    Delhi
    Posts
    31

    Angry


    Dear friends!
    My oracle (8.1.7.7) is running on solaris 7 and also on Win-2000 When I am shutting down database In Normal mode it is not working only shutdown Abort is working.Please suggest me to how can I solve the problem
    Thanks

  2. #2
    Join Date
    Mar 2001
    Posts
    188
    hey akimtiaz,

    look at the folowing link, there is a very good description

    http://www.dbasupport.com/forums/sho...threadid=17678

    So long Thomas Schmidt
    Best Regards
    Thomas Schmidt

    Thomas_Schmidt@eplus-online.de
    If you have no aims, you will never reach a goal !!!

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    Okay when u try to shutdown the database through NORMAL option ,Oracle waits for the connected users to get disconnected.Till the users are not disconnected Oracle waits for the shutdown.Now in ur case shutdown abort works so the next time when Oracle starts up it performs instance recovery .What u do is that u do a shutdown abort of the database and startup and again shutdown in immediate option.
    Try it out and it will work then on.....

    In case of any help please be free to ask me at rohitsn@altavista.com

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by akimtiaz

    Dear friends!
    My oracle (8.1.7.7) is running on solaris 7 and also on Win-2000 When I am shutting down database In Normal mode it is not working only shutdown Abort is working.Please suggest me to how can I solve the problem
    Thanks
    What happens after SHUTDOWN IMMEDIATE.

    P.S. I assume you mean 8.1.7.2, not 8.1.7.7 :-)


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