| Script for performing clean shutdown before windows shutdown [message #132661] |
Mon, 15 August 2005 09:52  |
Achchan
Messages: 86
Registered: June 2005
|
Member |
|
|
Hi all,
I need a script to perform a clean oracle shutdown every time that windows going to shutdown.I need this to be sure that there wont be any instance recovery every time I startup the oracle(Mostly I fear from header inconsistency and ...).
Is there any thing that I can deploy for my development sites?
-Your help will be so appreciated
|
|
|
|
| Re: Script for performing clean shutdown before windows shutdown [message #132663 is a reply to message #132661] |
Mon, 15 August 2005 10:01  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
Is setting the startup and shutdown modes of your oracle service using oradim (or probably can do through OEM or some GUI) not sufficient for your case? I would need to check on the specifics, but I think this is my current default behavior when I reboot my pc for the database to reboot, and I believe you can change the shutdown mode from immediate to abort or normal using the shuttype argument to oradim.
|
|
|
|
| Re: Script for performing clean shutdown before windows shutdown [message #132781 is a reply to message #132663] |
Tue, 16 August 2005 03:22 |
Achchan
Messages: 86
Registered: June 2005
|
Member |
|
|
Thanks smartin,
Ofcourse there is a automatic start mode for every service(including oracle services) in Windows.But I did not find how to auto shutdown them exactly before windows going to shutdown.
I did look at oradim parameters again,but using oradim you can only shutdown manually that is not my purpose.
In fact,I need something that does a "net stop oracleservice<sid>" or oradim shutdown automatically before windows shutdown.
-Regards
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
