Database Administration (MOSC)

MOSC Banner

@utlu102s.sql results INVALID database status

edited Sep 2, 2009 6:18PM in Database Administration (MOSC) 7 commentsAnswered
  we used 10.2.0.4 oracle dbua utility to upgrade database, and some of db components are left INVALID.

how to make them compile.

SQL> @utlu102s.sql
.
Oracle Database 10.2 Upgrade Status Utility 09-02-2009 19:01:50
.
Component Status Version HH:MM:SS
Oracle Database Server INVALID 10.2.0.4.0 00:51:18
.
Total Upgrade Time: 00:53:20

PL/SQL procedure successfully completed.

SQL>


SQL> select owner, object_name, object_type, status from dba_objects where status <> 'VALID' and owner='SYS';

OWNER OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------------- -------------------
STATUS
-------
SYS DBMS_AQ_SYS_EXP_INTERNAL PACKAGE BODY
INVALID

SYS DBMS_AQ_IMPORT_INTERNAL PACKAGE BODY
INVALID

SYS DBMS_AQ_SYS_IMP_INTERNAL PACKAGE BODY

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center