.ora-code.com

Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
anyone awake out there...ORA-00600: ...[kteuPropTime-2]..any ideas, thoughts

anyone awake out there...ORA-00600: ...[kteuPropTime-2]..any ideas, thoughts

2005-07-17       - By Marquez, Chris
Reply:     1     2  

Well not TAR update...sev 1...we are down. :0|

Amazing what a little "pain" from you client and lack of sleep does for ones
"self motivation".

Google (the other Oracle Support) produced this;
    http://www.oracleadvice.com/BUGBUSTER/bug_autoundo.htm
A great doc...makes sense and I have (sadly) recovered from corrupt RBS/UNDO
before.

Once / If, I get the database up again, looks like my options are;
- Upgrade to 9206
- Use one-off patch for 9203 Bug: 2431450 - START EXTENT NUMBER NOT UPDATED
CORRECTLY, FOR COMMITTED TXNS WHICH HAVE NTP SET

But I wonder and hope that maybe I can just *not* use UNDO and go backup to old
school RBS and *avoid* the problem/bug?

ok...I'm rambling.

Chris Marquez
Oracle DBA


-- --Original Message-- --
From: oracle-l-bounce@(protected) on behalf of Marquez, Chris
Sent: Sun 7/17/2005 3:14 AM
To: oracle-l@(protected)
Subject: anyone awake out there...ORA-00600 (See ORA-00600.ora-code.com): ...[kteuPropTime-2]..any ideas,
thoughts...have a tar open...Note:233864.1

???

Oracle has encountered an error propagating Extent Commit Times in
 the Undo Segment Header / Extent Map Blocks, for System Managed Undo
 Segments

 The extent being referenced is not valid.



Sun Jul 17 01:25:14 2005
ARC0: Completed archiving  log 1 thread 1 sequence 14
Sun Jul 17 01:25:51 2005
Errors in file /oracle//bdump/orcl_j001_115070.trc:
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [kteuPropTime-2], [], [], [], [], []
, [], []
Sun Jul 17 01:25:55 2005
Errors in file /oracle//bdump/orcl_j001_115070.trc:
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [kteuPropTime-2], [], [], [], [], []
, [], []
ORA-12008 (See ORA-12008.ora-code.com): error in materialized view refresh path
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [kteuPropTime-2], [], [], [], [], []
, [], []
Sun Jul 17 01:25:56 2005
Error 600 trapped in 2PC on transaction 2.9.24787. Cleaning up.
Error stack returned to user:
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [kteuPropTime-2], [], [], [], [], []
, [], []
ORA-12008 (See ORA-12008.ora-code.com): error in materialized view refresh path
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [kteuPropTime-2], [], [], [], [], []
, [], []
Sun Jul 17 01:25:56 2005
Errors in file /oracle//bdump/orcl_j001_115070.trc:
ORA-00603 (See ORA-00603.ora-code.com): ORACLE server session terminated by fatal error
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [kteuPropTime-2], [], [], [], [], []
, [], []
ORA-12008 (See ORA-12008.ora-code.com): error in materialized view refresh path
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [kteuPropTime-2], [], [], [], [], []
, [], []
Sun Jul 17 01:26:31 2005
Errors in file /oracle//udump/orcl_ora_648044.trc:
ORA-07445 (See ORA-07445.ora-code.com): exception encountered: core dump [] [] [] [] [] []
Sun Jul 17 01:26:31 2005



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7232.39">
<TITLE>RE: anyone awake out there...ORA-00600 (See ORA-00600.ora-code.com): ...[kteuPropTime-2]..any ideas,
thoughts...have a tar open...Note:233864.1</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->

