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

You might also use the oracle8 script orashut.bat that uses 4 parameters including user id and password and calls svrmgr.

In article <01bfc0d9$2bb85480$11f0590c_at_Verma.medco.com>, "Verma" <ranju-ravi_at_worldnet.att.net> wrote:
> 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
> >
> >

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!