10gR2 cannot startup ORA-01092 + ORA-00704 + ORA-39700
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: 10gR2 cannot startup ORA-01092 + ORA-00704 + ORA-39700

Hybrid View

  1. #1
    Join Date
    Oct 2005
    Posts
    1

    10gR2 cannot startup ORA-01092 + ORA-00704 + ORA-39700

    Hello, I cannot startup a newly created 10gR2.
    I use the same scripts that perfectly worked on 10gR1.
    (Solaris 10)

    At database open time I get:
    ORA-01092: ORACLE instance terminated. Disconnection forced

    In the used dump directory there is this message:
    ORA-00704: bootstrap process failure
    ORA-39700: database must be opened with UPGRADE option

    This is the whole dump file:
    << START TRACE >>
    Dump file /opt/oracle/admin/instances/omc/udump/omc_ora_23941.trc
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP and Data Mining options
    ORACLE_HOME = /opt/oracle/product/10.1.0/db_1
    System name: SunOS
    Node name: ssrv47sd
    Release: 5.10
    Version: Generic
    Machine: sun4u
    Instance name: omc
    Redo thread mounted by this instance: 1
    Oracle process number: 35
    Unix process pid: 23941, image: oracle@ssrv47sd (TNS V1-V3)

    *** SERVICE NAME:() 2005-10-04 16:38:00.999
    *** SESSION ID:(1039.3) 2005-10-04 16:38:00.999
    Successfully allocated 2 recovery slaves
    Using 550 overflow buffers per recovery slave
    Thread 1 checkpoint: logseq 65, block 4992, scn 248174
    start recovery at logseq 65, block 4992, scn 248174
    ----- Redo read statistics for thread 1 -----
    Read rate (ASYNC): 0Kb in 0.17s => 0.00 Mb/sec
    Total physical reads: 4096Kb
    Longest record: 0Kb, moves: 0/1 (0%)
    Longest LWN: 0Kb, moves: 0/1 (0%), moved: 0Mb
    Last redo scn: 0x0000.0003c96f (248175)
    ----------------------------------------------
    ----- Recovery Hash Table Statistics ---------
    Hash table buckets = 32768
    Longest hash chain = 0
    Average hash chain = 0/0 = 0.0
    Max compares per lookup = 0
    Avg compares per lookup = 0/0 = 0.0
    ----------------------------------------------
    *** 2005-10-04 16:38:01.323
    KCRA: start recovery claims for 0 data blocks
    *** 2005-10-04 16:38:01.324
    KCRA: blocks processed = 0/0, claimed = 0, eliminated = 0
    *** 2005-10-04 16:38:01.326
    Recovery of Online Redo Log: Thread 1 Group 2 Seq 65 Reading mem 0
    ----- Recovery Hash Table Statistics ---------
    Hash table buckets = 32768
    Longest hash chain = 0
    Average hash chain = 0/0 = 0.0
    Max compares per lookup = 0
    Avg compares per lookup = 0/0 = 0.0
    ----------------------------------------------
    ORA-00704: bootstrap process failure
    ORA-39700: database must be opened with UPGRADE option
    << END TRACE >>

    Any suggestion?
    Thanks,
    Robert

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Explanation:
    This is a general error reported at startup when there is some
    problem during processing of bootstrap information.

    There should be an accompanying error/s.

    Diagnosis:
    - See the accompanying error/s for more information.

    - Shutdown abort the instance and clean up any OS structures
    used by the instance. Eg: Ensure there is no shared memory,
    semaphores etc.. left lying around

    - Retry the startup.

    - If the error persists follow up on the accompanying errors
    (Eg: block corruption etc.. could cause this.)

    Regards
    Rohit S Nirkhe
    oracle DBA
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

Posting Permissions

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


Click Here to Expand Forum to Full Width