Re: Internal error after upgrade to 8.1.7.4

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Mon, 26 Apr 2004 15:39:58 GMT
Message-ID: <i3ajc.18933$en3.16920@edtnps89>

Gerold Krommer wrote:

> We are getting the following error when startin SQLPLUS after a 8.0.4 to
> 8.1.7.4 upgrade (HPUX). The application is running fine, though (quite
> surprisingly). Note that I did not do the upgrade, so I can't tell exactly
> what happened. But I guess when running the upgrade scripts some 'real
> errors' (as opposed to the many 'expected errors' ) were not caught.
>
> I'm looking for advice what the best way to proceed is or even if my
> suspicion is correct. Re-Run all scripts (catproc.sql, etc.) again or just
> some subset?
>

IMO, rerun all. Otherwise you will never be 100% sure whether anything else was missed ...

Was the DB originally created at 8.0 or upgraded from an older one? I've seen a number of 7.3 -> 8.0 -> 8.1 where the catproc in 8.0 never quite worked, causing results similar to yours. Rerunning catalog & catproc helped. Received on Mon Apr 26 2004 - 10:39:58 CDT