This content has been marked as final.
Show 7 replies
-
1. Re: ORA 600
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 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 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 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 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 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 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.