Re: Oracle 8.0.6 Database Process Dump

Hi Renzo,

at the start of import I drop some foreign keys that are involved during the process in order to speed-up the delete of old data and the load of new data.

Then, I start a transaction on which I perform the delete of all involved tables and then, in the same transaction I load the data.

In this phase, there is the problem of crash of oracle server process.

This afternoon, there was another big problem... not only the process that it is managing my connection go down but all the oracle database istance go down... very strange....

These situation occurs on a development machine that is phisically disconnected from the other developer enviroment due to the classified data that are used during this import.

I cannot perform the truncate of involved table beacuse in this case I cannot rollback the import if an error occurs.

Do you have an idea on the source of problem ??

Thanks and best regards.

Alessandro

Renzo Zagni ha scritto:

> 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 - 16:14:04 CST