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

From: Dave Wotton <Dave.Wotton_at_dwotton.nospam.clara.co.uk>
Date: Mon, 14 Feb 2000 07:49:50 GMT
Message-ID: <ysOp4.9215$uc.202351@nnrp4.clara.net>

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 - 01:49:50 CST