RE: Changing service auto to manual via batch

  • From: "Ted Coyle" <oracle-l@xxxxxxxxxxxx>
  • To: <Joel.Patterson@xxxxxxxxxxx>, <cemail_219@xxxxxxxxxxx>
  • Date: Thu, 19 Jul 2007 17:11:34 -0400

Here's a vbscript example:
Save this with .vbs extension.
Set ServiceName variable
Set script environment to cscript if echoing to screen
Call "ScriptName.vbs a" for Auto or "m" for manual.
This file can be called from .bat

'------Script Begin
Dim WshShell, oArgs, RegKey, ServiceName, StartMode
Set WshShell=CreateObject("WScript.Shell")
Set oArgs = WScript.Arguments
ServiceName = OracleService<YourService>
RegKey="HKLM\SYSTEM\CurrentControlSet\Services\" & ServiceName & "\Start"
Select Case UCase(oArgs.Item(0))
  Case "M" 
     StartMode = "00000003"
  Case "A"
     StartMode = "00000002"
End Select
'Wscript.echo Startmode
WshShell.RegWrite regKey,StartMode,"REG_DWORD"
'---------Script End

You could also use named arguments or add servicename as argument.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Joel.Patterson@xxxxxxxxxxx
Sent: Thursday, July 19, 2007 9:32 AM
To: cemail_219@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Changing service auto to manual via batch


Type 'sc' at the DOS prompt and see if anything there will work for you.
Certainly deleting the service works, as I use that for listener
services etc.

Joel Patterson
Database Administrator
joel.patterson@xxxxxxxxxxx
x72546
904  727-2546

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of J. Dex
Sent: Wednesday, July 18, 2007 4: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


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


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


Other related posts: