Re: Shutting Down Oracle on WIN/NT via AT Command

Why don't you try shutting down and starting up using 'oradim' command in your batch script. That way you won't need to start server manager, log in, etc. For help with 'oradim', just issue the command on the NT command prompt.

HTH Gerry Mulcahey <mulcahey_at_travel-net.com> wrote in article <39234842.D79CB01A_at_travel-net.com>...
> 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 Thu May 18 2000 - 00:00:00 CDT