Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00600: internal error code, arguments: [3668], [1], [2], [205376],

Re: ORA-00600: internal error code, arguments: [3668], [1], [2], [205376],

From: yls177 <yls177_at_hotmail.com>
Date: 11 Dec 2003 16:09:04 -0800
Message-ID: <c06e4d68.0312111609.7107a7ef@posting.google.com>


"Oradba Linux" <oradba_linux_at_comcast.net> wrote in message news:<3S1Cb.506892$Tr4.1395391_at_attbi_s03>...
> Please open a TAR with Oracle Support .
>
> "yls177" <yls177_at_hotmail.com> wrote in message
> news:c06e4d68.0312101640.64a1df81_at_posting.google.com...
> > hi, i did a startup and then got the below
> >
> > ORA-00600: internal error code, arguments: [3668], [1], [2], [205376],
> > [205376], [4], [], []
> >
> >
> > from my user trace file as belows
> >
> > ORA-00600: internal error code, arguments: [3668], [1], [2], [205376],
> > [205376], [4], [], []
> > Current SQL statement for this session:
> > alter database open
> > ----- Call Stack Trace -----
> > calling call entry argument values in hex
> > location type point (? means dubious value)
> > -------------------- -------- --------------------
> > ----------------------------
> > ksedmp+00d4 bl ksedst 1010FD95C ?
> > ksfdmp+0018 bl ksedmp 110000730 ?
> > kgeriv+0140 ? 00000000
> > kgesiv+009c bl kgeriv 110000730 ? 1101FCC50 ? 1 ?
> > 70000009B800065 ? 0 ?
> > ksesic5+0054 bl kgesiv 110000730 ? 1101FCC50 ? 1 ?
> > 70000009B800065 ? 0 ?
> > kcvcrv+0eb8 bl ksesic5 E5400000E54 ? 0 ? 1 ? 0 ? 2 ?
> > 0 ? 32240 ? 0 ?
> > kcfopd+0150 bl kcvcrv FFFFFFFFFFFA1F8 ? 0 ?
> > adbdrv+0618 bl kcfopd 9B7F7830 ? 10000558 ?
> > opiexe+1658 bl adbdrv
> > opiosq+05b8 bl opiexe 400000139 ? 100000001 ? 0 ?
> > opiodr+03c0 ? 00000000
> > ttcpip+0338 ? 00000000
> > opitsk+0298 bl ttcpip 57B0000057B ? 1 ? 11006EEF8 ?
> > 7FF ? 1A ? 0 ? 110082C38 ?
> > 0 ?
> > opiino+04b8 bl opitsk 200FEA1A ?
> > opiodr+03c0 ? 00000000
> > opidrv+02d0 bl opiodr 3CFFFFF9D0 ? 41009A6B8 ?
> > FFFFFFFFFFFFE00 ? 100D5290 ?
> > sou2o+0028 bl opidrv 3C00000007 ? 400000000 ?
> > FFFFFFFFFFFFE00 ?
> > main+00c8 bl sou2o 90000000022D624 ?
> > 9FFFFFFF0009EE0 ?
> > FFFFFFFFFFFFE10 ?
> > 9001000A00AE448 ?
> > __start+0090 bl main 0 ? 0 ?
> >
> >
> > also, i realised that there are no rollback segments at all. could
> > this be the problem
> >
> > i found something in
> >
> http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
> ase_id=NOT&p_id=93665.1
> >
> > i havent solved it.... just to post it to share my experience..

select * from v$recover_file;
FILE# ONLINE ERROR CHANGE# TIME

---------- ------- ------------------ ---------- ---------
67 OFFLINE FILE MISSING 0
1 row selected.

SVRMGR> select * from dba_data_files where file_id='67'; FILE_NAME FILE_ID TABLESPACE_NAME
BYTES BLOCKS STATUS RELATIVE_F AUT MAXBYTES MAXBLOCKS INCREMENT_


the original file is -rw-r----- 1 orasid dba 1038090240 Dec 10 15:45 /oracle/sid/sapdata3/stabd_4/stabd.data4

how can i recover?

can i do the below
==>

alter tablespace PSAPBTABD offline normal alter database datafile 'oracle/sid/sapdata3/stabd_4/stabd.data4' online;
alter tablespace PSAPBTABD online; Received on Thu Dec 11 2003 - 18:09:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US