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.
[EMAIL PROTECTED]
-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..
--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
Has anyone encountered the ORA-600[kcbnew_3] error after resizing and
LMT in
Oracle9i?
A vendor install script created tablespaces really large, and I
started to
resize them smaller, but checked Metalink. There is a bug 2747978
that says
in versions below 9.2.0.4 you can encounter an ORA-600 error after
resizing.
Oracle says they were able to reproduce it. The bug report says this
produces a severe loss of service. As a workaround it says to bounce
the
database after resizing.
I'm just trying to figure out how likely this error is to occur, so I
though
I'd ask if anyone has encountered this error. And if it occurred, how
severe
were the consequences? I can't apply the 9.2.0.4 patch because the
vendor
says they don't support that yet. Thanks.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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=3DContent-Type CONTENT=3Dtext/html; charset=3DUS-ASCII
META NAME=3DGenerator CONTENT=3DMS Exchange Server version 5.5.2655.35
TITLEFW: Error after resize of LMT/TITLE
/HEAD
BODY
PFONT SIZE=3D2We've seen this error on one of our databases (9.2.0.3 on=
Win2003 Server)./FONT
/P
PFONT SIZE=3D2Haven't seen it on our other instances (9.2.0.3 on HP-UX)=
./FONT
/P
PFONT SIZE=3D2Robyn/FONT
/P
PFONT SIZE=3D2-Original Message-/FONT
BRFONT SIZE=3D2From: Rachel Carmichael [A HREF=3Dmailto:[EMAIL PROTECTED]
ahoo.commailto:[EMAIL PROTECTED]/A] /FONT
BRFONT SIZE=3D2Sent: Tuesday, January 06, 2004 11:50 AM/FONT
BRFONT SIZE=3D2To: Multiple recipients of list ORACLE-L/FONT
BRFONT SIZE=3D2Subject: Re: Error after resize of LMT/FONT
/P
BR
PFONT SIZE=3D2I've done a LOT of resizing of LMT tablespaces (9.2.0.1) =
and have never/FONT
BRFONT SIZE=3D2gotten that error../FONT
/P
BR
PFONT SIZE=3D2--- DENNIS WILLIAMS lt;[EMAIL PROTECTED]gt; wrote=
:/FONT
BRFONT SIZE=3D2gt; Has anyone encountered
