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

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 Received on Tue Aug 21 2007 - 07:23:11 CDT