INVALID Components : Oracle Text , Oracle Multimedia and Spatial in Data Dictionary
(Doc ID 2969071.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterOracle 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
------------------------------ --------------------------------------------
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
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>
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 |