7 Replies Latest reply: Feb 26, 2013 1:24 PM by vlethakula RSS

    ORA-01092: ORACLE instance terminated. Disconnection forced

    Reena
      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
          Please post DB Version
          Post OS version
          Post alert log
          • 2. Re: ORA-01092: ORACLE instance terminated. Disconnection forced
            moreajays
            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
              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
                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
                  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
                    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
                      can you paste the content from
                      d:\oracle\product\10.2.0\admin\vatdb\udump\vatdb_ora_248.trc: