| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Error after resize of LMT
Robyn - Thanks for replying. So what was the consequence of the error? What
did you have to do to fix the problem?
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Wednesday, January 07, 2004 8:40 AM
To: Multiple recipients of list ORACLE-L
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.
------_=_NextPart_001_01C3D52C.273B9780
Content-Type: text/plain
We've seen this error on one of our databases (9.2.0.3 on Win2003 Server).
Haven't seen it on our other instances (9.2.0.3 on HP-UX).
Robyn
-----Original Message-----
Sent: Tuesday, January 06, 2004 11:50 AM
To: Multiple recipients of list ORACLE-L
I've done a LOT of resizing of LMT tablespaces (9.2.0.1) and have never gotten that error..
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: wisernet100_at_yahoo.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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 also send the HELP command for other information (like subscribing). - - - - - - - Appended by Scientific-Atlanta, Inc. - - - - - - - This e-mail and any attachments may contain information which is confidential, proprietary, privileged or otherwise protected by law. The information is solely intended for the named addressee (or a person responsible for delivering it to the addressee). If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete it from your computer. ------_=_NextPart_001_01C3D52C.273B9780 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3DUS-ASCII"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version 5.5.2655.35"> <TITLE>FW: Error after resize of LMT</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>We've seen this error on one of our databases (9.2.0.3 on= Win2003 Server).</FONT> </P> <P><FONT SIZE=3D2>Haven't seen it on our other instances (9.2.0.3 on HP-UX)= .</FONT> </P> <P><FONT SIZE=3D2>Robyn</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Rachel Carmichael [<A HREF=3D"mailto:wisernet100_at_y= ahoo.com">mailto:wisernet100_at_yahoo.com</A>] </FONT> <BR><FONT SIZE=3D2>Sent: Tuesday, January 06, 2004 11:50 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Re: Error after resize of LMT</FONT> </P> <BR> <P><FONT SIZE=3D2>I've done a LOT of resizing of LMT tablespaces (9.2.0.1) = and have never</FONT> <BR><FONT SIZE=3D2>gotten that error..</FONT> </P> <BR> <P><FONT SIZE=3D2>--- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote= :</FONT> <BR><FONT SIZE=3D2>> Has anyone encountered the ORA-600[kcbnew_3] error = after resizing and</FONT> <BR><FONT SIZE=3D2>> LMT in</FONT> <BR><FONT SIZE=3D2>> Oracle9i?</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> A vendor install script created tablespaces really = large, and I</FONT> <BR><FONT SIZE=3D2>> started to</FONT> <BR><FONT SIZE=3D2>> resize them smaller, but checked Metalink. There is= a bug 2747978</FONT> <BR><FONT SIZE=3D2>> that says</FONT> <BR><FONT SIZE=3D2>> in versions below 9.2.0.4 you can encounter an ORA-= 600 error after</FONT> <BR><FONT SIZE=3D2>> resizing.</FONT> <BR><FONT SIZE=3D2>> Oracle says they were able to reproduce it. The bug= report says this</FONT> <BR><FONT SIZE=3D2>> produces a severe loss of service. As a workaround = it says to bounce</FONT> <BR><FONT SIZE=3D2>> the</FONT> <BR><FONT SIZE=3D2>> database after resizing. </FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> I'm just trying to figure out how likely this error= is to occur, so I</FONT> <BR><FONT SIZE=3D2>> though</FONT> <BR><FONT SIZE=3D2>> I'd ask if anyone has encountered this error. And i= f it occurred, how</FONT> <BR><FONT SIZE=3D2>> severe</FONT> <BR><FONT SIZE=3D2>> were the consequences? I can't apply the 9.2.0.4 pa= tch because the</FONT> <BR><FONT SIZE=3D2>> vendor</FONT> <BR><FONT SIZE=3D2>> says they don't support that yet. Thanks.</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Dennis Williams</FONT> <BR><FONT SIZE=3D2>> DBA</FONT> <BR><FONT SIZE=3D2>> Lifetouch, Inc.</FONT> <BR><FONT SIZE=3D2>> dwilliams_at_lifetouch.com </FONT> <BR><FONT SIZE=3D2>> -- </FONT> <BR><FONT SIZE=3D2>> Please see the official ORACLE-L FAQ: <A HREF=3D"ht= tp://www.orafaq.net" TARGET=3D"_blank">http://www.orafaq.net</A></FONT> <BR><FONT SIZE=3D2>> -- </FONT> <BR><FONT SIZE=3D2>> Author: DENNIS WILLIAMS</FONT> <BR><FONT SIZE=3D2>> INET: DWILLIAMS_at_LIFETOUCH.COM</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Fat City Network Services -- 858-= 538-5051 <A HREF=3D"http://www.fatcity.com" TARGET=3D"_blank">http://www.fa= tcity.com</A></FONT> <BR><FONT SIZE=3D2>> San Diego, California = -- Mailing list and web hosting services</FONT> <BR><FONT SIZE=3D2>> ---------------------------------------------------= ------------------</FONT> <BR><FONT SIZE=3D2>> To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'L= istGuru') and in</FONT> <BR><FONT SIZE=3D2>> the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>> (or the name of mailing list you want to be removed= from). You may</FONT> <BR><FONT SIZE=3D2>> also send the HELP command for other information (l= ike subscribing).</FONT> </P> <BR> <P><FONT SIZE=3D2>__________________________________</FONT> <BR><FONT SIZE=3D2>Do you Yahoo!?</FONT> <BR><FONT SIZE=3D2>Yahoo! Hotjobs: Enter the "Signing Bonus" Swee= pstakes</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://hotjobs.sweepstakes.yahoo.com/signingb= onus" TARGET=3D"_blank">http://hotjobs.sweepstakes.yahoo.com/signingbonus</= A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A HREF=3D"http://= www.orafaq.net" TARGET=3D"_blank">http://www.orafaq.net</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Rachel Carmichael</FONT> <BR><FONT SIZE=3D2> INET: wisernet100_at_yahoo.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- 858-538-50= 51 <A HREF=3D"http://www.fatcity.com" TARGET=3D"_blank">http://www.fatcity.= com</A></FONT> <BR><FONT SIZE=3D2>San Diego, California  = ; -- Mailing list and web hosting services</FONT> <BR><FONT SIZE=3D2>--------------------------------------------------------= -------------</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an E-Mai= l message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGu= ru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB ORACL= E-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed from= ). You may</FONT> <BR><FONT SIZE=3D2>also send the HELP command for other information (like s= ubscribing).</FONT> </P> <FONT SIZE=3D3><BR> <BR> - - - - - - - Appended by Scientific-Atlanta, Inc. - - - - - - - <B= R> This e-mail and any attachments may contain information which is confidenti= al, proprietary, privileged or otherwise protected by law. The information = is solely intended for the named addressee (or a person responsible for del= ivering it to the addressee). If you are not the intended recipient of this= message, you are not authorized to read, print, retain, copy or disseminat= e this message or any part of it. If you have received this e-mail in error= , please notify the sender immediately by return e-mail and delete it from = your computer.<BR> </FONT> </BODY> </HTML> ------_=_NextPart_001_01C3D52C.273B9780-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sands, Robyn INET: Robyn.Sands_at_sciatl.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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 also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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 also send the HELP command for other information (like subscribing).Received on Wed Jan 07 2004 - 09:54:50 CST
 |
 |