Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00600: internal error code, arguments: [3668], [1], [2], [205376],
"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
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_
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