Re: ARCH won't start ***URGENT***

Dave,

I did have such a variable. and used as you described....Removing/changing it did wonders. I would never have even thought to look at that.

Thanks a lot for your help.

john

Dave Wotton wrote:

> John wrote in message <38A70367.69A4E368_at_napanet.net>...
> >I'm having a problem whose answer should be obvious, but I don't see
> >it.
> >
> >Yesterday, an offline backup script that I was testing forced a database
> >down with shutdown abort (dumb) and now I can not get the ARCH process
> >to start....
>
> Have you recently created an environment variable called ARCH?
>
> There is an undocumented feature of Oracle (at least, of 7.3.3, and
> probably later): if you've got variables called ARCH, PMON, SMON, etc.
> Oracle uses these at startup to locate the ARCH, PMON, SMON executables.
> (Probably used by the developers for testing). It's unlikely you'd
> create variables of these names. But you might use ARCH to hold the
> name of your archive directory.
>
> I hit this one several months ago. Took days to track down.
>
> Dave.
> --
> There's no need to reply to this posting by email, but if you do,
> remove the "nospam" from my email address first.
Received on Mon Feb 14 2000 - 12:08:39 CST