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

On Aug 21, 5:44 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> On Aug 21, 8:23 am, viren.d..._at_gmail.com wrote:
>
>
>
> > 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.d..._at_gmail.com
>
> Well you can contact oracle sales (http://www.oracle.com) and either
> thru negotiations with a sales or from the oracle sales store purchase
> software and a support contract.
>
> When you pay oracle for a support contract then you can work with
> oracle support (http://www.oracle.com/support/index.html) on issues
> that you run into ( like this one ).
>
> You can submit service requests thru metalink and search for known
> issues like oracle 600 errors, download patchsets, etc.

Dear Friend,
how can i get access code ??
its need to registration in metalink

please guide me...

Viren Dave
email: viren.dave
viren.dave_at_gmail.com Received on Thu Aug 23 2007 - 08:23:55 CDT