Re: Invalid Objects when Upgrading

From: <amerar_at_iwc.net>
Date: 14 Jun 2006 07:16:02 -0700
Message-ID: <1150294561.933474.245680@c74g2000cwc.googlegroups.com>

Laurenz Albe wrote:
> amerar_at_iwc.net <amerar_at_iwc.net> wrote:
> > We just (finally) applied patch 4163445, which is the 9.2.0.7 upgrade.
> > Upon completing the upgrade, a few SYS objects became invalid and do
> > not compile:
> >
> > DBMS_METADATA_UTIL
> > DBMS_METADATA
> > DBMS_LOGMNR_SESSION
> > DBMS_INTERNAL_LOGSTDBY
> > DBMS_EXPORT_EXTENSION
> >
> > Just wondering if these are serious, or worth our attention to fix
> > whatever the problems are......
>
> You can recompile the packages from sqlplus and type 'show error' to
> get the error messages. Maybe they help.
>
> Yours,
> Laurenz Albe

Did that on a few, check out these errors:

OWNER                          NAME                           TYPE
     SEQUENCE       LINE   POSITION
------------------------------ ------------------------------

------------ ---------- ---------- ---------- TEXT

---

SYS                            DBMS_INTERNAL_LOGSTDBY         PACKAGE
BODY          1       2663         40

PLS-00302: component 'REPLACE_DICTIONARY_BEGIN' must be declared

SYS                            DBMS_INTERNAL_LOGSTDBY         PACKAGE
BODY          2       2663          3

PL/SQL: Statement ignored

SYS                            DBMS_INTERNAL_LOGSTDBY         PACKAGE
BODY          3       2700         24

PLS-00302: component 'REPLACE_DICTIONARY_END' must be declared

I mean, what in the upgrade invalidated these objects?? These do not look like normal errors......... Received on Wed Jun 14 2006 - 09:16:02 CDT