RE: Changing service auto to manual via batch

Hmmm. I don't know of any DOS commands to do it (though I'd imagine they exist), but you could change the Oracle service with the oradim command as well. Something like:

oradim -edit -sid dbsid -startmode manual

might work. I don't have easy access to a windows box to try it but it would behoove one to test this first. I seem to recall it *not* working a few years ago. Perhaps the startmode doesn't refer to the service itself?

-joe

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of J. Dex Sent: Wednesday, July 18, 2007 2:04 PM
To: oracle-l_at_freelists.org
Subject: Changing service auto to manual via batch

Is there a way to change the "running services" status in the "Services"

window from Automatic to Manual via a batch script? I have a batch script
that uses oradim to shutdown/startup my 9207 databases on a WIN2003 server but don't know how to change the status from automatic to manual in the event the server administrator wants to reboot the machine a couple of times
before I have the databases restart. My oradim command in the batch job
looks like this:

oradim -shutdown -sid dbsid -shutmode I -shuttype SRVC >> %BASELOGS%\oracle_shutdown.log

--

http://www.freelists.org/webpage/oracle-l  

Confidentiality Note: This message contains information that may be confidential and/or privileged. If you are not the intended recipient, you should not use, copy, disclose, distribute or take any action based on this message. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Although ICAT Managers, LLC scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. Thank you.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jul 18 2007 - 15:19:04 CDT