Re: Problems w/auto archiving - UNIX

From: Nalini Vallampati <nalini.vallampati_at_daytonoh.attgis.com>
Date: 1995/12/14
Message-ID: <DJL2qn.5yM_at_ranger.daytonoh.attgis.com>#1/1


>In article <4anoc4$m3r_at_lionfish.rdatasys.com> Ken Johnson writes:
>I have just installed Oracle 7.1.6 on our Sparc20 running Solaris 2.4
>and am having a problem with starting up automatic archiving.
>
>The database is in archivelog mode, I've set up the archive
>destination
>and format, and put in the log_archive_start=TRUE statements in the
>init.ora file. When I try to start up the database I get the following
>error message:
>
>SQLDBA> 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
>
>Doing an "oerr" on these errors I get:
>07274, 00000, "spdcr: access error, access to oracle denied."
>// *Cause: Unable to access "oracle" program. Verify ?/bin/oracle or
>// $ORABCKPRG exist, and are executable.
>// *Action: Check errno returned.
>
>00443, 00000, "background process \"%s\" did not start"
>// *Cause: The specified process did not start.
>// *Action: Ensure that the executable image is in the correct place
>with
>// the correct protections, and that there is enough memory.
>
>With the log_archive_start parameter commented out the database starts
>
>up okay. The initdb71.ora file looks like this:
>

Looks like a permissions problem. Make sure that the log_archive_dest files are writable, and the permissions are set for the right user.

<snip>

>Any help or ideas are appreciated. Also, I not quite sure how to get
>in touch with technical support at Oracle.

If you have a support agreement with Oracle, call (415) 506 1500.

>Thanks!
>
> _______________________________________________________
>
>Ken Johnson Relational Data Systems
>Phone: (714)263-3899 ext 135 30 Executive Park Suite 260
>Internet: kjohn_at_rdatasys.com Irvine, Ca 92714
>>

Nalini Vallampati
UNIX Admin/Oracle DBA
AT&T Capital Corp.
Miamisburg, Ohio 45342

Nalini Vallampati
UNIX Admin/Oracle DBA
AT&T Capital - GIS
Miamisburg, OH 45342 Received on Thu Dec 14 1995 - 00:00:00 CET

Original text of this message