RE: ORA-00600

From: Singla, Sanjeev <SSingla_at_oxhp.com>
Date: Wed, 21 Jun 2000 11:53:36 -0400
Message-Id: <10535.110013@fatcity.com>

ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
This message clearly says that u are trying to use some blocks which are beyond the accessibility of oracle.

do
Alter database datafile file_name resize X M ; Where X = something less than 2Gig.

-----Original Message-----
From: Kader Ben [mailto:kaderb_at_yahoo.com] Sent: Wednesday, June 21, 2000 12:12 PM
To: Multiple recipients of list ORACLE-L Subject: ORA-00600

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

Do You Yahoo!?
Send instant messages with Yahoo! Messenger. http://im.yahoo.com/

-- 
Author: Kader Ben
  INET: kaderb_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Wed Jun 21 2000 - 10:53:36 CDT