Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2004
    Posts
    24

    Unanswered: Error while startup (ORA-01092: ORACLE instance terminated)

    All,

    Iam a DB2 UDB DBA and my manager asked me to create a oracle database for some new initiative.

    Our sysadmins installed Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 in linux.

    but having issues while starting up the oracle.

    SQL> startup
    ORACLE instance started.

    Total System Global Area 100663296 bytes
    Fixed Size 1217884 bytes
    Variable Size 88083108 bytes
    Database Buffers 8388608 bytes
    Redo Buffers 2973696 bytes
    Database mounted.
    ORA-01092: ORACLE instance terminated. Disconnection forced

    Can anyone help me here. Really appreciate ur help.

    Thanks in advance.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    locate alert_SID.log file.
    It will contain a report of the failure; which includes the fully qualified pathname of the trace file.

    Post back here both the tail -80 alert_SID.log & head -200 of the trace file.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Sep 2004
    Posts
    24
    Thanks for the quick response. Here are the details

    LICENSE_MAX_USERS = 0
    SYS auditing is disabled
    ksdpec: called for event 13740 prior to event group initialization
    Starting up ORACLE RDBMS Version: 10.2.0.1.0.
    System parameters with non-default values:
    processes = 50
    shared_pool_size = 62914560
    control_files = /home/oracle/app/oracle/product/10.2.0/db_1/dbs/ora_control1, /home/oracle/app/oracle/product/10.2.0/db_1/dbs/ora_control2
    db_block_buffers = 1024
    log_buffer = 2927616
    log_checkpoint_interval = 10000
    db_files = 80
    db_file_multiblock_read_count= 8
    global_names = TRUE
    instance_name = awqmdb
    parallel_max_servers = 5
    background_dump_dest = /home/oracle/admin/awqmdb/bdump
    user_dump_dest = /home/oracle/admin/awqmdb/udump
    max_dump_file_size = 10240
    core_dump_dest = /home/oracle/admin/awqmdb/cdump
    db_name = awqmdb
    PMON started with pid=2, OS id=15696
    PSP0 started with pid=3, OS id=15698
    MMAN started with pid=4, OS id=15700
    DBW0 started with pid=5, OS id=15702
    LGWR started with pid=6, OS id=15704
    CKPT started with pid=7, OS id=15706
    SMON started with pid=8, OS id=15708
    RECO started with pid=9, OS id=15710
    MMON started with pid=10, OS id=15712
    MMNL started with pid=11, OS id=15714
    Wed Jul 2 14:26:24 2008
    ALTER DATABASE MOUNT
    Wed Jul 2 14:26:28 2008
    Setting recovery target incarnation to 1
    Wed Jul 2 14:26:28 2008
    Successful mount of redo thread 1, with mount id 3773061392
    Wed Jul 2 14:26:28 2008
    Database mounted in Exclusive Mode
    Completed: ALTER DATABASE MOUNT
    Wed Jul 2 14:26:28 2008
    ALTER DATABASE OPEN
    Wed Jul 2 14:26:28 2008
    Beginning crash recovery of 1 threads
    parallel recovery started with 2 processes
    Wed Jul 2 14:26:28 2008
    Started redo scan
    Wed Jul 2 14:26:28 2008
    Completed redo scan
    1 redo blocks read, 0 data blocks need recovery
    Wed Jul 2 14:26:28 2008
    Started redo application at
    Thread 1: logseq 22, block 2, scn 572888
    Wed Jul 2 14:26:28 2008
    Recovery of Online Redo Log: Thread 1 Group 2 Seq 22 Reading mem 0
    Mem# 0 errs 0: /home/oracle/app/oracle/product/10.2.0/db_1/dbs/log2awqmdb.dbf
    Wed Jul 2 14:26:28 2008
    Completed redo application
    Wed Jul 2 14:26:28 2008
    Completed crash recovery at
    Thread 1: logseq 22, block 3, scn 592890
    0 data blocks read, 0 data blocks written, 1 redo blocks read
    Wed Jul 2 14:26:28 2008
    Thread 1 advanced to log sequence 23
    Thread 1 opened at log sequence 23
    Current log# 1 seq# 23 mem# 0: /home/oracle/app/oracle/product/10.2.0/db_1/dbs/log1awqmdb.dbf
    Successful open of redo thread 1
    Wed Jul 2 14:26:28 2008
    MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
    Wed Jul 2 14:26:28 2008
    SMON: enabling cache recovery
    Wed Jul 2 14:26:28 2008
    Errors in file /home/oracle/admin/awqmdb/udump/awqmdb_ora_15722.trc:
    ORA-00704: bootstrap process failure
    ORA-39700: database must be opened with UPGRADE option
    Wed Jul 2 14:26:28 2008
    Error 704 happened during db open, shutting down database
    USER: terminating instance due to error 704
    Instance terminated by USER, pid = 15722
    ORA-1092 signalled during: ALTER DATABASE OPEN...


    head -200 alert_awqmdb.log
    Tue Jul 1 17:09:13 2008
    Starting ORACLE instance (normal)
    Tue Jul 1 17:09:13 2008
    System parameter db_block_buffers enabled without VLM on.
    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    Picked latch-free SCN scheme 2
    Using LOG_ARCHIVE_DEST_1 parameter default value as /home/oracle/app/oracle/product/10.2.0/db_1/dbs/arch
    Autotune of undo retention is turned off.
    LICENSE_MAX_USERS = 0
    SYS auditing is disabled
    ksdpec: called for event 13740 prior to event group initialization
    Starting up ORACLE RDBMS Version: 10.2.0.1.0.
    System parameters with non-default values:
    processes = 50
    shared_pool_size = 62914560
    control_files = /home/oracle/app/oracle/product/10.2.0/db_1/dbs/ora_control1, /home/oracle/app/oracle/product/10.2.0/db_1/dbs/ora_control2
    db_block_buffers = 1024
    log_buffer = 2927616
    log_checkpoint_interval = 10000
    db_files = 80
    db_file_multiblock_read_count= 8
    global_names = TRUE
    instance_name = awqmdb
    parallel_max_servers = 5
    background_dump_dest = /home/oracle/admin/awqmdb/bdump
    user_dump_dest = /home/oracle/admin/awqmdb/udump
    max_dump_file_size = 10240
    core_dump_dest = /home/oracle/admin/awqmdb/cdump
    db_name = awqmdb
    PMON started with pid=2, OS id=17750
    PSP0 started with pid=3, OS id=17752
    MMAN started with pid=4, OS id=17754
    DBW0 started with pid=5, OS id=17756
    LGWR started with pid=6, OS id=17758
    CKPT started with pid=7, OS id=17760
    SMON started with pid=8, OS id=17762
    RECO started with pid=9, OS id=17764
    MMON started with pid=10, OS id=17766
    MMNL started with pid=11, OS id=17768
    Tue Jul 1 17:09:13 2008
    ALTER DATABASE MOUNT
    Tue Jul 1 17:09:17 2008
    Setting recovery target incarnation to 1
    Tue Jul 1 17:09:17 2008
    Successful mount of redo thread 1, with mount id 3772991929
    Tue Jul 1 17:09:17 2008
    Database mounted in Exclusive Mode
    Completed: ALTER DATABASE MOUNT
    Tue Jul 1 17:09:17 2008
    ALTER DATABASE OPEN
    Tue Jul 1 17:09:17 2008
    Beginning crash recovery of 1 threads
    parallel recovery started with 2 processes
    Tue Jul 1 17:09:18 2008
    Started redo scan
    Tue Jul 1 17:09:18 2008
    Completed redo scan
    1 redo blocks read, 0 data blocks need recovery
    Tue Jul 1 17:09:18 2008
    Started redo application at
    Thread 1: logseq 16, block 2, scn 452672
    Tue Jul 1 17:09:18 2008
    Recovery of Online Redo Log: Thread 1 Group 2 Seq 16 Reading mem 0
    Mem# 0 errs 0: /home/oracle/app/oracle/product/10.2.0/db_1/dbs/log2awqmdb.dbf
    Tue Jul 1 17:09:18 2008
    Completed redo application
    Tue Jul 1 17:09:18 2008
    Completed crash recovery at
    Thread 1: logseq 16, block 3, scn 472674
    0 data blocks read, 0 data blocks written, 1 redo blocks read
    Tue Jul 1 17:09:18 2008
    Thread 1 advanced to log sequence 17
    Thread 1 opened at log sequence 17
    Current log# 1 seq# 17 mem# 0: /home/oracle/app/oracle/product/10.2.0/db_1/dbs/log1awqmdb.dbf
    Successful open of redo thread 1
    Tue Jul 1 17:09:18 2008
    MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
    Tue Jul 1 17:09:18 2008
    SMON: enabling cache recovery
    Tue Jul 1 17:09:18 2008
    Errors in file /home/oracle/admin/awqmdb/udump/awqmdb_ora_17770.trc:
    ORA-00704: bootstrap process failure
    ORA-39700: database must be opened with UPGRADE option
    Tue Jul 1 17:09:18 2008
    Error 704 happened during db open, shutting down database
    USER: terminating instance due to error 704
    Instance terminated by USER, pid = 17770
    ORA-1092 signalled during: ALTER DATABASE OPEN...
    Tue Jul 1 17:18:29 2008
    Starting ORACLE instance (normal)
    Tue Jul 1 17:18:29 2008
    System parameter db_block_buffers enabled without VLM on.
    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    Picked latch-free SCN scheme 2
    Using LOG_ARCHIVE_DEST_1 parameter default value as /home/oracle/app/oracle/product/10.2.0/db_1/dbs/arch
    Autotune of undo retention is turned off.
    LICENSE_MAX_USERS = 0
    SYS auditing is disabled
    ksdpec: called for event 13740 prior to event group initialization
    Starting up ORACLE RDBMS Version: 10.2.0.1.0.
    System parameters with non-default values:
    processes = 50
    shared_pool_size = 62914560
    control_files = /home/oracle/app/oracle/product/10.2.0/db_1/dbs/ora_control1, /home/oracle/app/oracle/product/10.2.0/db_1/dbs/ora_control2
    db_block_buffers = 1024
    log_buffer = 2927616
    log_checkpoint_interval = 10000
    db_files = 80
    db_file_multiblock_read_count= 8
    global_names = TRUE
    instance_name = awqmdb
    parallel_max_servers = 5
    background_dump_dest = /home/oracle/admin/awqmdb/bdump
    user_dump_dest = /home/oracle/admin/awqmdb/udump
    max_dump_file_size = 10240
    core_dump_dest = /home/oracle/admin/awqmdb/cdump
    db_name = awqmdb
    PMON started with pid=2, OS id=17802
    PSP0 started with pid=3, OS id=17804
    MMAN started with pid=4, OS id=17806
    DBW0 started with pid=5, OS id=17808
    LGWR started with pid=6, OS id=17810
    CKPT started with pid=7, OS id=17812
    SMON started with pid=8, OS id=17814
    RECO started with pid=9, OS id=17816
    MMON started with pid=10, OS id=17818
    MMNL started with pid=11, OS id=17820
    Tue Jul 1 17:18:29 2008
    ALTER DATABASE MOUNT
    Tue Jul 1 17:18:33 2008
    Setting recovery target incarnation to 1
    Tue Jul 1 17:18:33 2008
    Successful mount of redo thread 1, with mount id 3772966373
    Tue Jul 1 17:18:33 2008
    Database mounted in Exclusive Mode
    Completed: ALTER DATABASE MOUNT
    Tue Jul 1 17:18:33 2008
    ALTER DATABASE OPEN MIGRATE
    Tue Jul 1 17:18:33 2008
    Beginning crash recovery of 1 threads
    parallel recovery started with 2 processes
    Tue Jul 1 17:18:33 2008
    Started redo scan
    Tue Jul 1 17:18:33 2008
    Completed redo scan
    1 redo blocks read, 0 data blocks need recovery
    Tue Jul 1 17:18:33 2008
    Started redo application at
    Thread 1: logseq 17, block 2, scn 472676
    Tue Jul 1 17:18:33 2008
    Recovery of Online Redo Log: Thread 1 Group 1 Seq 17 Reading mem 0
    Mem# 0 errs 0: /home/oracle/app/oracle/product/10.2.0/db_1/dbs/log1awqmdb.dbf
    Tue Jul 1 17:18:33 2008
    Completed redo application
    Tue Jul 1 17:18:33 2008
    Completed crash recovery at
    Thread 1: logseq 17, block 3, scn 492678
    0 data blocks read, 0 data blocks written, 1 redo blocks read

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    close enough.
    I requested the top of the trace file not alert_SID.log
    head -200 /home/oracle/admin/awqmdb/udump/awqmdb_ora_15722.trc
    Code:
    SMON: enabling cache recovery
    Wed Jul 2 14:26:28 2008
    Errors in file /home/oracle/admin/awqmdb/udump/awqmdb_ora_15722.trc:
    ORA-00704: bootstrap process failure
    ORA-39700: database must be opened with UPGRADE option
    Wed Jul 2 14:26:28 2008
    Error 704 happened during db open, shutting down database
    USER: terminating instance due to error 704
    Instance terminated by USER, pid = 15722
    ORA-1092 signalled during: ALTER DATABASE OPEN...
    I'll guess what has happened.
    V10.2.0.1 was installed.
    Somebody decided to apply a patch to V10.2.0.2 or higher & did not complete the documented upgrade procedure.

    ORA-39700: database must be opened with UPGRADE option

    Find the patchset release notes & complete the installation of it.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool startup upgrade

    ORA-39700: database must be opened with UPGRADE option
    As anacedent mentions, it seems the sofware was installed and upgraded but the database was not upgraded, ...and...then the database was terminated with Control-C during startup.

    Try the following:

    sqlplus '/as sysdba'
    shutdown abort;
    startup upgrade
    @?/rdbms/admin/catupgrd.sql

    Maybe will work

    PS: Backup everything NOW!
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  6. #6
    Join Date
    Sep 2004
    Posts
    24
    I tried the option and found the following issue.

    Function created.

    No errors.
    SELECT version_script AS file_name FROM DUAL
    *
    ERROR at line 1:
    ORA-20000: Upgrade not supported from version
    ORA-06512: at "SYS.VERSION_SCRIPT", line 50


    Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the Partitioning, OLAP and Data Mining options
    Attached Files Attached Files

  7. #7
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Rda

    ORA-39700: database must be opened with UPGRADE option
    It is still asking to upgrade, do you actually have a database created? What version?

    Execute the RDA (Remote diagnostics utility), which will gather all information about the OS and RDBMS; then open a service request w/Oracle (and have an Oracle DBA available).
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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