Problems w/auto archiving - UNIX

From: Ken Johnson <kjohn_at_rdatasys.com>
Date: 1995/12/13
Message-ID: <4anoc4$m3r_at_lionfish.rdatasys.com>#1/1

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:

.
.
.

# Below for possible future use...
#init_sql_files          = (?/dbs/sql.bsq,
#                           ?/rdbms/admin/catalog.sql,
#                           ?/rdbms/admin/expvew.sql)
background_dump_dest    = /amd/oracle/admin/db71/bdump
core_dump_dest          = /amd/oracle/admin/db71/cdump
user_dump_dest          = /amd/oracle/admin/db71/udump
log_archive_dest        = /amd/oracle/admin/db71/archive/db71
log_archive_format      = _%s.arc
#db_block_size          = <blocksize>

db_name                 = db71

.
.
.

log_archive_start = true # if you want automatic archiving

mts_dispatchers="ipc,1"
mts_max_dispatchers=10
mts_servers=1
mts_max_servers=10
mts_service=db71
mts_listener_address="(ADDRESS=(PROTOCOL=ipc)(KEY=db71))"

I installed Oracle 7.0.17 on a Sparc1000 running Solaris 2.3 last February and did not have this problem, but installing Oracle on an HP-720 here last I ran into a similar problem. The only difference (that I can detect) between the two sites is that we use AMD (auto mounting software for file systems). ORACLE_HOME is defined as:

/amd/oracle/7.1 (a link to /u/g/oracle/7.1).

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

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

Received on Wed Dec 13 1995 - 00:00:00 CET