Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    23

    Unanswered: Restarting dead background process SNP0, SNP1, etc

    Oracle Server 8.1.7.0.0 on Win2000 SP4

    We have a test database set up as a copy of production. A coworker had originally set this up by doing a flat file transfer of all the db files, then recreating the instance and doing a recover database to rebuild the control files. We're getting an error when connecting and updating via the main application - ORA-01331 end of communication channel failure. We have built other test dbs in this manner with no problems. There are no obvious errors in the alert.log. The only thing I spot is that the SNPx processes are restarting over and over again, about every 5 minutes. This is not happening on prod or any of our other test instances.

    Any ideas? Thanks.

    Dump file C:\oracle\admin\CHFITEST\bdump\chfitestALRT.LOG
    Wed Apr 14 11:31:15 2004
    ORACLE V8.1.7.0.0 - Production vsnsta=0
    vsnsql=e vsnxtr=3
    Windows 2000 Version 5.0 Service Pack 4, CPU type 586
    Starting up ORACLE RDBMS Version: 8.1.7.0.0.
    System parameters with non-default values:
    processes = 150
    shared_pool_size = 250000000
    java_pool_size = 30000000
    control_files = C:\oracle\oradata\CHFITEST\control01.ctl, C:\oracle\oradata\CHFITEST\control02.ctl, C:\oracle\oradata\CHFITEST\control03.ctl
    db_block_buffers = 15000
    db_block_size = 8192
    compatible = 8.1.0.0.0
    log_buffer = 32768
    log_checkpoint_interval = 10000
    log_checkpoint_timeout = 1800
    db_files = 1024
    db_file_multiblock_read_count= 8
    rollback_segments = RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6, RBS7, RBS8, RBS9
    max_enabled_roles = 30
    remote_login_passwordfile= EXCLUSIVE
    db_domain = SICPA
    global_names = FALSE
    distributed_transactions = 10
    instance_name = CHFITEST
    service_names = CHFITEST.SICPA
    sort_area_size = 131072
    sort_area_retained_size = 65536
    db_name = CHFITEST
    open_cursors = 600
    os_authent_prefix =
    utl_file_dir = c:\temp\utl
    job_queue_processes = 2
    job_queue_interval = 10
    parallel_max_servers = 5
    background_dump_dest = C:\oracle\admin\CHFITEST\bdump
    user_dump_dest = C:\oracle\admin\CHFITEST\udump
    max_dump_file_size = 10240
    oracle_trace_collection_name=
    PMON started with pid=2
    DBW0 started with pid=3
    LGWR started with pid=4
    CKPT started with pid=5
    SMON started with pid=6
    RECO started with pid=7
    SNP0 started with pid=8
    SNP1 started with pid=9
    Wed Apr 14 11:31:17 2004
    alter database mount exclusive
    Wed Apr 14 11:31:21 2004
    Successful mount of redo thread 1, with mount id 4158249097.
    Wed Apr 14 11:31:21 2004
    Database mounted in Exclusive Mode.
    Completed: alter database mount exclusive
    Wed Apr 14 11:31:21 2004
    alter database open
    Beginning crash recovery of 1 threads
    Wed Apr 14 11:31:22 2004
    Thread recovery: start rolling forward thread 1
    Recovery of Online Redo Log: Thread 1 Group 3 Seq 15 Reading mem 0
    Mem# 0 errs 0: D:\ORACLE\ORADATA\CHFITEST\REDO01.LOG
    Wed Apr 14 11:31:23 2004
    Thread recovery: finish rolling forward thread 1
    Thread recovery: 25 data blocks read, 25 data blocks written, 35 redo blocks read
    Crash recovery completed successfully
    Wed Apr 14 11:31:23 2004
    Thread 1 advanced to log sequence 16
    Thread 1 opened at log sequence 16
    Current log# 1 seq# 16 mem# 0: D:\ORACLE\ORADATA\CHFITEST\REDO03.LOG
    Successful open of redo thread 1.
    Wed Apr 14 11:31:23 2004
    SMON: enabling cache recovery
    SMON: enabling tx recovery
    Wed Apr 14 11:31:25 2004
    Completed: alter database open
    Wed Apr 14 11:32:28 2004
    Restarting dead background process SNP0
    SNP0 started with pid=8
    Wed Apr 14 11:32:28 2004
    Restarting dead background process SNP1
    SNP1 started with pid=9

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246

    Re: Restarting dead background process SNP0, SNP1, etc

    Sometimes this has nothing to do with dead processes. I had the error yesterday, and it turned out a sys admin disconnected the SAN storage array without first asking me to shutdown the database. The control files and on-line redo logs were toasted. Fortunately, I had a good recovery plan.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •