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
Printable View
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
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
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
What happens after SHUTDOWN IMMEDIATE.Quote:
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
P.S. I assume you mean 8.1.7.2, not 8.1.7.7 :-)