Re: ORA-00443: background process "ARCH" did not start

From: John Stoffel <jfs_at_fluent.com> >>
 SVRMGR> startup

    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 <<

Your problem appears to be that you may have failed to set a couple of init.ora parameters identifeid in Oracle's rocommended procedure (Admin Guide) for changing the database to be in archive log mode or you left a couple of items out of your post. May I recommend that you compare your procedure to the following.

1. Set init.ora parameters: log_archive_dest and log_archive_format
2. With log_archive_start=false start the database as 'startup mount'
3. Issue 'alter database archivelog;' then open the database
4. Now issue 'alter system archive log start' -- If you get an error you probably made a mistake in the init.ora dest or format parms
5. Change log_archive_start to true and bounce (cycle) Oracle to verify everything works

If does not work see chapter 22 of 7.3 Admin Guide or Ch. 17 or version 7 Admin Guide as you should be very close. Good luck.

Mark Powell -- Oracle 7 Certified DBA
- The only advise that counts is the advise that you follow so follow your own advise - Received on Wed Dec 10 1997 - 00:00:00 CST