I've seen the error before when the indexes are corrupted but never to
the point where the whole instance crashes . At this point, the only
advice that I have is to try to drop and recreate the table and retry
the import (with no indexes) and see how it goes
Good luck
Renzo
Alessandro wrote:
> 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 Fri Nov 10 2006 - 18:01:58 CST
