Re: invalid packages after upgrade to 8.1.7

Did you run the upgrade script? I don't see it mentioned here... that is, u0801060.sql? You can't upgrade just by running 'catalog, catproc, catrep, utlrp.' as you say... also, given the banner below, it looks like you've applied the 8.1.7.1 patch. Were there any errors in that process?

"Baton" <baton_at_dzik.pl> wrote in message news:9jl25i$mvq$1_at_sunsite.icm.edu.pl...
> Hi all !
>
> I just upgraded my 8.1.6 to 8.1.7 on Solaris. I upgreded manually running
> catalog, catproc, catrep, utlrp. Finally I have got >150 invalid packages:
> SVRMGR> select owner, object_name, object_type from dba_objects where
> status='INVALID';
> OWNER OBJECT_NAME
> OBJECT_TYPE
> ------------------------------ -------------------------------------------
 --
> ----------------------------------- ------------------
> SYSTEM DBMSOBJG
> PACKAGE
> SYSTEM DBMSOBJG
> PACKAGE BODY
> SYSTEM DBMSOBJG2
> PACKAGE
> SYSTEM DBMSOBJG2
> PACKAGE BODY
> SYSTEM DBMSOBJGWRAPPER
> PACKAGE BODY
> SYSTEM DBMS_ALERT
> PACKAGE BODY
> SYSTEM DBMS_AQ
> PACKAGE
> SYSTEM DBMS_AQ
> PACKAGE BODY
> SYSTEM DBMS_AQADM
> PACKAGE BODY
> SYSTEM DBMS_AQADM_SYS
> PACKAGE
> SYSTEM DBMS_AQADM_SYS
> PACKAGE BODY
> SYSTEM DBMS_AQIN
> PACKAGE
> SYSTEM DBMS_AQIN
> PACKAGE BODY
> [...]
>
> -------------------------
> My oracle version:
>
> PL-plastus:oracle:/export/home/oracle/MARCIN/DSS_UPGRADE_8.1.7>svrmgrl
>
> Oracle Server Manager Release 3.1.7.0.0 - Production
>
> Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
>
> Oracle8i Enterprise Edition Release 8.1.7.1.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.1.0 - Production
>
> ----------------------
> My OS version:
> uname -a
> SunOS plastus 5.6 Generic_105181-26 sun4u sparc SUNW,Ultra-Enterprise
>
> Can somebody tell me what I did wrong ?
>
> Thanx in advance
> Marcin.
>
>
Received on Tue Jul 24 2001 - 22:41:23 CDT