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: Shakespeare <whatsin_at_xs4all.nl>
Date: Thu, 23 Aug 2007 18:28:51 +0200
Message-ID: <46cdb5c7$0$240$e4fe514c@news.xs4all.nl>

<viren.dave_at_gmail.com> schreef in bericht news:1187875435.831150.176900_at_q3g2000prf.googlegroups.com...

> 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
>

You'll have to PAY for it....

Shakespeare Received on Thu Aug 23 2007 - 11:28:51 CDT

Original text of this message

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