2 Replies Latest reply: Mar 26, 2013 3:32 PM by Flávio Soares RSS

    ORA-600 on RAC Database

    Gvashist
      Oracle 10g R2 RAC on RHEL 4

      All Resources are ONLINE

      [oracle@rac1 ~]$ /u01/crs.sh
      HA Resource Target State
      ----------- ------ -----
      ora.rac1.ASM1.asm                             ONLINE     ONLINE on rac1
      ora.rac1.LISTENER_RAC1.lsnr                   ONLINE     ONLINE on rac1
      ora.rac1.gsd                                  ONLINE     ONLINE on rac1
      ora.rac1.ons                                  ONLINE     ONLINE on rac1
      ora.rac1.vip                                  ONLINE     ONLINE on rac1
      ora.rac2.ASM2.asm                             ONLINE     ONLINE on rac2
      ora.rac2.LISTENER_RAC2.lsnr                   ONLINE     ONLINE on rac2
      ora.rac2.gsd                                  ONLINE     ONLINE on rac2
      ora.rac2.ons                                  ONLINE     ONLINE on rac2
      ora.rac2.vip                                  ONLINE     ONLINE on rac2
      ora.racdb.db                                  ONLINE     ONLINE on rac2
      ora.racdb.racdb1.inst                         ONLINE     ONLINE on rac1
      ora.racdb.racdb2.inst                         ONLINE     ONLINE on rac2
      ora.racdb.taf.cs                              ONLINE     ONLINE on rac1
      ora.racdb.taf.racdb1.srv                      ONLINE     ONLINE on rac1
      *[oracle@rac1 ~]$*


      but in my database Alert , i found ORA-600


      [root@rac1 ~]# tail -f /u01/app/oracle/admin/racdb/bdump/alert_racdb1.log
      QMNC started with pid=27, OS id=12863
      Tue Mar 26 18:05:18 2013
      Completed: ALTER DATABASE OPEN
      Tue Mar 26 18:05:20 2013
      Errors in file /u01/app/oracle/admin/racdb/bdump/racdb1_mmon_12279.trc:
      ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []
      Tue Mar 26 18:05:21 2013
      Trace dumping is performing id=[cdmp_20130326180521]
      Tue Mar 26 18:08:14 2013
      ALTER SYSTEM SET service_names='racdb','taf' SCOPE=MEMORY SID='racdb1';
      Tue Mar 26 18:08:20 2013
      Errors in file /u01/app/oracle/admin/racdb/udump/racdb1_ora_13390.trc:
      *ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []*
      Tue Mar 26 18:08:23 2013
      ORA-600 encountered when generating server alert SMG-4124
      Tue Mar 26 18:08:23 2013
      Trace dumping is performing id=[cdmp_20130326180823]
      Tue Mar 26 18:09:54 2013
      Shutting down archive processes
      Tue Mar 26 18:09:59 2013
      ARCH shutting down
      ARC2: Archival stopped
      Tue Mar 26 18:10:05 2013
      Restarting dead background process MMON
      MMON started with pid=26, OS id=20413
      Tue Mar 26 18:10:10 2013
      Errors in file /u01/app/oracle/admin/racdb/bdump/racdb1_mmon_20413.trc:
      *ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []*
      ORA-600 encountered when generating server alert SMG-4120
      Tue Mar 26 18:10:11 2013
      Trace dumping is performing id=[cdmp_20130326181011]



      Suggest Me


      Thanks
        • 1. Re: ORA-600 on RAC Database
          Levi Pereira
          Hi,

          This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition.

          Suggestion use My Oracle Support. http://support.oracle.com

          1 - use note: ORA-600/ORA-7445/ORA-700 Error Look-up Tool [ID 153788.1], to check bug.

          If you don't find anything about:

          2 - Report this error to Oracle Support Services opening a SR.

          Is recommend to use ADRCI or Support Workbench to package the incident.
          See Note 411.1 at My Oracle Support for error and packaging details.


          Regards,
          Levi Pereira
          • 2. Re: ORA-600 on RAC Database
            Flávio Soares
            Please, check the note ORA-600 [ktspgfb-1] [ID 285847.1]

            Bug# 7260057
            Bug# 2424226
            Bug# 2253389

            There are several bugs related to this error.

            I recommend you open a SR to treat the problem.