Problems w/auto archiving - UNIX
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).
Thanks!
Ken Johnson Relational Data Systems Phone: (714)263-3899 ext 135 30 Executive Park Suite 260 Internet: kjohn_at_rdatasys.com Irvine, Ca 92714Received on Wed Dec 13 1995 - 00:00:00 CET