ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr] error

PROBLEM:
----------------


ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr] error



SOLUTION:
-----------------

You have to drop UNDO tablespace then recreate it.


SQL>create pfile='/tmp/pfile' from spfile;

SQL> startup restrict pfile='/tmp/pfile';
ORACLE instance started.

Total System Global Area 1970864128 bytes
Fixed Size                  2183896 bytes
Variable Size            1543507240 bytes
Database Buffers          419430400 bytes
Redo Buffers                5742592 bytes
Database mounted.
Database opened.
SQL> select tablespace_name, status, segment_name from dba_rollback_segs where status != 'OFFLINE';

TABLESPACE_NAME                STATUS           SEGMENT_NAME
------------------------------ ---------------- ------------------------------
SYSTEM                         ONLINE           SYSTEM

SQL> select tablespace_name, status, segment_name from dba_rollback_segs
  2  ;

TABLESPACE_NAME                STATUS           SEGMENT_NAME
------------------------------ ---------------- ------------------------------
SYSTEM                         ONLINE           SYSTEM
UNDOTBS02                      OFFLINE          _SYSSMU27_3348079370$
UNDOTBS02                      OFFLINE          _SYSSMU26_2631850070$
UNDOTBS02                      OFFLINE          _SYSSMU25_2645117195$
UNDOTBS02                      OFFLINE          _SYSSMU24_1824861410$
UNDOTBS02                      OFFLINE          _SYSSMU23_1673528659$
UNDOTBS02                      OFFLINE          _SYSSMU22_999122355$
UNDOTBS02                      OFFLINE          _SYSSMU21_1258748744$
UNDOTBS02                      OFFLINE          _SYSSMU20_858158107$
UNDOTBS02                      OFFLINE          _SYSSMU19_3999658247$
UNDOTBS02                      OFFLINE          _SYSSMU18_2525182416$

11 rows selected.

SQL> create undo tablespace UNDOTBS1 datafile '/u02/oradata/NECODB1/NECODB1/undotbs01.dbf' size 2000M;(You created new undo tablespace)

Tablespace created.

SQL> drop tablespace UNDOTBS2  including contents and datafiles;(you have to drop old undo tablespace)

Tablespace dropped.




SQL> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 1970864128 bytes
Fixed Size                  2183896 bytes
Variable Size            1543507240 bytes
Database Buffers          419430400 bytes
Redo Buffers                5742592 bytes
SQL> shu abort;
ORACLE instance shut down.
SQL> create spfile from pfile='/tmp/pfile';

File created.

SQL> startup
ORACLE instance started.

Total System Global Area 1970864128 bytes
Fixed Size                  2183896 bytes
Variable Size            1543507240 bytes
Database Buffers          419430400 bytes
Redo Buffers                5742592 bytes
Database mounted.
Database opened.
SQL> shu abort;
ORACLE instance shut down.
SQL> startuo

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1970864128 bytes
Fixed Size                  2183896 bytes
Variable Size            1543507240 bytes
Database Buffers          419430400 bytes
Redo Buffers                5742592 bytes
Database mounted.
SQL> alter system set undo_tablespace = 'UNDOTBS1 ' scope=spfile;

System altered.

SQL> alter database open;

Database altered.




Reference:
-----------
Step by step to resolve ORA-600 4194 4193 4197 on database crash (Doc ID 1428786.1)