RE: Changing service auto to manual via batch
- From: jherrick@xxxxxxx
- To: JSweetser@xxxxxxxx
- Date: Wed, 18 Jul 2007 17:04:33 -0400
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@xxxxxxxx>:
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of J. Dex
Sent: Wednesday, July 18, 2007 2:04 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
