Re: ORA-00600 Error
Hi, Analyzing ORA-600 trace files for the heap corruptions doesn't make sense. Because, this corruption errors are thrown if someone tries to work on this corrupted memory region. So, the information in trace files doesn't come from the corrupter. You should catch the corrupter. There are some undodumented parameter/events for that. But this may cause other problems in your system. Don't waste your time with the trace files. regards... Jack van Zanen wrote: > HI > > * > > >From Metalink > > Doc ID: Note:47411.1 > Type: REFERENCE > Status: PUBLISHED > Content Type: TEXT/PLAIN > Creation Date: 26-SEP-1997 > Last Revision Date: 20-MAR-2002 > > Note: For additional ORA-600 related information please read > [NOTE:146580.1] > > PURPOSE: > This article discusses the internal error "ORA-600 [17112]", 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 [17112][a][b][c][d][e] > > VERSIONS: > versions 7.3.X to 8.1.X > > DESCRIPTION: > > Oracle has detected that the magic number in a memory chunk header has > been overwritten. > > This is a heap (in memory) corruption and there is no underlying data > corruption. > > The error may occur in the one of the process specific heaps > (the Call heap, PGA heap, or session heap) or in the shared heap (SGA). > > ARGUMENTS: > Arg [a] Pointer to chunk header > > FUNCTIONALITY: > HEAP MANAGEMENT > > IMPACT: > PROCESS FAILURE > MEMORY CORRUPTION, POSSIBLE INSTANCE FAILURE. > NON DATA CORRUPTIVE - No underlying data corruption. > > SUGGESTIONS: > This is likely to be an effect rather than the cause > of the problem. May be due to an Operating System (OS) > memory overwrite. Run diagnostics to check the physical > memory on the machine and check the OS system logs. > For repeatable occurrances, please submit the trace > files and alert.log to Oracle Support Services for further analysis. > > *8 > > > GL2Z/ INF DBA > BENLATRECHE To: Multiple recipients of >list ORACLE-L <[EMAIL PROTECTED]> > <[EMAIL PROTECTED]cc: (bcc: Jack van >Zanen/nlzanen1/External/MEY/NL) > natrach.dz> Subject: ORA-00600 Error > Sent by: > [EMAIL PROTECTED] > > > 10-04-2002 12:28 > Please respond to > ORACLE-L > > > > HI All, > > We are running Oracle8.1.5 on a Netware 5 . The problem we are facing is > that the server is going down very frequently (3 times a day). > The error code on the Alert file shows : ORA-00600: with arguments : > [17112], [3461574976], [], [], [], [], [], []. > > Oracle support did not give us any Help. > > We have another Database with the same configuration as above and there is > no problem with it. > The diffence between the two configurations is that in the first one there > is an Forms 5 application with some tables including LON type columns and > in > the second there is a Forms 4.5 application without LONG columns tables. > > Please could someone give us any help. > > Best Regards > Kamel Benlatreche > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: GL2Z/ INF DBA BENLATRECHE > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > == > De informatie verzonden in dit e-mailbericht is vertrouwelijk en is > uitsluitend bestemd voor de geadresseerde. Openbaarmaking, > vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan > derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & > Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en > volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch > voor tijdige ontva
Re: ORA-00600 Error
HI * >From Metalink Doc ID: Note:47411.1 Type: REFERENCE Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 26-SEP-1997 Last Revision Date: 20-MAR-2002 Note: For additional ORA-600 related information please read [NOTE:146580.1] PURPOSE: This article discusses the internal error "ORA-600 [17112]", 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 [17112][a][b][c][d][e] VERSIONS: versions 7.3.X to 8.1.X DESCRIPTION: Oracle has detected that the magic number in a memory chunk header has been overwritten. This is a heap (in memory) corruption and there is no underlying data corruption. The error may occur in the one of the process specific heaps (the Call heap, PGA heap, or session heap) or in the shared heap (SGA). ARGUMENTS: Arg [a] Pointer to chunk header FUNCTIONALITY: HEAP MANAGEMENT IMPACT: PROCESS FAILURE MEMORY CORRUPTION, POSSIBLE INSTANCE FAILURE. NON DATA CORRUPTIVE - No underlying data corruption. SUGGESTIONS: This is likely to be an effect rather than the cause of the problem. May be due to an Operating System (OS) memory overwrite. Run diagnostics to check the physical memory on the machine and check the OS system logs. For repeatable occurrances, please submit the trace files and alert.log to Oracle Support Services for further analysis. *8 GL2Z/ INF DBA BENLATRECHE To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <[EMAIL PROTECTED]cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) natrach.dz> Subject: ORA-00600 Error Sent by: [EMAIL PROTECTED] 10-04-2002 12:28 Please respond to ORACLE-L HI All, We are running Oracle8.1.5 on a Netware 5 . The problem we are facing is that the server is going down very frequently (3 times a day). The error code on the Alert file shows : ORA-00600: with arguments : [17112], [3461574976], [], [], [], [], [], []. Oracle support did not give us any Help. We have another Database with the same configuration as above and there is no problem with it. The diffence between the two configurations is that in the first one there is an Forms 5 application with some tables including LON type columns and in the second there is a Forms 4.5 application without LONG columns tables. Please could someone give us any help. Best Regards Kamel Benlatreche -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). == De informatie verzonden in dit e-mailbericht
RE: ORA-00600 Error
Kamel, this will be down to Oracle to fix. The dump itself is caused by a memory corruption. It may be worth running some hardware diagnostics on the box itself to check out the RAM. Otherwise you need to push Oracle for an answer. The usual questions apply: Have you relinked anything? Have you installed anything? Has the machine config changed at all? Regards, Mike Hately -Original Message- Sent: 10 April 2002 11:28 To: Multiple recipients of list ORACLE-L HI All, We are running Oracle8.1.5 on a Netware 5 . The problem we are facing is that the server is going down very frequently (3 times a day). The error code on the Alert file shows : ORA-00600: with arguments : [17112], [3461574976], [], [], [], [], [], []. Oracle support did not give us any Help. We have another Database with the same configuration as above and there is no problem with it. The diffence between the two configurations is that in the first one there is an Forms 5 application with some tables including LON type columns and in the second there is a Forms 4.5 application without LONG columns tables. Please could someone give us any help. Best Regards Kamel Benlatreche This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-00600 Error
HI All, We are running Oracle8.1.5 on a Netware 5 . The problem we are facing is that the server is going down very frequently (3 times a day). The error code on the Alert file shows : ORA-00600: with arguments : [17112], [3461574976], [], [], [], [], [], []. Oracle support did not give us any Help. We have another Database with the same configuration as above and there is no problem with it. The diffence between the two configurations is that in the first one there is an Forms 5 application with some tables including LON type columns and in the second there is a Forms 4.5 application without LONG columns tables. Please could someone give us any help. Best Regards Kamel Benlatreche -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-00600 error
Title: Message Bunyamin, It's bug id 2177050. The bug report talks about temp tables, but that's a red herring really - it happens without temp tables being used. Cheers James -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bunyamin K. KaradenizSent: 04 April 2002 09:23To: Multiple recipients of list ORACLE-LSubject: Re: ORA-00600 error Yes I am running 8.1.7.3 .. Is this a bug ? What will I do then? Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - From: James Morle To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 03, 2002 9:33 PM Subject: RE: ORA-00600 error Are you running 8.1.7.3? This is a known bug, with a patch available. Regards James -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bunyamin K. KaradenizSent: 03 April 2002 18:21To: Multiple recipients of list ORACLE-LSubject: ORA-00600 error Dear Gurus , I am lack of UGA memory. How can I see how much uga memory is setup for users and will it be enough increasing sort_area_size ? The error is below. I recieve error in alert log. Wed Apr 03 18:19:20 2002Errors in file C:\oracle\admin\UYBS\udump\ORA02864.TRC:ORA-00600: internal error code, arguments: [729], [324], [space leak], [], [], [], [], [] The ORA02864.TRC file is 900 KB. I have selected some lines in trace file. The things I wonder in the ORA02864.TRC file is : *** 2002-04-03 18:19:17.187 *** SESSION ID:(17.792) 2002-04-03 18:19:16.875 ERROR: UGA memory leak detected 324 ** O/S info: user: Administrator, term: DALI, ospid: 992:1224, machine: ADALET\DALI program: last wait for 'SQL*Net message from client' blocking sess=0x0 seq=1484 wait_time=-2 driver id=28444553, #bytes=1, =0 Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA.
Re: ORA-00600 error
Title: Message Yes I am running 8.1.7.3 .. Is this a bug ? What will I do then? Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - From: James Morle To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 03, 2002 9:33 PM Subject: RE: ORA-00600 error Are you running 8.1.7.3? This is a known bug, with a patch available. Regards James -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bunyamin K. KaradenizSent: 03 April 2002 18:21To: Multiple recipients of list ORACLE-LSubject: ORA-00600 error Dear Gurus , I am lack of UGA memory. How can I see how much uga memory is setup for users and will it be enough increasing sort_area_size ? The error is below. I recieve error in alert log. Wed Apr 03 18:19:20 2002Errors in file C:\oracle\admin\UYBS\udump\ORA02864.TRC:ORA-00600: internal error code, arguments: [729], [324], [space leak], [], [], [], [], [] The ORA02864.TRC file is 900 KB. I have selected some lines in trace file. The things I wonder in the ORA02864.TRC file is : *** 2002-04-03 18:19:17.187 *** SESSION ID:(17.792) 2002-04-03 18:19:16.875 ERROR: UGA memory leak detected 324 ** O/S info: user: Administrator, term: DALI, ospid: 992:1224, machine: ADALET\DALI program: last wait for 'SQL*Net message from client' blocking sess=0x0 seq=1484 wait_time=-2 driver id=28444553, #bytes=1, =0 Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA.
Re: ORA-00600 error [729]
Is any of export(exp) job is being terminated abruptly? This is the main reason for this message. It was corrected in ver 7.3.4.5. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Wed, 03 Apr 2002 10:06:18 -0800 Bunyamin, I think you better check the following doc. from metalink... START * Doc ID: Note:31056.1 Type: REFERENCE Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 31-DEC-1996 Last Revision Date: 20-MAR-2002 Note: For additional ORA-600 related information please read [NOTE:146580.1] 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][b][c][d][e] VERSIONS: versions 7.X to 8.X 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. Repeated errors or large memory leaks can be diagnosed further by sending the alert.log and trace files to Oracle support. Known Issues: Bug 2177050: ORA-600 [729] after application of the 8.1.7.3 patchset The resulting trace file will include a memory dump which shows unfreed memory chunks with the tags "define var info" and/or "oactoid info". Workaround: Set EVENT 10262 with a LEVEL greater than the reported leak. A value of 100Kb (102400) is a reasonable limit. Fixed in 8.1.7.4 and 9.X releases. One-off patches are available for most platforms. . ** END HTH RS --- "Bunyamin K. Karadeniz" <[EMAIL PROTECTED]> wrote: > Dear Gurus , > I am lack of UGA memory. How can I see how much uga > memory is setup for users and will it be enough > increasing sort_area_size ? > The error is below. > I recieve error in alert log. > Wed Apr 03 18:19:20 2002 > Errors in file > C:\oracle\admin\UYBS\udump\ORA02864.TRC: > ORA-00600: internal error code, arguments: [729], > [324], [space leak], [], [], [], [], [] > > The ORA02864.TRC file is 900 KB. > I have selected some lines in trace file. The things > I wonder in the ORA02864.TRC file is : > *** 2002-04-03 18:19:17.187 > > *** SESSION ID:(17.792) 2002-04-03 18:19:16.875 > > ERROR: UGA memory leak detected 324 > > > ** > > > O/S info: user: Administrator, term: DALI, ospid: > 992:1224, machine: ADALET\DALI > > program: > > last wait for 'SQL*Net message from client' blocking > sess=0x0 seq=1484 wait_time=-2 > > driver id=28444553, #bytes=1, =0 > > > > > > Bunyamin K. Karadeniz > Oracle DBA / Developer > Civilian IT Department > Havelsan A.S. Eskisehir yolu > 7.km Ankara Turkey > Phone: +90 312 2873565 / 1217 > Mobile : +90 535 3357729 > > The degree of normality in a database > is inversely proportional to that of its DBA. > > > > > ATTACHMENT part 2 image/gif name=dbainblk.gif > The previous attachment was filtered out by the > ListGuru mailing > software at fatcity.com because binary attachments > are not appropriate > for mailing lists. If you want a copy of the > attachment which was > removed, contact the sender directly and ask for it > to be sent to > you by private E-mail. > > This warning is inserted into all messages > containing binary > attachments which have been removed by ListGuru. If > you have questions > about this message, contact [EMAIL PROTECTED] > for clarification. > > ATTACHMENT part 4 image/gif name=tech.gif __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed
[Fwd: ORA-00600 error]
Bünyamin, The trace you sent is not enough. But before determining if your memory is enough or not, we should understand if the requested memory size is normal or if UGA shrinks normally . For quick answer: Check "session uga memory" and "session uga memory max" statistics. can you attache the trace file ? regards... -- Danisment Gazi Unal http://www.unal-bilisim.com --- Begin Message --- Dear Gurus , I am lack of UGA memory. How can I see how much uga memory is setup for users and will it be enough increasing sort_area_size ? The error is below. I recieve error in alert log. Wed Apr 03 18:19:20 2002Errors in file C:\oracle\admin\UYBS\udump\ORA02864.TRC:ORA-00600: internal error code, arguments: [729], [324], [space leak], [], [], [], [], [] The ORA02864.TRC file is 900 KB. I have selected some lines in trace file. The things I wonder in the ORA02864.TRC file is : *** 2002-04-03 18:19:17.187 *** SESSION ID:(17.792) 2002-04-03 18:19:16.875 ERROR: UGA memory leak detected 324 ** O/S info: user: Administrator, term: DALI, ospid: 992:1224, machine: ADALET\DALI program: last wait for 'SQL*Net message from client' blocking sess=0x0 seq=1484 wait_time=-2 driver id=28444553, #bytes=1, =0 Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. dbainblk.gif Description: GIF image The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. tech.gif Description: GIF image --- End Message ---
RE: ORA-00600 error
Title: Message Are you running 8.1.7.3? This is a known bug, with a patch available. Regards James -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bunyamin K. KaradenizSent: 03 April 2002 18:21To: Multiple recipients of list ORACLE-LSubject: ORA-00600 error Dear Gurus , I am lack of UGA memory. How can I see how much uga memory is setup for users and will it be enough increasing sort_area_size ? The error is below. I recieve error in alert log. Wed Apr 03 18:19:20 2002Errors in file C:\oracle\admin\UYBS\udump\ORA02864.TRC:ORA-00600: internal error code, arguments: [729], [324], [space leak], [], [], [], [], [] The ORA02864.TRC file is 900 KB. I have selected some lines in trace file. The things I wonder in the ORA02864.TRC file is : *** 2002-04-03 18:19:17.187 *** SESSION ID:(17.792) 2002-04-03 18:19:16.875 ERROR: UGA memory leak detected 324 ** O/S info: user: Administrator, term: DALI, ospid: 992:1224, machine: ADALET\DALI program: last wait for 'SQL*Net message from client' blocking sess=0x0 seq=1484 wait_time=-2 driver id=28444553, #bytes=1, =0 Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA.
Re: ORA-00600 error
Bunyamin, I think you better check the following doc. from metalink... START * Doc ID: Note:31056.1 Type: REFERENCE Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 31-DEC-1996 Last Revision Date: 20-MAR-2002 Note: For additional ORA-600 related information please read [NOTE:146580.1] 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][b][c][d][e] VERSIONS: versions 7.X to 8.X 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. Repeated errors or large memory leaks can be diagnosed further by sending the alert.log and trace files to Oracle support. Known Issues: Bug 2177050: ORA-600 [729] after application of the 8.1.7.3 patchset The resulting trace file will include a memory dump which shows unfreed memory chunks with the tags "define var info" and/or "oactoid info". Workaround: Set EVENT 10262 with a LEVEL greater than the reported leak. A value of 100Kb (102400) is a reasonable limit. Fixed in 8.1.7.4 and 9.X releases. One-off patches are available for most platforms. . ** END HTH RS --- "Bunyamin K. Karadeniz" <[EMAIL PROTECTED]> wrote: > Dear Gurus , > I am lack of UGA memory. How can I see how much uga > memory is setup for users and will it be enough > increasing sort_area_size ? > The error is below. > I recieve error in alert log. > Wed Apr 03 18:19:20 2002 > Errors in file > C:\oracle\admin\UYBS\udump\ORA02864.TRC: > ORA-00600: internal error code, arguments: [729], > [324], [space leak], [], [], [], [], [] > > The ORA02864.TRC file is 900 KB. > I have selected some lines in trace file. The things > I wonder in the ORA02864.TRC file is : > *** 2002-04-03 18:19:17.187 > > *** SESSION ID:(17.792) 2002-04-03 18:19:16.875 > > ERROR: UGA memory leak detected 324 > > > ** > > > O/S info: user: Administrator, term: DALI, ospid: > 992:1224, machine: ADALET\DALI > > program: > > last wait for 'SQL*Net message from client' blocking > sess=0x0 seq=1484 wait_time=-2 > > driver id=28444553, #bytes=1, =0 > > > > > > Bunyamin K. Karadeniz > Oracle DBA / Developer > Civilian IT Department > Havelsan A.S. Eskisehir yolu > 7.km Ankara Turkey > Phone: +90 312 2873565 / 1217 > Mobile : +90 535 3357729 > > The degree of normality in a database > is inversely proportional to that of its DBA. > > > > > ATTACHMENT part 2 image/gif name=dbainblk.gif > The previous attachment was filtered out by the > ListGuru mailing > software at fatcity.com because binary attachments > are not appropriate > for mailing lists. If you want a copy of the > attachment which was > removed, contact the sender directly and ask for it > to be sent to > you by private E-mail. > > This warning is inserted into all messages > containing binary > attachments which have been removed by ListGuru. If > you have questions > about this message, contact [EMAIL PROTECTED] > for clarification. > > ATTACHMENT part 4 image/gif name=tech.gif __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-00600 error
Dear Gurus , I am lack of UGA memory. How can I see how much uga memory is setup for users and will it be enough increasing sort_area_size ? The error is below. I recieve error in alert log. Wed Apr 03 18:19:20 2002Errors in file C:\oracle\admin\UYBS\udump\ORA02864.TRC:ORA-00600: internal error code, arguments: [729], [324], [space leak], [], [], [], [], [] The ORA02864.TRC file is 900 KB. I have selected some lines in trace file. The things I wonder in the ORA02864.TRC file is : *** 2002-04-03 18:19:17.187 *** SESSION ID:(17.792) 2002-04-03 18:19:16.875 ERROR: UGA memory leak detected 324 ** O/S info: user: Administrator, term: DALI, ospid: 992:1224, machine: ADALET\DALI program: last wait for 'SQL*Net message from client' blocking sess=0x0 seq=1484 wait_time=-2 driver id=28444553, #bytes=1, =0 Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. dbainblk.gif Description: GIF image The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. tech.gif Description: GIF image
Re: [Fwd: [Fwd: Re: ora-00600 error]]
The ora-600 12333 occurs in the two task layer, if it receives a function
code or argument, that is unexpected or invalid. Normally,the arguments
after [12333] identify some details about this, and there are a few metalink
notes relevant. The 12333 will always be followed by an ora-3106.
In your case with the three [0] arguments, this is a bit weird. I've seen
a previous case before and I was speculating, the there were errors or bad
data being received either from SQL*Net or from the TCP/IP (or whatever networking)
software. I also had other indications (such as weird process state dumps
in the trace file), that indicated some sort of corruptions. However, I
couldn't verify this.
Thanks, Bjørn.
Original Message
Subject:
Re: ora-00600 error
Date:
Tue, 15 Jan 2002 10:35:35 -0800
From:
Glenn Stauffer
<[EMAIL PROTECTED]>
Reply-To:
[EMAIL PROTECTED]
Organization:
Fat City Network Services, San Diego, California
To:
Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
This comes up with an application that I manage. The error is a generic one which indicates that there is a problem in the communication between the client and the server process. In my situation, a Forms application, this occurs most often when a session gets timed out after being inactive for more than 10 hours. When they try to continue working with the Forms application, they get an error message on their screen and the Ora-00600 [12333] error gets logged on the server.GlennOn Tuesday 15 January 2002 10:20 am, you wrote:> I am getting an> ORA-00600: internal error code, arguments: [12333],> [0], [0], [0], [], [], [], []error. How do I find out> what is causing this problem?-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Glenn Stauffer INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: ora-00600 error
This comes up with an application that I manage. The error is a generic one which indicates that there is a problem in the communication between the client and the server process. In my situation, a Forms application, this occurs most often when a session gets timed out after being inactive for more than 10 hours. When they try to continue working with the Forms application, they get an error message on their screen and the Ora-00600 [12333] error gets logged on the server. Glenn On Tuesday 15 January 2002 10:20 am, you wrote: > I am getting an > ORA-00600: internal error code, arguments: [12333], > [0], [0], [0], [], [], [], []error. How do I find out > what is causing this problem? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Ora-00600 Error
12333 it is often related with communications problems and resetting of them. Seldom related with parsing of creation of objects. In the case of network problem check the NLS and ask users if there are receiving sporadically TNS errors. Check also if there are some 4031. Maybe the reason it is that known error. Regards. --- GL2Z/ INF DBA BENLATRECHE <[EMAIL PROTECTED]> wrote: > Hi all, > > I recently installed an Oracle 8.1.6 under > Netware 5. > The server is HP LH3000 with 1Go of Memory and 3x9 > Go of disk space. > > I have two instances and since that the server > hangs frequently (min 2 > times a day) and the error in the trace file is > > > > *** SESSION ID:(13.123) 2001-12-30 13:12:24.000 > *** 2001-12-30 13:12:24.000 > ksedmp: internal or fatal error > ORA-00600: internal error code, arguments: [12333], > [7], [5], [52], [], [], > [], [] > Current SQL information unavailable - no session. > > Best Regards > Kamel Benlatreche > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: GL2Z/ INF DBA BENLATRECHE > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = ENG. Christian Trassens Senior DBA [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +34-699240979 +34-649824704 __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Ora-00600 Error
Hi all, I recently installed an Oracle 8.1.6 under Netware 5. The server is HP LH3000 with 1Go of Memory and 3x9 Go of disk space. I have two instances and since that the server hangs frequently (min 2 times a day) and the error in the trace file is *** SESSION ID:(13.123) 2001-12-30 13:12:24.000 *** 2001-12-30 13:12:24.000 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [12333], [7], [5], [52], [], [], [], [] Current SQL information unavailable - no session. Best Regards Kamel Benlatreche -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-00600 error
--Boundary-00=_KX21TSM1VA40 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi DBA's,=0D =0D We have a database procedure which transfers the data from one database(v= er 8.1.5 on Sun) to =0D another(ver 8.0.6 on HP) though DB Link.=0D If i run this procedure from sql*plus it works fine, but if being called from =0D Pro*C Environment it gives message :=0D /***/=0D ORA-00600: internal error code, arguments: [18186], [], [], [], [], [], [= ], []=0D /***/=0D =0D Through debug i trace its because of one insert statement. One more thing= i want to describe same insert statement working fine from sql*plus and als= o from diffenent procedure.=0D =0D Anyone can help me ?=0D =0D TIA.=0D --=0D Vijay Patidar --Boundary-00=_KX21TSM1VA40 Content-Type: Text/HTML; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi DBA's, We have a database procedure which transfers the data from one= =20 database(ver 8.1.5 on Sun) to another(ver 8.0.6 on HP= )=20 though DB Link.If i run this procedure from sql*plus it w= orks=20 fine, but if being called from Pro*C Environment it gives messa= ge=20 :/***/ORA-00600: internal error code, arguments: [18186= ], [],=20 [], [], [], [], [], []/***/ Through debug i trace its because of one insert statement. One= more=20 thing i want to describe same insert statement working fine from sq= l*plus=20 and also from diffenent procedure. Anyone can help me ? TIA. -- Vijay Patidar =09 =09 =09 =09 =09 =09 =09 _IncrediMail - Email has finally= =20 evolved - http://www.incredimail.com/redir.asp?ad_id=3D109";>Click=20 Here --Boundary-00=_KX21TSM1VA40-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vijay Patidar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
