Oracle 8.0.6 Server Process Dump

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 - 04:01:00 CST