Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00600: internal error code, arguments: [20084], [37832410], [7], [37832410], [7], [], [], []

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

From: Cristian Cudizio <cristian.cudizio_at_yahoo.it>
Date: Tue, 21 Aug 2007 05:44:40 -0700
Message-ID: <1187700280.164633.228710@50g2000hsm.googlegroups.com>


On Aug 21, 2:23 pm, 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

what does it means that you have formatte Oracle Server and created a new database?
As already said it is a problem not handled by Oracle (otherwise you would have got another error or no error) Maybe a bug, maybe a memory configuration, maybe a corrupted file however
you have to think about passing to 9.2.0.8

regards

Cristian Cudizio
http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com Received on Tue Aug 21 2007 - 07:44:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US