RE: Changing service auto to manual via batch

There is no DOS command that can do it but it can be done by shelling out to a WSH script that uses WMI active-X objects.

I've written ASP pages that use WMI to start and stop services locally or remotely. It's been a while though so it will take some time to cobble a script
together.

Quoting "Sweetser, Joe" <JSweetser_at_icat.com>:

> 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://newlivehotmail.com
>
> --
> 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
>
>
>

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