Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Stopping and Starting instances from batch (NT)
Hi Ken,
without looking at the actual code this may be difficult.
Are you using oradim?? to accomplish the shutdown. If you shut both the
instance and the service, this should work without problem.
The other solution is calling svrmgr?? using a command line like
svrmgr23 @shutdown.sql
However, in this case, the services will still be running, and files left
open.
Hth,
Sybrand Bakker, Oracle DBA
Ken Rachynski wrote:
> Good day,
>
> I'm having some difficulty trying to do cold backups of my Oracle8
> databases. I have two instances that I would like backed up. When I shut
> one down from my backup program, it shut down just fine, except that 1)
> the password I was using was now embedded in the backup log and 2) I
> needed to shut the other instance down, too. So I moved the command to a
> Windows NT .CMD file and have discovered that, even though the shut down
> log indicates that the instance was shut down, the instance remains open
> and my backup complains that the files are in use. I was trying to use
> the orashut.bat file that is in my database folder. The batch file
> describes how it is called from the NT service manager so I coded my
> file with two calls to this batch file properly encoded. Indeed,
> shutting down from the command line seems to work. Any ideas on how I
> can rework my command file to actually shut down the instances?
>
> --
> Ken Rachynski
> Database Analyst
> krachyn_at_cadvision.com
> <http://www.cadvision.com/krachyn>
> ICQ: 3113514
Received on Fri Feb 26 1999 - 00:13:21 CST