7 Replies Latest reply on Jun 26, 2010 4:35 PM by EdStevens

    ORA 600

    my_oracle
    my_oracle Jun 26, 2010 10:16 AM
      HI,
      i got this error in alert.log file

      ORA-00600: internal error code, arguments: [1234], [], [], [], [], [], [], []
      ORA-00600: internal error code, arguments: [729], [64], [space leak], [], [], [], []

      anyone face this advice will be helpfull
      • 1450 Views
      • Tags:
        • 1. Re: ORA 600
          Fahd.Mirza
          Fahd.Mirza Jun 26, 2010 10:34 AM (in response to my_oracle)
          Just search on metalink .. You can always use below note for trouble shooting 600/7445 errors ..

          153788.1 - Troubleshoot an ORA-600 or ORA-7445 Error Using the Error Lookup Tool
          • 2. Re: ORA 600
            rajeysh
            rajeysh Jun 26, 2010 10:37 AM (in response to my_oracle)
            how we know , what you have done earlier and your oracle version and os name?
            is there is any clue to identify your database information from your post to know about your ora-600 error?
            you are not a newbie to the forum, this is yours 121 posts. atleast post last 30 lines from your alert log file to identify your problem.
            • 3. Re: ORA 600
              my_oracle
              my_oracle Jun 26, 2010 10:47 AM (in response to rajeysh)
              db version 10.2.0.3 redhat linux 5


              Fri Jun 25 19:29:52 2010
              Incremental checkpoint up to RBA [0x199.19ee88.0], current log tail at RBA [0x199.19ff30.0]
              Fri Jun 25 19:50:04 2010
              Incremental checkpoint up to RBA [0x199.1a3d36.0], current log tail at RBA [0x199.1a4d41.0]
              Fri Jun 25 20:10:17 2010
              Incremental checkpoint up to RBA [0x199.1a8fb3.0], current log tail at RBA [0x199.1aa19b.0]
              Fri Jun 25 20:30:29 2010
              Incremental checkpoint up to RBA [0x199.1adf07.0], current log tail at RBA [0x199.1aeeda.0]
              Fri Jun 25 20:50:41 2010
              Incremental checkpoint up to RBA [0x199.1b2c6d.0], current log tail at RBA [0x199.1b3c82.0]
              Fri Jun 25 21:10:53 2010
              Incremental checkpoint up to RBA [0x199.1b7e08.0], current log tail at RBA [0x199.1b8fc8.0]
              Fri Jun 25 21:31:06 2010
              Incremental checkpoint up to RBA [0x199.1bcd77.0], current log tail at RBA [0x199.1bdd0a.0]
              Fri Jun 25 21:51:17 2010
              Incremental checkpoint up to RBA [0x199.1c1af1.0], current log tail at RBA [0x199.1c2a3d.0]
              Fri Jun 25 22:11:30 2010
              Incremental checkpoint up to RBA [0x199.1c6d72.0], current log tail at RBA [0x199.1c7e43.0]
              Fri Jun 25 22:31:42 2010
              Incremental checkpoint up to RBA [0x199.1cbcf1.0], current log tail at RBA [0x199.1ccc7c.0]
              Fri Jun 25 22:51:54 2010
              Incremental checkpoint up to RBA [0x199.1d0a57.0], current log tail at RBA [0x199.1d1952.0]
              Fri Jun 25 23:12:07 2010
              Incremental checkpoint up to RBA [0x199.1d5b1f.0], current log tail at RBA [0x199.1d6d2d.0]
              Fri Jun 25 23:32:20 2010
              Incremental checkpoint up to RBA [0x199.1daa7f.0], current log tail at RBA [0x199.1dba25.0]
              Fri Jun 25 23:52:34 2010
              Incremental checkpoint up to RBA [0x199.1df799.0], current log tail at RBA [0x199.1e07a6.0]
              Sat Jun 26 00:12:47 2010
              Incremental checkpoint up to RBA [0x199.1e48de.0], current log tail at RBA [0x199.1e5b6b.0]
              Sat Jun 26 00:33:01 2010
              Incremental checkpoint up to RBA [0x199.1e9969.0], current log tail at RBA [0x199.1ea946.0]
              Sat Jun 26 00:53:14 2010
              Incremental checkpoint up to RBA [0x199.1ee71e.0], current log tail at RBA [0x199.1ef7ee.0]
              Sat Jun 26 00:56:01 2010
              Beginning log switch checkpoint up to RBA [0x19a.2.10], SCN: 5965384411858
              Thread 1 advanced to log sequence 410
              Current log# 1 seq# 410 mem# 0: /oracle/PROD/db/apps_st/data/log01a.dbf
              Current log# 1 seq# 410 mem# 1: /oracle/PROD/db/apps_st/data/log01b.dbf
              Sat Jun 26 01:01:09 2010
              Completed checkpoint up to RBA [0x19a.2.10], SCN: 5965384411858
              Sat Jun 26 01:13:29 2010
              Incremental checkpoint up to RBA [0x19a.39c2.0], current log tail at RBA [0x19a.4bad.0]
              Sat Jun 26 01:33:42 2010
              Incremental checkpoint up to RBA [0x19a.885f.0], current log tail at RBA [0x19a.98e2.0]
              Sat Jun 26 01:53:56 2010
              Incremental checkpoint up to RBA [0x19a.d5aa.0], current log tail at RBA [0x19a.e578.0]
              Sat Jun 26 02:14:10 2010
              Incremental checkpoint up to RBA [0x19a.14e99.0], current log tail at RBA [0x19a.15f7a.0]
              Sat Jun 26 02:34:23 2010
              Incremental checkpoint up to RBA [0x19a.19d98.0], current log tail at RBA [0x19a.1ade4.0]
              Sat Jun 26 02:54:36 2010
              Incremental checkpoint up to RBA [0x19a.1ec2b.0], current log tail at RBA [0x19a.1fbf2.0]
              Sat Jun 26 03:14:49 2010
              Incremental checkpoint up to RBA [0x19a.23f9b.0], current log tail at RBA [0x19a.250af.0]
              Sat Jun 26 03:35:03 2010
              Incremental checkpoint up to RBA [0x19a.28e32.0], current log tail at RBA [0x19a.29dec.0]
              Sat Jun 26 03:55:16 2010
              Incremental checkpoint up to RBA [0x19a.2dbb3.0], current log tail at RBA [0x19a.2eb02.0]
              Sat Jun 26 04:15:28 2010
              Incremental checkpoint up to RBA [0x19a.32c7f.0], current log tail at RBA [0x19a.33e8e.0]
              Sat Jun 26 04:35:43 2010
              Incremental checkpoint up to RBA [0x19a.3a037.0], current log tail at RBA [0x19a.3b038.0]
              Sat Jun 26 04:55:55 2010
              Incremental checkpoint up to RBA [0x19a.3ee0a.0], current log tail at RBA [0x19a.3fe79.0]
              Sat Jun 26 05:16:08 2010
              Incremental checkpoint up to RBA [0x19a.440d4.0], current log tail at RBA [0x19a.452f5.0]
              Sat Jun 26 05:36:20 2010
              Incremental checkpoint up to RBA [0x19a.48fe9.0], current log tail at RBA [0x19a.4a06a.0]
              Sat Jun 26 05:56:33 2010
              Incremental checkpoint up to RBA [0x19a.4dd2f.0], current log tail at RBA [0x19a.4edd1.0]
              Sat Jun 26 06:16:46 2010
              Incremental checkpoint up to RBA [0x19a.52eea.0], current log tail at RBA [0x19a.54078.0]
              Sat Jun 26 06:36:59 2010
              Incremental checkpoint up to RBA [0x19a.57da1.0], current log tail at RBA [0x19a.58dc6.0]
              Sat Jun 26 06:57:12 2010
              Incremental checkpoint up to RBA [0x19a.5cb99.0], current log tail at RBA [0x19a.5dbb4.0]
              Sat Jun 26 07:17:25 2010
              Incremental checkpoint up to RBA [0x19a.61ddf.0], current log tail at RBA [0x19a.6305d.0]
              Sat Jun 26 07:37:39 2010
              Incremental checkpoint up to RBA [0x19a.66ddf.0], current log tail at RBA [0x19a.67d74.0]
              Sat Jun 26 07:57:51 2010
              Incremental checkpoint up to RBA [0x19a.6bb99.0], current log tail at RBA [0x19a.6cc75.0]
              Sat Jun 26 08:18:15 2010
              Incremental checkpoint up to RBA [0x19a.7aea7.0], current log tail at RBA [0x19a.81aee.0]
              Sat Jun 26 08:38:39 2010
              Incremental checkpoint up to RBA [0x19a.8f96d.0], current log tail at RBA [0x19a.91506.0]
              Sat Jun 26 08:58:55 2010
              Incremental checkpoint up to RBA [0x19a.96eea.0], current log tail at RBA [0x19a.99473.0]
              Sat Jun 26 09:19:11 2010
              Incremental checkpoint up to RBA [0x19a.9fc0a.0], current log tail at RBA [0x19a.a2424.0]
              Sat Jun 26 09:39:30 2010
              Incremental checkpoint up to RBA [0x19a.a9dbb.0], current log tail at RBA [0x19a.ab792.0]
              Sat Jun 26 09:59:44 2010
              Incremental checkpoint up to RBA [0x19a.b11fd.0], current log tail at RBA [0x19a.b32aa.0]
              Sat Jun 26 10:20:01 2010
              Incremental checkpoint up to RBA [0x19a.b9ba8.0], current log tail at RBA [0x19a.bb443.0]
              Sat Jun 26 10:40:17 2010
              Incremental checkpoint up to RBA [0x19a.c11f5.0], current log tail at RBA [0x19a.c2ab6.0]
              Sat Jun 26 11:00:34 2010
              Incremental checkpoint up to RBA [0x19a.c8bee.0], current log tail at RBA [0x19a.cea0f.0]
              Sat Jun 26 11:20:50 2010
              Incremental checkpoint up to RBA [0x19a.d35ba.0], current log tail at RBA [0x19a.d62ac.0]
              Sat Jun 26 11:41:05 2010
              Incremental checkpoint up to RBA [0x19a.dc326.0], current log tail at RBA [0x19a.ddc64.0]
              Sat Jun 26 11:57:28 2010
              Errors in file /oracle/PROD/db/tech_st/10.2.0/admin/PROD_erpdata/udump/prod_ora_9527.trc:
              ORA-00600: internal error code, arguments: [729], [64], [space leak], [], [], [], [], []
              Sat Jun 26 11:57:29 2010
              Errors in file /oracle/PROD/db/tech_st/10.2.0/admin/PROD_erpdata/udump/prod_ora_9527.trc:
              ORA-00600: internal error code, arguments: [1234], [], [], [], [], [], [], []
              ORA-00600: internal error code, arguments: [729], [64], [space leak], [], [], [], [], []
              Sat Jun 26 12:01:20 2010
              Incremental checkpoint up to RBA [0x19a.e2a59.0], current log tail at RBA [0x19a.e7b85.0]
              Sat Jun 26 12:21:38 2010
              Incremental checkpoint up to RBA [0x19a.115f0c.0], current log tail at RBA [0x19a.118a62.0]
              Sat Jun 26 12:41:52 2010
              Incremental checkpoint up to RBA [0x19a.11dc8c.0], current log tail at RBA [0x19a.11f5b4.0]
              • 4. Re: ORA 600
                781143
                781143 Jun 26, 2010 10:50 AM (in response to my_oracle)
                What is an ORA-600 Internal Error? [ID 146580.1]
                OERR: ORA 600 "internal error code, arguments: [%s],[%s],[%s], [%s], [%s], [ID 18485.1]

                Paste your first argument in Error Lookup Tool, it will give details about your issue.

                Thanks
                Sai
                • 5. Re: ORA 600
                  my_oracle
                  my_oracle Jun 26, 2010 10:58 AM (in response to 781143)
                  ORA-600 [729] "UGA Space Leak" [ID 31056.1] found by error lookup tool and asking to add a event parameter init.ora file


                  PURPOSE:
                  This article discusses the internal error "ORA-600 [729]", what
                  it means and possible actions. The information here is only applicable
                  to the versions listed and is provided only for guidance.

                  ERROR:
                  ORA-600 [729] [a]

                  VERSIONS:
                  versions 7.0 to 10.1

                  DESCRIPTION:

                  A space leak has been detected in the User Global Area (UGA).

                  There is NO data corruption as a result of this error.

                  It is an internal memory housekeeping problem.

                  ARGUMENTS:
                  Arg [a] This is the number of bytes leaked

                  FUNCTIONALITY:
                  MEMORY COMPONENT

                  IMPACT:
                  PROCESS FAILURE - But only during logoff so impact is minimal.
                  NON CORRUPTIVE - No underlying data corruption.


                  SUGGESTIONS:

                  Event 10262 can be set to safely ignore small memory leaks.

                  Set the following in init.ora for example to disable space
                  leaks less than 4000 bytes:

                  event = "10262 trace name context forever, level 4000"

                  and stop and restart the database.
                  • 6. Re: ORA 600
                    618702
                    618702 Jun 26, 2010 12:51 PM (in response to my_oracle)
                    Dear ahmed,

                    You should not post metalink articles and not in elsewhere. Please delete the article from your post.

                    Space link could happen when you not configured the kernel parameter or may be you need more swap area. Have you configured the kernel parameters as mentioned in the installation documentation of Oracle setup.

                    So you have metalink account and i strongly suggest you to take an idea from there. Please do not post more Metalink notes in the future and read the user policies.

                    Hope it helps,

                    Ogan
                    • 7. Re: ORA 600
                      EdStevens
                      EdStevens Jun 26, 2010 4:35 PM (in response to my_oracle)
                      Posting actual metalink content (as opposed to simply the reference Note number) is a violation of your Metalink terms of usage.