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 -> ora-1555 not in alert log?

ora-1555 not in alert log?

From: Joel Garry <joel-garry_at_home.com>
Date: 1 Oct 2002 14:43:08 -0700
Message-ID: <91884734.0210011343.75046070@posting.google.com>


I have a client/server odbc application (packaged from a vendor, no source) which returned an 'ORA-01555: snapshot too old: rollback segment number 7 with name "RBS08" too small' error. However, that error is not in the alert log? I see log switches subsequent to that time. 8.1.7 on hp/ux, a well-tuned production instance that has no errors besides expected ones from the standby db being down. SMON left a trace file indicating it cleaned up after problem, taking 70 minutes to do so.

I can understand the ora 1555, as some unusual processing is taking place as I try do some ETL while others are doing big processing, but what concerns me is why the error is not in the alert log. Yes, I've triple-checked the dates and instances, it happened today on the instance whose alert log I looked at.

jg

--
@home is bogus, substitute @cox.net for email, though I'm a bit slow on
that these days.
"With Oracle9i you'll never see ORA-01555 again!" - New Features presenter
Received on Tue Oct 01 2002 - 16:43:08 CDT

Original text of this message

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