RE: Remotely stopping an Oracle 10g instance on window 2000

Thank you all very much for your replies. I was swamped today and didn't get a chance to test out your suggestions but will first thing tomorrow and will post a follow up.

As for implementing some form of Linux, I'm sure it would never be noticed well at least till my contract is up and then I won't get a good reference:)

--Ken

-----Original Message-----
From: Grant Allen [mailto:Grant.Allen_at_towersoft.com.au] Sent: Monday, May 16, 2005 6:41 PM
To: kennaim_at_gmail.com; oracle-l
Subject: RE: Remotely stopping an Oracle 10g instance on window 2000

> Dear List,
>
> I have been an Oracle DBA\Developer solely on Unix platforms and have
> now inherited the task of administering a new Oracle 10g instance on a
> Windows 2k server. We are using backup exec to do weekly cold backups
> and wanted to know how to remotely stop and start the database from
> the backup server. I have attempted using sc and net start/stop to
> remotely stop the services without success. With sc I get
>
> C:\>d:\sc \\oratest stop oracleservicedw [SC] ControlService FAILED,
> rc = 1051
>
> I cannot find a definition of what rc=1051 means.

Ah, the joys of windoze. Admin Sanity lesson #5001: "What the F*&^ does that error mean?". Answer: net helpmsg

c:\> net helpmsg 1051

  A stop control has been sent to a service that other running services are dependent on.

Mystery revealed. Check your other Oracle services on the windoze box ... ClientCache, Cman, Cmanadmin, Agent, etc. to see which depend on the instance's service, and stop those first. Then your 1051 error should disappear. Once sanity has returned, swap in a copy of CentOS, RHEL or SLES while no one's watching, and place bets to see how soon it will be noticed. I'd say at least six months :-)

Ciao
Fuzzy
:-)

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