Shutting Down Oracle on WIN/NT via AT Command

From: Gerry Mulcahey <mulcahey_at_travel-net.com>
Date: 2000/05/17
Message-ID: <39234842.D79CB01A@travel-net.com>#1/1

Hi
I work with Oracle on Unix, but recently installed Oracle 8i on our office server which runs Windows NT. I wanted to setup a batch script that would shutdown Oracle before the automated backups kicked in and start it roughly after the backups completed.

I created a "batch" file which started SVRMGR, connected internal and issued a shutdown command. Works great at the command prompt, but when I submit it via the AT command (which is controlled via Scheduler), I see a message in my log file that it is asking for a password.

I understand why - it's not the same user as when I am at the command prompt.

How does one automate a shutdown and startup in Windows NT without purchasing some software? I should be able to stop Oracle with some command prompt, right?

Thanks.

Gerry
mulcahey_at_travel-net.com Received on Wed May 17 2000 - 00:00:00 CDT