Oracle 8.0.6 Server Process Dump

Giganews Newsgroups
Subject: Oracle 8.0.6 Server Process Dump
Posted by:  Alessandro (alessandro.vanzul…@gmail.com)
Date: 9 Nov 2006

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

Replies