Wednesday, August 12, 2020
dbametrix
More
    Home Oracle DBA Tips ORA-00600: internal error code, arguments:

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

    Article explains root cause of ORA-00600: internal error code, arguments: [6006] with workaround and solution.

    ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []

    Our production database encountered with above oracle error. Our database server stuck after sending error. We are be able to select and perform some work using super user with sysdba privilege but other user were unable to perform transaction.

    We checked Oracle support documentation and found workaround for this bug.

    - Advertisement -
    dbametrix

    The error “ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []” is received when problems with UNDO space occur.

    How to fix and what is the solution?

    Oracle support provides following workaround.

    Making a new UNDO tablespace:

    create undo tablespace undotbs3 datafile ‘… / oracle / oradata / testdb / undotbs3.dbf ’size 400m;

    we define the problem segment using following SELECT query using SYSDBA privilege.

    - Advertisement -
    dbametrix

    select segment_name, status from dba_rollback_segs;

    Now we need to assign a new UNDO tablespace to the system:

    alter system set undo_tablespace = undotbs3 scope = both;

    In the init.ora initialization file, add the line:

    _corrupted_rollback_segments = ”_ SYSSMU3$” _SYSSMU3$ is our corrupted rollback segment.

    Load the database with our new init.ora parameter file using command startup pfile=<name with full destination of parameter file>

    Then we delete the damaged or corrupted rollback segment:

    drop rollback segment "_SYSSMU3$";

    Reasons behind this kind of ORA-600 errors and more detailing about ORA 600 errors you can find out from my main article called Why ORA-00600 errors are irritating Oracle DBA Specialists? You can find this link. For more Oracle DBA tutorials and tips stay connected with our Expert DBA Club Blog and this blog is running by Dbametrix Team.

    1+
    - Advertisement -
    dbametrix
    - Advertisment -
    dbametrix

    Most Popular

    ASM Disk creation issue

    The article explains how to troubleshoot Oracle ASM disk creation. Solution of Oracle ASM disk creation with ASMLIB

    Oracle Tuning Basics Part-2

    This is the 2nd part of Oracle database tuning basics including depth of every aspects.

    Oracle Tuning Basics Part-1

    The article explains Oracle database performance tuning basics details.

    When you finding new job

    The article guides you 10 things to remember when you are searching a new job to improve yourself including skills and better growth for every DBA.

    Recent Comments

    Gordon Coleclough on Oracle Tuning Basics Part-1
    Gordon Coleclough on ASM Disk creation issue