My Oracle Support Banner

INVALID Components : Oracle Text , Oracle Multimedia and Spatial in Data Dictionary (Doc ID 2969071.1)

Last updated on OCTOBER 06, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Oracle Text - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

While Patching, Below Components are noticed as INVALID-

VERSION                        STATUS
------------------------------ --------------------------------------------
Oracle Text
19.0.0.0.0                     INVALID

Oracle Multimedia
19.0.0.0.0                     INVALID

Spatial
19.0.0.0.0                     INVALID




Changes

 Below Objects are INVALID as per below query-

$ grep -irl "[INVALID]" /u01/app/oracle/cfgtoollogs/sqlpatch
CTXSYS                         PACKAGE BODY            DRIREPM
ORDSYS                         PACKAGE BODY            ORDPLSGWYUTIL
MDSYS                          PACKAGE BODY            SDO_OLS
SYSMAN                         PACKAGE BODY            COREID_INTG


Compiling them individually generates below errors -

SQL> alter package sysman.COREID_INTG compile body;

Warning: Package Body altered with compilation errors.

SQL> show err
Errors for PACKAGE BODY SYSMAN.COREID_INTG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
577/25   PL/SQL: Statement ignored
577/46   PLS-00201: identifier 'UTL_INADDR' must be declared
SQL>


SQL> alter package CTXSYS.DRIREPM compile body;

Warning: Package Body altered with compilation errors.

SQL> show err
Errors for PACKAGE BODY CTXSYS.DRIREPM:

LINE/COL ERROR
-------- -----------------------------------------------------------------
40/5     PL/SQL: Statement ignored
40/16    PLS-00201: identifier 'DBMS_XMLGEN' must be declared
SQL>


SQL> alter package MDSYS.SDO_OLS compile body;

Warning: Package Body altered with compilation errors.

SQL> show err
Errors for PACKAGE BODY MDSYS.SDO_OLS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
136/5    PL/SQL: Statement ignored
136/12   PLS-00201: identifier 'DBMS_XMLGEN' must be declared
SQL>


SQL> alter package ORDSYS.ORDPLSGWYUTIL compile body;

Warning: Package Body altered with compilation errors.

SQL> show err
Errors for PACKAGE BODY ORDSYS.ORDPLSGWYUTIL:

LINE/COL ERROR
-------- -----------------------------------------------------------------
45/5     PL/SQL: Statement ignored
45/26    PLS-00201: identifier 'OWA_UTIL' must be declared
90/3     PL/SQL: Statement ignored
90/3     PLS-00201: identifier 'OWA_UTIL' must be declared
91/3     PL/SQL: Statement ignored
91/3     PLS-00201: identifier 'OWA_UTIL' must be declared
98/3     PL/SQL: Statement ignored
99/14    PLS-00201: identifier 'OWA_UTIL' must be declared
SQL>

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.