This discussion is archived
7 Replies Latest reply: Feb 26, 2013 11:24 AM by vlethakula RSS

ORA-01092: ORACLE instance terminated. Disconnection forced

Reena Newbie
Currently Being Moderated
Please can any one help me solve this problem? I have already checked the alert log file but there seem no luck for repairs
This problem came as a result of power cut.

Below is the result for connecting:

SQL> conn /as sysdba
Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 587205508 bytes
Database Buffers 16777216 bytes
Redo Buffers 7135232 bytes
Database mounted.
SQL>
SQL>
SQL> alter database recover;

Database altered.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced


SQL>
  • 1. Re: ORA-01092: ORACLE instance terminated. Disconnection forced
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Please post DB Version
    Post OS version
    Post alert log
  • 2. Re: ORA-01092: ORACLE instance terminated. Disconnection forced
    moreajays Pro
    Currently Being Moderated
    Reena,

    Is it recently being cloned ? or Binary changes ?
    Check for any ORA-00600 errors in alert log

    Post recover command , check executing below
    alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';
    set feedback on
    set heading on
    set pagesize 1000
    set linesize 175
    column checkpoint_change# format 999999999999999999999
    select status, checkpoint_change#, fuzzy, 
    to_char(checkpoint_time, 'DD-MON-YYYY HH24:MI:SS') as checkpoint_time,
    count(*)
    from v$datafile_header
    group by status, checkpoint_change#, fuzzy, checkpoint_time
    order by status, checkpoint_change#, fuzzy, checkpoint_time;
    select distinct status from v$backup;
    select distinct  checkpoint_change#  from v$datafile_header;
    select hxfil file_id, fhscn scn, fhthr thread, fhrba_seq sequence, fhsta status from x$kcvfh;
    Thanks,
    Ajay More
    http://www.moreajays.com
  • 3. Re: ORA-01092: ORACLE instance terminated. Disconnection forced
    Reena Newbie
    Currently Being Moderated
    Hello Ajay,

    Nothing changes made to db, this prob. occurred due to power cut. And yes I am getting Ora-0600 error in alert.log. Alert log details are mentioned below for your reference:

    Tue Feb 26 12:48:02 2013
    Starting ORACLE instance (normal)
    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    Picked latch-free SCN scheme 2
    Autotune of undo retention is turned on.
    IMODE=BR
    ILAT =30
    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 = 250
    resource_limit = TRUE
    __shared_pool_size = 574619648
    shared_pool_size = 536870912
    __large_pool_size = 4194304
    __java_pool_size = 8388608
    __streams_pool_size = 0
    sga_target = 612368384
    control_files = D:\ORACLE\ORADATA\VATDB\CONTROL01.CTL, D:\ORACLE\ORADATA\VATDB\CONTROL02.CTL, D:\ORACLE\ORADATA\VATDB\CONTROL03.CTL
    db_block_size = 8192
    __db_cache_size = 16777216
    compatible = 10.2.0.1.0
    log_archive_dest_1 = location=D:\oracle\oradata\archive
    log_archive_dest_2 = service=standby lgwr
    log_archive_dest_state_2 = ENABLE
    db_file_multiblock_read_count= 16
    db_recovery_file_dest = D:\oracle\product\10.2.0/flash_recovery_area
    db_recovery_file_dest_size= 2147483648
    undo_management = AUTO
    undo_tablespace = UNDOTBS1
    remote_login_passwordfile= EXCLUSIVE
    db_domain =
    dispatchers = (PROTOCOL=TCP) (SERVICE=VATDBXDB)
    job_queue_processes = 10
    audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\VATDB\ADUMP
    background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\VATDB\BDUMP
    user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\VATDB\UDUMP
    core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\VATDB\CDUMP
    db_name = VATDB
    open_cursors = 300
    pga_aggregate_target = 104857600
    gbyhash_aggregation_enabled= FALSE
    PMON started with pid=2, OS id=4004
    PSP0 started with pid=3, OS id=4076
    MMAN started with pid=4, OS id=4072
    DBW0 started with pid=5, OS id=1000
    LGWR started with pid=6, OS id=3440
    CKPT started with pid=7, OS id=3984
    SMON started with pid=8, OS id=3980
    RECO started with pid=9, OS id=1492
    MMON started with pid=11, OS id=880
    Tue Feb 26 12:48:03 2013
    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
    MMNL started with pid=12, OS id=3872
    Tue Feb 26 12:48:03 2013
    starting up 1 shared server(s) ...
    Tue Feb 26 12:48:03 2013
    ALTER DATABASE MOUNT
    CJQ0 started with pid=10, OS id=1500
    Tue Feb 26 12:48:08 2013
    Setting recovery target incarnation to 2
    Tue Feb 26 12:48:08 2013
    Successful mount of redo thread 1, with mount id 3534763651
    Tue Feb 26 12:48:08 2013
    Database mounted in Exclusive Mode
    Completed: ALTER DATABASE MOUNT
    Tue Feb 26 12:48:59 2013
    alter database recover
    Tue Feb 26 12:48:59 2013
    Media Recovery Start
    parallel recovery started with 3 processes
    Tue Feb 26 12:49:03 2013
    Recovery of Online Redo Log: Thread 1 Group 2 Seq 2604 Reading mem 0
    Mem# 0 errs 0: D:\ORACLE\ORADATA\VATDB\REDO02.LOG
    Completed: alter database recover
    Tue Feb 26 12:49:15 2013
    alter database open
    Tue Feb 26 12:49:16 2013
    Beginning crash recovery of 1 threads
    parallel recovery started with 3 processes
    Tue Feb 26 12:49:17 2013
    Started redo scan
    Tue Feb 26 12:49:17 2013
    Completed redo scan
    389 redo blocks read, 0 data blocks need recovery
    Tue Feb 26 12:49:18 2013
    Started redo application at
    Thread 1: logseq 2604, block 3
    Tue Feb 26 12:49:18 2013
    Recovery of Online Redo Log: Thread 1 Group 2 Seq 2604 Reading mem 0
    Mem# 0 errs 0: D:\ORACLE\ORADATA\VATDB\REDO02.LOG
    Tue Feb 26 12:49:18 2013
    Completed redo application
    Tue Feb 26 12:49:18 2013
    Completed crash recovery at
    Thread 1: logseq 2604, block 392, scn 7753612411
    0 data blocks read, 0 data blocks written, 389 redo blocks read
    Tue Feb 26 12:49:19 2013
    Thread 1 advanced to log sequence 2605
    Thread 1 opened at log sequence 2605
    Current log# 3 seq# 2605 mem# 0: D:\ORACLE\ORADATA\VATDB\REDO03.LOG
    Successful open of redo thread 1
    Tue Feb 26 12:49:20 2013
    MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
    Tue Feb 26 12:49:20 2013
    SMON: enabling cache recovery
    Tue Feb 26 12:49:22 2013
    Successfully onlined Undo Tablespace 1.
    Tue Feb 26 12:49:22 2013
    SMON: enabling tx recovery
    Tue Feb 26 12:49:22 2013
    Database Characterset is WE8ISO8859P1
    replication_dependency_tracking turned off (no async multimaster replication found)
    Tue Feb 26 12:49:28 2013
    Errors in file d:\oracle\product\10.2.0\admin\vatdb\udump\vatdb_ora_248.trc:
    ORA-00600: internal error code, arguments: [kksfbc-reparse-infinite-loop], [0x834FBF8], [], [], [], [], [], []

    Tue Feb 26 12:49:31 2013
    Errors in file d:\oracle\product\10.2.0\admin\vatdb\udump\vatdb_ora_248.trc:
    ORA-00600: internal error code, arguments: [kksfbc-reparse-infinite-loop], [0x834FBF8], [], [], [], [], [], []

    Tue Feb 26 12:49:34 2013
    Errors in file d:\oracle\product\10.2.0\admin\vatdb\udump\vatdb_ora_248.trc:
    ORA-00600: internal error code, arguments: [kksfbc-reparse-infinite-loop], [0x834FBF8], [], [], [], [], [], []

    Tue Feb 26 12:49:36 2013
    Starting background process QMNC
    QMNC started with pid=19, OS id=1716
    Tue Feb 26 12:49:39 2013
    Error 0 in kwqmnpartition(), aborting txn
    Error 0 in kwqmnpartition-update_aqs_instance, aborting txn
    Tue Feb 26 12:49:41 2013
    Errors in file d:\oracle\product\10.2.0\admin\vatdb\udump\vatdb_ora_248.trc:
    ORA-00600: internal error code, arguments: [kksfbc-reparse-infinite-loop], [0x834D944], [], [], [], [], [], []

    Tue Feb 26 12:49:45 2013
    Errors in file d:\oracle\product\10.2.0\admin\vatdb\udump\vatdb_ora_248.trc:
    ORA-00600: internal error code, arguments: [kksfbc-reparse-infinite-loop], [0x834FDDC], [], [], [], [], [], []

    Tue Feb 26 12:49:48 2013
    Errors in file d:\oracle\product\10.2.0\admin\vatdb\udump\vatdb_ora_248.trc:
    ORA-00600: internal error code, arguments: [kksfbc-reparse-infinite-loop], [0x834FDDC], [], [], [], [], [], []

    Error 600 happened during db open, shutting down database
    USER: terminating instance due to error 600
    Tue Feb 26 12:49:48 2013
    Errors in file d:\oracle\product\10.2.0\admin\vatdb\bdump\vatdb_q000_960.trc:
    ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

    Tue Feb 26 12:49:48 2013
    Errors in file d:\oracle\product\10.2.0\admin\vatdb\bdump\vatdb_pmon_4004.trc:
    ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

    Tue Feb 26 12:49:48 2013
    Errors in file d:\oracle\product\10.2.0\admin\vatdb\bdump\vatdb_p002_888.trc:
    ORA-00600: internal error code, arguments: [15784], [600], [], [], [], [], [], []
    ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

    Tue Feb 26 12:49:48 2013
    Errors in file d:\oracle\product\10.2.0\admin\vatdb\bdump\vatdb_p001_356.trc:
    ORA-00600: internal error code, arguments: [15784], [600], [], [], [], [], [], []
    ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

    Tue Feb 26 12:49:48 2013
    Errors in file d:\oracle\product\10.2.0\admin\vatdb\bdump\vatdb_p000_992.trc:
    ORA-00600: internal error code, arguments: [15784], [600], [], [], [], [], [], []
    ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

    Tue Feb 26 12:49:48 2013
    Errors in file d:\oracle\product\10.2.0\admin\vatdb\bdump\vatdb_lgwr_3440.trc:
    ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

    Tue Feb 26 12:49:48 2013
    Errors in file d:\oracle\product\10.2.0\admin\vatdb\bdump\vatdb_psp0_4076.trc:
    ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

    Tue Feb 26 12:49:49 2013
    Errors in file d:\oracle\product\10.2.0\admin\vatdb\bdump\vatdb_dbw0_1000.trc:
    ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

    Tue Feb 26 12:49:49 2013
    Errors in file d:\oracle\product\10.2.0\admin\vatdb\bdump\vatdb_mman_4072.trc:
    ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

    Tue Feb 26 12:49:49 2013
    Errors in file d:\oracle\product\10.2.0\admin\vatdb\bdump\vatdb_ckpt_3984.trc:
    ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

    Tue Feb 26 12:49:52 2013
    Errors in file d:\oracle\product\10.2.0\admin\vatdb\bdump\vatdb_reco_1492.trc:
    ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

    Tue Feb 26 12:49:55 2013
    Instance terminated by USER, pid = 248
    ORA-1092 signalled during: alter database open...
  • 4. Re: ORA-01092: ORACLE instance terminated. Disconnection forced
    Reena Newbie
    Currently Being Moderated
    Hi there,

    Db version: 10.2.0.1.0
    OS version: Windows server 2003

    Alert log details mentioned in my previous message (message in reply)
  • 5. Re: ORA-01092: ORACLE instance terminated. Disconnection forced
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    ORA-00600: internal error code, arguments: [kksfbc-reparse-infinite-loop], [0x834FBF8], [], [], [], [], [], []
    You suppose to contact Oracle Support https://support.oracle.com ORA-00600 indicate for bug.
  • 6. Re: ORA-01092: ORACLE instance terminated. Disconnection forced
    moreajays Pro
    Currently Being Moderated
    Hi,

    Relevant Issue listed in
    ORA-00600 [17093] and ORA-00600 [kkmendsel-pin] Errors Continuously [ID 756592.1]

    It is due to invalid SYS objects in the data dictionary.

    To resolve this issue requires reloading the dictionary views and packages using catalog and catproc, and validating the invalid SYS objects using the utlrp utility.

    Please implement the following steps to address the issue.


    SQL> startup upgrade
    SQL> @?/rdbms/admin/catalog
    SQL> @?/rdbms/admin/catproc
    SQL> shutdown immediate
    SQL> startup
    SQL> @?/rdbms/admin/utlrp

    Validate this in SR

    Thanks,
    Ajay More
    http://www.moreajays.com
  • 7. Re: ORA-01092: ORACLE instance terminated. Disconnection forced
    vlethakula Expert
    Currently Being Moderated
    can you paste the content from
    d:\oracle\product\10.2.0\admin\vatdb\udump\vatdb_ora_248.trc:

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points