ORA 600

my_oracle
    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
      • 1. Re: ORA 600
        Fahd.Mirza
        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
          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
            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
              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
                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
                  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
                    Posting actual metalink content (as opposed to simply the reference Note number) is a violation of your Metalink terms of usage.