Re: ORA-00600: internal error code, arguments: [20084], [37832410], [7], [37832410], [7], [], [], []

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Tue, 21 Aug 2007 14:37:10 +0200
Message-ID: <46cadc85$0$245$e4fe514c@news.xs4all.nl>

<viren.dave_at_gmail.com> schreef in bericht news:1187698991.390070.149970_at_g4g2000hsf.googlegroups.com...

> On Aug 21, 4:56 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:

>> On Aug 21, 7:44 am, viren.d..._at_gmail.com wrote:
>>
>>
>>
>>
>>
>> > Can you explain what is this problem ????
>>
>> > I'm using Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production.
>>
>> > When I run PL/SQL Block in SQL +; I have find error like:
>>
>> > ERROR at line 1:
>> > ORA-00600: internal error code, arguments: [20084], [37832410], [7],
>> > [37832410], [7], [], [], []
>>
>> > My PL/SQL Block:
>> > -----------------------------------------
>> > --- Script By Viren Dave (ACE-SSG) ---
>> > --- Date : 20-Aug-2007 5:52 PM ---
>> > --- PQG QA/PFR WP COUNT PL/SQL Script ---
>> > -----------------------------------------
>> > SET PAGESIZE 1000
>> > SET LINE 1000
>> > -- Variable Declare
>> > UNDEFINE DATE
>> > -- Variable Get
>> > ACCEPT DATE PROMPT "Enter Date (YYYYMMDD) :"
>> > -- SQL Block
>> > SELECT
>> > VQA.EMP_CODE PQA_CODE, E.FIRST_NAME, ROUND(SUM(EP.TIME),2) TIME,
>> > COUNT(VQA.WP_NO) WPKS,
>> > MIN(VQA.ALLOT_DATE_TIME) S_TIME, MAX(VQA.RETURN_DATE_TIME) E_TIME
>> > FROM
>> > V_PQA_ALLOCATION VQA, EMPPRD EP, EMPLOYEE E
>> > WHERE
>> > VQA.STATUS='COMPLETE'
>> > AND EP.STATUS='COMPLETE'
>> > AND VQA.JOB_NO=EP.JOB_NO
>> > AND VQA.BATCH_NO=EP.BATCH_NO
>> > AND VQA.TASK_CODE=EP.TASK_CODE
>> > AND VQA.WP_ID=EP.WP_ID
>> > AND VQA.EMP_CODE=E.EMP_CODE
>> > AND TO_CHAR(VQA.ALLOT_DATE_TIME, 'YYYYMMDD') = '&DATE'
>> > GROUP BY
>> > VQA.EMP_CODE, E.FIRST_NAME
>> > ORDER BY
>> > VQA.EMP_CODE, E.FIRST_NAME;
>>
>> > Thanks in advance & Worm Regards,
>> > Viren Dave
>> > viren.d..._at_gmail.com
>>
>> The oracle 600's show some kind of internal error in oracle written
>> code. Something blew up somewhere.
>>
>> You can work with oracle support and there are several tools to help
>> investigate oracle 600 errors.
>>
>> If you are running this on a 9.2.0.1 system the odds are pretty good
>> that oracle may have fixed this problem already and that your system
>> is just missing maintenance from oracle.
>>
>> Of course you need a support contract to be able to download and apply
>> maintenance.- Hide quoted text -
>>
>> - Show quoted text -

>
> Dear friend,
>
> I know this is internal error but, what is problem ?
>
> I have formatted my Oracle Server and create new database just before
> 7 day.
>
> before formatting my Oracle Server this PL/SQL Block working fine.
> but, after formatting this server only this block has problem in
> executing. please guide me what to do I'm ?
>
> Please, also guide me about support contract....
>
> Thanks & Regards,
> Viren Dave
> viren.dave_at_gmail.com
>

Exactly what do you mean by "Formatting a server"?

Shakespeare Received on Tue Aug 21 2007 - 07:37:10 CDT