| Windows Oracle services [message #273910] |
Fri, 12 October 2007 03:35  |
Phillawson
Messages: 18
Registered: December 2006
Location: Derby UK
|
Junior Member |
|
|
Hi, I need to shut my Oracle 10G database down for a few hours each weekend whilst the server it is on has work carried out on it. I've been told that just shutting down the oracle windows service is the equivalent to the database crashing and that I should shut the database down using sql or Enterprise Manager.
is it true about the service advice? and if so how can I create a job to carry out a safe shutdown.
I've tried a command line sqlplus method logging in as / but I need to be able to automate the task as it needs to run at 3am.
Can anyone help please?
|
|
|
|
|
|
| Re: Windows Oracle services [message #273919 is a reply to message #273913] |
Fri, 12 October 2007 04:21  |
Phillawson
Messages: 18
Registered: December 2006
Location: Derby UK
|
Junior Member |
|
|
|
Ah, thats my problem. I've been sitting here quite a while trying to create a .cmd file to shut the database down using oradim rather than shutting down the services but I can't seem to work out how to do it. I've even gone as far as checking the Oracle documentation and it's easy if I'm willing to sit at the machine and do it manually so I know it works but I want to do it automatically by scheduling the .cmd file. does this make sense?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
