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 -> invalid packages after upgrade to 8.1.7

invalid packages after upgrade to 8.1.7

From: Baton <baton_at_dzik.pl>
Date: Wed, 25 Jul 2001 01:59:54 +0200
Message-ID: <9jl25i$mvq$1@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 - 18:59:54 CDT

Original text of this message

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