[62308] in SAPr3-news
Re: UPS shutdown scripts for SAP / MS SQL Server on Windows 2003 - solution
daemon@ATHENA.MIT.EDU (riggor9999)
Sun Jan 10 14:32:56 2010
To: sapr3-news@mit.edu
Date: Sun, 10 Jan 2010 14:32:19 -0500
From: "riggor9999" <riggor9999@nospam_yahoo.com>
Message-ID: <hida0d$7o3$1@news.eternal-september.org>
Reply-To: "riggor9999" <riggor9999@nospam_yahoo.com>
I think I figured it out (much easier with MS SQL Server versus Oracle on
Windows). It appears to be working. I can run the script as "soladm" in
the power options, alarm actions ... and it shuts down all instances using
one user id.
Any suggestions?
E:\usr\sap\SOL\DVEBMGS00\exe\stopsap.exe name=SOL nr=00 SAPDIAHOST=willow
E:\usr\sap\SOL\DVEBMGS00\exe\stopsap.exe name=SOL nr=01 SAPDIAHOST=willow
E:\usr\sap\CRM\DVEBMGS02\exe\stopsap.exe name=CRM nr=02 SAPDIAHOST=willow
E:\usr\sap\SMD\exe\stopsap.exe name=SMD nr=98 SAPDIAHOST=willow
net stop "SQL Server Agent (MSSQLSERVER)"
net stop mssqlserver
"riggor9999" <riggor9999@nospam_yahoo.com> wrote in message
news:hid0h9$uqm$1@news.eternal-september.org...
> Hello -
>
> I posted this a few months ago - but I have since changed from Oralce to
> MS-SQL Server 2005. I still have the same problem ....
>
> We normally run Unix / Oracle, but I now have a sandbox running two SAP
> instances (Sol Man 7.0 and CRM 7.0 IDES) on Windows 2003 / MS SQl Server
> 2005.
>
> I am trying write windows scripts to stop SAP and stop MS SQL Server
> instances when the UPS senses a power failure / low battery. This was
> very easy with Unix as "stopsap" will stop SAP and the database. While in
> windows "stopsap" only stops SAP, not MS SQL Server.
>
> Years ago - on Win2K / 4.6C ... I could issue a "sapdba -shutdown" command
> and that worked just fine, but I am now having trouble with brtools and
> brspace at the command line.
>
> When I issue a "brspace -f dbshut -mode normal -confirm force" ... I still
> get the brtools menu to confirm /
> interact. I need this to be automated without human interaction.
>
> Does anyone have any experience with this? I have googled and searched
> but have not found a simple / elegant way.
>
> The other factor is that I have two SAP instances and two MS SQL Server
> instances - which I need to be able to run once script, as Administrator
> to to stop both SAP and MS SQL Server instances.
>
> Bottom line is - I need a Windows 2003 cmd script to run an automated SAP
> and MS SQL shutdown for two instances as Administrator when the OS / UPS
> senses a power loss / low battery condition.
>
> Thanks in advance.
>
>
>
