4 Replies Latest reply on Jul 10, 2012 9:29 PM by Osama_Mustafa

    how to fix this (ORA-00600: internal error code, arguments) error.. help me

    926749
      SQL> conn /as sysdba
      Connected.
      SQL> conn hr/hr
      ERROR:
      ORA-01033: ORACLE initialization or shutdown in progress
      Process ID: 0
      Session ID: 0 Serial number: 0

      -----
      I tried to fixed this  way but I could not.
      -----
      : -----

      SQL> conn /as sysdba
      Connected.
      SQL> select status from v$instance
      2 ;

      STATUS
      ------------
      MOUNTED

      SQL> shutdown immediate
      ORA-01109: database not open


      Database dismounted.
      ORACLE instance shut down.
      SQL> startup
      ORACLE instance started.

      Total System Global Area 753278976 bytes
      Fixed Size 1374724 bytes
      Variable Size 469763580 bytes
      Database Buffers 276824064 bytes
      Redo Buffers 5316608 bytes
      Database mounted.
      ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
      [332], [94], [138], [], [], [], [], [], [], []


      SQL> select status from v$instance
      2 ;

      STATUS
      ------------
      MOUNTED

      SQL> Select object_name,object_type,owner from dba_objects where data_object_id=
      332
      2 ;
      Select object_name,object_type,owner from dba_objects where data_object_id=332
      *
      ERROR at line 1:
      ORA-01219: database not open: queries allowed on fixed tables/views only


      SQL> conn /as sysdba
      Connected.
      SQL> Select object_name,object_type,owner from dba_objects where data_object_id=
      332
      2 ;
      Select object_name,object_type,owner from dba_objects where data_object_id=332
      *
      ERROR at line 1:
      ORA-01219: database not open: queries allowed on fixed tables/views only


      SQL> shutdown immediate
      ORA-01109: database not open


      Database dismounted.
      ORACLE instance shut down.
      SQL> startup mount
      ORACLE instance started.

      Total System Global Area 753278976 bytes
      Fixed Size 1374724 bytes
      Variable Size 469763580 bytes
      Database Buffers 276824064 bytes
      Redo Buffers 5316608 bytes
      Database mounted.
      SQL> recover database
      Media recovery complete.
      SQL> alter database open
      2 ;
      alter database open
      *
      ERROR at line 1:
      ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
      [332], [94], [138], [], [], [], [], [], [], []