ORA-00600

From: Kader Ben <kaderb_at_yahoo.com>
Date: Wed, 21 Jun 2000 07:57:04 -0700 (PDT)
Message-Id: <10535.109998@fatcity.com>

Hi listers,

Since yesterday the udump trace file is growing too fast by the above error message. When I called the oracle customer support, they suspect that my temp tablespace with 2G is the source of the problem. So I want reduce this tablespace, could someone give the step by step to how to recreate the smaller one? TIA Ben

Dump file

/opt/Oracle/admin/infi/udump/infi_ora_29610.trc
Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
ORACLE_HOME = /opt/Oracle/product/8.0.5
System name: SunOS
......
Redo thread mounted by this instance: 1
Oracle process number: 39
Unix process pid: 29610, image: oracleinfi

SESSION ID:(111.1571) 2000.06.20.13.16.50.000
2000.06.20.13.16.50.000 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [17588], [21068724], [], [], [], [], [], [] ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file Additional information: 522925 Additional information: 16 Additional information: 522197 Current SQL statement for this session: Select * From webfin_actu where APPROVED='OUI' AND TYPENEWS='int' AND DATENEWS <= '2000/06/20' ORDER BY DATENEWS DESC, TIMENEWS DESC ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- --------------------
ksedmp()+148 CALL ksedst()+0 540 ? 0 ? EFFFCC34 ?

EFFFC6D8 ? EFFFC6BC ? 0 ?
kgeriv()+196 PTR_CALL 00000000 3 ? 0 ? 0 ? 258 ? 1 ? 44B4 ?
kgesiv()+96 CALL kgeriv()+0 1038C24 ? 107990C ? DAF1A0 ?

1 ?

EFFFD250 ? 1030594 ?

Alert log file

Additional information: 524160
Additional information: 16
Additional information: 522197

Tue Jun 20 13:44:54 2000
Errors in file
/opt/Oracle/admin/infi/udump/infi_ora_3678.trc:
ORA-00600: internal error code, arguments: [17588], [21068724], [], [], [], [], [], []
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file

Additional information: 524160
Additional information: 16
Additional information: 522197
---------------------------

Tablespaces

/Oradata/dsk1/dbs/infi/infi-syst SYSTEM
157286400 AVAILABLE
/Oradata/dsk1/dbs/infi/infi-rbs0 RBS
146800640 AVAILABLE
/Oradata/dsk1/dbs/infi/infi-temp TEMP
2159886336 AVAILABLE
/Oradata/dsk1/dbs/infi/infi-tool TOOLS
15728640 AVAILABLE
/Oradata/dsk1/dbs/infi/infi-appe APPELLE
10485760 AVAILABLE
/Oradata/dsk1/dbs/infi/infi-infi INFI_DAT
178257920 AVAILABLE
/Oradata/dsk1/dbs/infi/infi-infi INFI_IDX
10485760 AVAILABLE
/Oradata/dsk1/dbs/infi/infi-proj PROJ_DAT
10485760 AVAILABLE
/Oradata/dsk1/dbs/infi/infi-proj PROJ_IDX
10485760 AVAILABLE
/Oradata/dsk1/dbs/infi/infi-pers PERSO
83886080 AVAILABLE
/Oradata/dsk1/dbs/infi/infi-infi INFI_DAT
314572800 AVAILABLE

Received on Wed Jun 21 2000 - 09:57:04 CDT