Re: redo log archiving under Oracle 8

Thomas Lohman (thomasl_at_mtl.mit.edu) wrote:

: SVRMGR> archive log start;
: ORA-00443: background process "ARCH" did not start
: ORA-07274: spdcr: access error, access to oracle denied.
: SVR4 Error: 2: No such file or directory

I'd like to followup on my own posting in case anyone else ever comes across this nasty problem. It seems Oracle decided to leave some type of hidden undocumented "testing" feature active in the production system. If you have environment variables set in your environment that correspond to instance executable names (i.e. ARCH, LGWR, etc.) then Oracle will attempt to run whatever they are set to instead of running Oracle's own binaries. It turns out we do indeed set ARCH for users in our environment, thus my problem. Anyone who is interested is learning a tad more, they can go to dejanews.com and do a search for 'spdcr' within the comp.databases.oracle.server archive and they'll get a few articles regarding this very same problem under Oracle 7.x

cheers,

--tom Received on Sat Apr 24 1999 - 08:56:27 CDT