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

From: John Stoffel <jfs_at_fluent.com>
Date: 1997/12/08
Message-ID: <rmen3n75gh.fsf@fluent.com>

Hi all,

I've never really run a database before, but I've done lots of SysAdmin work and I think I can read man pages and manuals, but I'm kinda stumped here.

I'm trying to setup archive logs with an Oracle 7.3.3 version server running on a Solaris 2.5.1 system. Whenever I edit the initLWSN.ora file to have the line:

log_archive_start = true # if you want automatic archiving

I get this error on database startup:

    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     SVRMGR> ^D
    Server Manager complete.

I've been reading the "Administrator's Reference" and following it's directions for turning on the Archive log mode. I did the following:

SVRMGR> startup exclusive mount LWSN ORACLE instance started.

    Total System Global Area      36489120 bytes
    Fixed Size                       39808 bytes
    Variable Size                 23178272 bytes
    Database Buffers              13107200 bytes
    Redo Buffers                    163840 bytes

    Database mounted.
    SVRMGR> alter database archivelog;
    Statement processed.
    SVRMGR> shutdown
    ORA-01109: database not open
    Database dismounted.
    ORACLE instance shut down.

Then I edited the initLWSN.ora file to turn on log_archive_start = true, but I get the following:

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

Here's what contained in my configLWSN.ora and initLWSN.ora files:

snip here ====================================
#
# $Header: cnfg.orc 1.1 95/02/27 12:14:25 wyim Osd<unix> $ Copyr (c) 1992 Oracle
#
# cnfg.ora - instance configuration parameters

control_files           = (/accounting/oracle/oradata/LWSN/control01.ctl, 
                           /accounting/oracle/oradata/LWSN/control02.ctl,
                           /accounting/oracle/oradata/LWSN/control03.ctl)


# Below for possible future use...

#init_sql_files          = (?/dbs/sql.bsq,

#                           ?/rdbms/admin/catalog.sql,

#                           ?/rdbms/admin/expvew.sql)

background_dump_dest    = /accounting/oracle/app/oracle/admin/LWSN/bdump
core_dump_dest                  = /accounting/oracle/app/oracle/admin/LWSN/cdump
user_dump_dest                  = /accounting/oracle/app/oracle/admin/LWSN/udump


#log_archive_dest               = /accounting/oracle/app/oracle/admin/LWSN/arch/arch.log

log_archive_dest                = /accounting/oracle/app/oracle/admin/LWSN/arch
log_archive_format              = arch%s.dbf


#db_block_size                  = <blocksize>

 
db_name                 = LWSN


========================== snip here ====================================

#
# $Header: initx.orc 1.1 95/02/27 12:14:56 wyim Osd<unix> $ Copyr (c) 1992 Oracle
#

# include database configuration parameters

ifile                           = /accounting/oracle/app/oracle/admin/LWSN/pfile/configLWSN.ora
 
rollback_segments               = (r01,r02,r03,r04)
 


##############################################################################

# Example INIT.ORA file
#
# This file is provided by Oracle Corporation to help you customize
# your RDBMS installation for your site. Important system parameters
# are discussed, and example settings given.
#
# Some parameter settings are generic to any size installation.
# For parameters that require different values in different size
# installations, three scenarios have been provided: SMALL, MEDIUM
# and LARGE. Any parameter that needs to be tuned according to
# installation size will have three settings, each one commented
# according to installation size.
#
# Use the following table to approximate the SGA size needed for the
# three scenarious provided in this file:
#
# -------Installation/Database Size------
# SMALL MEDIUM LARGE
# Block 2K 4500K 6800K 17000K
# Size 4K 5500K 8800K 21000K
#
# To set up a database that multiple instances will be using, place
# all instance-specific parameters in one file, and then have all
# of these files point to a master file using the IFILE command.
# This way, when you change a public
# parameter, it will automatically change on all instances. This is
# necessary, since all instances must run with the same value for many
# parameters. For example, if you choose to use private rollback segments,
# these must be specified in different files, but since all gc_*
# parameters must be the same on all instances, they should be in one file.
#
# INSTRUCTIONS: Edit this file and the other INIT files it calls for
# your site, either by using the values provided here or by providing
# your own. Then place an IFILE= line into each instance-specific
# INIT file that points at this file.
###############################################################################

# tuning parameters

db_files = 255
open_cursors=400
session_cached_cursors=100

# db_file_multiblock_read_count = 8 # SMALL
# db_file_multiblock_read_count = 16 # MEDIUM

 db_file_multiblock_read_count = 32                                  # LARGE  



# db_block_buffers = 200                                                # SMALL  

# db_block_buffers = 550                                              # MEDIUM 

 db_block_buffers = 6400                                             # LARGE  
 


# shared_pool_size = 3500000                                            # SMALL

# shared_pool_size = 6000000                                          # MEDIUM

 shared_pool_size = 20000000                                          # LARGE

log_checkpoint_interval = 10000

# processes = 50 # SMALL
# processes = 100 # MEDIUM

 processes = 200                                                     # LARGE  
 


# dml_locks = 100                                                       # SMALL  

# dml_locks = 200                                                     # MEDIUM 

 dml_locks = 500                                                     # LARGE
 


# log_buffer = 8192                                                     # SMALL

# log_buffer = 32768                                                  # MEDIUM

 log_buffer = 163840                                                 # LARGE
 


# sequence_cache_entries = 10                                           # SMALL  

# sequence_cache_entries = 30                                         # MEDIUM 

 sequence_cache_entries = 100                                        # LARGE  
 


# sequence_cache_hash_buckets = 10                                      # SMALL  

# sequence_cache_hash_buckets = 23                                    # MEDIUM 

 sequence_cache_hash_buckets = 89                                    # LARGE  
 
audit_trail = true            # if you want auditing
timed_statistics = true       # if you want timed statistics
max_dump_file_size = 10240      # limit trace file size to 5 Meg each
              
log_archive_start = true      # if you want automatic archiving

# compatible = 7.1.0.0
# global_names = TRUE

use_readv=TRUE

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


========================== snip here ====================================

Thanks for any hints or info you can provide, I'm stumped!

John

     John Stoffel - Senior Unix Systems Administrator - Fluent, Inc.
        jfs@fluent.com - http://www.fluent.com - 603-643-2600 x341
		  Honk if you love peace and quiet!

Received on Mon Dec 08 1997 - 00:00:00 CST