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: Oracle 8.0.6 Database Process Dump

Re: Oracle 8.0.6 Database Process Dump

From: Renzo Zagni <renzo.zagni_at_gmail.com>
Date: 9 Nov 2006 11:54:40 -0800
Message-ID: <1163102080.128916.243280@k70g2000cwa.googlegroups.com>


Alessandro

Are you executing a truncate or delete on the object at the same time ?

Renzo
Alessandro wrote:
> Hi guys,
>
> I'm working on an import of data on an Oracle 8.0.6 Database that is
> running an an HP-UX 10.X
>
> The code that imports the data is written in C++ and compiled with the
> HP aCC C++ Compiler.
>
> About two days ago, a new problem is persent and regards the server
> process that manage the connection and the operations performed from
> the C++ application. This process dumps.
>
> On the Alert Log of Oracle, the following information are traced.
>
> Thread 1 advanced to log sequence 3053
> Current log# 2 seq# 3053 mem# 0:
> /home/data/local/ORACLE/dbs_files/log2ccis.dbf
> Thu Nov 9 09:16:42 2006
> Errors in file /home/segments/ORACLE/rdbms/log/ora_4036.trc:
> ORA-00600: internal error code, arguments: [kcbget_24], [1], [20],
> [88098603], [88098601], [88098601], [1], []
> Thu Nov 9 09:16:43 2006
> Failure to extend rollback segment 2 because of 600 condition
> FULL status of rollback segment 2 set.
> Thu Nov 9 09:16:43 2006
> Errors in file /home/segments/ORACLE/rdbms/log/ora_4036.trc:
> ORA-00600: internal error code, arguments: [kcbget_24], [1], [20],
> [88098603], [88098601], [88098601], [1], []
> ORA-01562: failed to extend rollback segment number 2
> ORA-00600: internal error code, arguments: [kcbget_24], [1], [20],
> [88098603], [88098601], [88098601], [1], []
> Thu Nov 9 09:16:44 2006
>
> The Information regarding the error on the extension of rollback
> segment number 2 has no sense beacuse the number of extention already
> use when the process dumps is 17. The Max number of extention is 121.
>
> ON the Trace file for the process dumped, I can found the involved SQL
> statemet here reported.
>
> *** SESSION ID:(10.590) 2006-11-09 09:16:42.764
> *** 2006-11-09 09:16:42.764
> ksedmp: internal or fatal error
> ORA-00600: internal error code, arguments: [kcbget_24], [1], [20],
> [88098603], [88098601], [88098601], [1], []
> Current SQL statement for this session:
> insert into eh101.MODE_TABLE (ID , MC , SC , RF_ID
> , PRFPRI_ID, PD_ID , SCAN_ID , BW_ID , MP , FC1 , FC2
> , RW , W , REMARKS , UC ) values (
> -1770168203, 'AM ', '_ ', 1359374680, -1628641685, -353359992,
> 1785516761, -1569751356, 'D ', 'AI ', 'TA ', 'S ', ' ', ' ', 'R ')
>
>
> The statement is correct and, inside TOAD, it doesn't create any
> problem to the Oracle Server Process.
>
> I have tried to reboot the machine, change the rollback segments
> available to the server but the problem is still present.
>
> Any idea for a workaround or solution for this problem ?
>
> I know that the Oracle 8.0.6 is a little old but it cannot be changed
> due to other application that are running on the HP-UX 10.X
>
> Thanks for the help.
>
> Alessandro
Received on Thu Nov 09 2006 - 13:54:40 CST

Original text of this message

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