<P><FONT SIZE=2>Well not TAR update...sev 1...we are down. :0|<BR>
<BR>
Amazing what a little &quot;pain&quot; from you client and lack of sleep does
for ones &quot;self motivation&quot;.<BR>
<BR>
Google (the other Oracle Support) produced this;<BR>
&nbsp;&nbsp;&nbsp;&nbsp; <A HREF="http://www.oracleadvice.com/BUGBUSTER/bug
_autoundo.htm">http://www.oracleadvice.com/BUGBUSTER/bug_autoundo.htm</A><BR>
A great doc...makes sense and I have (sadly) recovered from corrupt RBS/UNDO
before.<BR>
<BR>
Once / If, I get the database up again, looks like my options are;<BR>
&nbsp;- Upgrade to 9206<BR>
&nbsp;- Use one-off patch for 9203 Bug: 2431450 - START EXTENT NUMBER NOT
UPDATED CORRECTLY, FOR COMMITTED TXNS WHICH HAVE NTP SET<BR>
<BR>
But I wonder and hope that maybe I can just *not* use UNDO and go backup to old
school RBS and *avoid* the problem/bug?<BR>
<BR>
ok...I'm rambling.<BR>
<BR>
Chris Marquez<BR>
Oracle DBA<BR>
<BR>
<BR>
-- --Original Message-- --<BR>
From: oracle-l-bounce@(protected) on behalf of Marquez, Chris<BR>
Sent: Sun 7/17/2005 3:14 AM<BR>
To: oracle-l@(protected)<BR>
Subject: anyone awake out there...ORA-00600 (See ORA-00600.ora-code.com): ...[kteuPropTime-2]..any ideas,
thoughts...have a tar open...Note:233864.1<BR>
<BR>
???<BR>
<BR>
Oracle has encountered an error propagating Extent Commit Times in<BR>
&nbsp; the Undo Segment Header / Extent Map Blocks, for System Managed Undo<BR>
&nbsp; Segments<BR>
<BR>
&nbsp; The extent being referenced is not valid.<BR>
<BR>
<BR>
<BR>
Sun Jul 17 01:25:14 2005<BR>
ARC0: Completed archiving&nbsp; log 1 thread 1 sequence 14<BR>
Sun Jul 17 01:25:51 2005<BR>
Errors in file /oracle//bdump/orcl_j001_115070.trc:<BR>
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [kteuPropTime-2], [], [], [], [], []
, [], []<BR>
Sun Jul 17 01:25:55 2005<BR>
Errors in file /oracle//bdump/orcl_j001_115070.trc:<BR>
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [kteuPropTime-2], [], [], [], [], []
, [], []<BR>
ORA-12008 (See ORA-12008.ora-code.com): error in materialized view refresh path<BR>
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [kteuPropTime-2], [], [], [], [], []
, [], []<BR>
Sun Jul 17 01:25:56 2005<BR>
Error 600 trapped in 2PC on transaction 2.9.24787. Cleaning up.<BR>
Error stack returned to user:<BR>
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [kteuPropTime-2], [], [], [], [], []
, [], []<BR>
ORA-12008 (See ORA-12008.ora-code.com): error in materialized view refresh path<BR>
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [kteuPropTime-2], [], [], [], [], []
, [], []<BR>
Sun Jul 17 01:25:56 2005<BR>
Errors in file /oracle//bdump/orcl_j001_115070.trc:<BR>
ORA-00603 (See ORA-00603.ora-code.com): ORACLE server session terminated by fatal error<BR>
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [kteuPropTime-2], [], [], [], [], []
, [], []<BR>
ORA-12008 (See ORA-12008.ora-code.com): error in materialized view refresh path<BR>
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [kteuPropTime-2], [], [], [], [], []
, [], []<BR>
Sun Jul 17 01:26:31 2005<BR>
Errors in file /oracle//udump/orcl_ora_648044.trc:<BR>
ORA-07445 (See ORA-07445.ora-code.com): exception encountered: core dump [] [] [] [] [] []<BR>
Sun Jul 17 01:26:31 2005<BR>
<BR>
<BR>
</FONT>
</P>

</BODY>
</HTML>