3 Replies Latest reply: Sep 27, 2012 4:35 AM by Sunny kichloo RSS

    ORA-600 in alert log file.

    User470870-OC
      Hi ..

      Database version : 11.1.0.7
      OS Redhat linux 5.5

      Found an error in alert log file, as db runnning properly.

      SMON: enabling tx recovery
      Errors in file /u02/OBAPROD/db/tech_st/11.1.0/admin/OBAPROD_prod/diag/rdbms/obaprod/OBAPROD/trace/OBAPROD_smon_12460.trc (incident=828153):
      ORA-00600: internal error code, arguments: [ktsxtffs2], [284], [1398030667], [], [], [], [], [], [], [], [], []
      Incident details in: /u02/OBAPROD/db/tech_st/11.1.0/admin/OBAPROD_prod/diag/rdbms/obaprod/OBAPROD/incident/incdir_828153/OBAPROD_smon_12460_i828153.trc

      Errors in file /u02/OBAPROD/db/tech_st/11.1.0/admin/OBAPROD_prod/diag/rdbms/obaprod/OBAPROD/trace/OBAPROD_smon_12460.trc (incident=828154):
      ORA-00600: internal error code, arguments: [kghstack_free1], [sort - search in file #s], [], [], [], [], [], [], [], [], [], []
      ORA-00600: internal error code, arguments: [ktsxtffs2], [284], [1398030667], [], [], [], [], [], [], [], [], []
      Incident details in: /u02/OBAPROD/db/tech_st/11.1.0/admin/OBAPROD_prod/diag/rdbms/obaprod/OBAPROD/incident/incdir_828154/OBAPROD_smon_12460_i828154.trc

      Please suggest earliest as an error found in alertlog file.
      What would be the reason ..?

      Thanks in advance.

      Edited by: 955685 on Sep 17, 2012 3:22 AM
        • 1. Re: ORA-600 in alert log file.
          415289
          ORA-600
          Cause: This is the generic internal error number for Oracle program
          // exceptions. It indicates that a process has encountered a low-level,
          // unexpected condition. The first argument is the internal message
          // number. This argument and the database version number are critical in
          // identifying the root cause and the potential impact to your system.
          //
          // *Action: Visit My Oracle Support to access the ORA-00600 Lookup tool
          // (reference Note 600.1) for more information regarding the specific
          // ORA-00600 error encountered.

          if you're unable to find any useful information in oracle metalink then Raise SR to oracle support.
          • 2. Re: ORA-600 in alert log file.
            921598
            Whenever an ORA-600 error is raised, a trace file is generated and an entry is written to the alert.log with details of the trace file location. The alert log may indicate additional errors or other internal errors at the time of the problem. Focus your analysis of the problem on the first internal error in the sequence. There are some exceptions, but often additional internal errors are side-effects of the first error condition.
            • 3. Re: ORA-600 in alert log file.
              Sunny kichloo
              As suggested above raise an Oracle SR