My Oracle Support Banner

Upgrade errors ORA-40362: invalid object SYS.ODCIPARTINFOLIST specified in the statement, PLS-00905: object CTXSYS.TEXTINDEXMETHODS is invalid, ORA-04045: errors during recompilation/revalidation of XDB.XMLINDEX_NOOP (Doc ID 2681519.1)

Last updated on JULY 14, 2020

Applies to:

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

Symptoms

Errors are generated during database upgrade:

...

------------------------------------------------------
Identifier CATPROC 19-11-06 12:44:58
SCRIPT    = [/u01/app/oracle/product/18.8.0.0/dbhome_1/rdbms/admin/catodci.sql]
ERROR     = [ORA-40362: invalid object SYS.ODCIPARTINFOLIST specified in the statement]
STATEMENT = [GRANT EXECUTE ON ODCIPartInfoList TO PUBLIC]
------------------------------------------------------
------------------------------------------------------
Identifier CONTEXT 19-11-06 01:05:16
SCRIPT    = [/u01/app/oracle/product/18.8.0.0/dbhome_1/ctx/admin/t1202000.sql]
ERROR     = [ORA-06550: line 4, column 22: PLS-00905: object CTXSYS.TEXTINDEXMETHODS is invalid
ORA-06550: line 4, column 6:
PL/SQL: Statement ignored
]
STATEMENT = [alter indextype context using TextIndexMethods]
------------------------------------------------------

...

Oracle Server
  ORA-40362: invalid object SYS.ODCIPARTINFOLIST specified in the statement
Oracle Server                           INVALID      18.8.0.0.0  00:10:46
JServer JAVA Virtual Machine              VALID      18.8.0.0.0  00:04:32
...
Oracle Text
   ORA-06550: line 4, column 22:
   PLS-00905: object CTXSYS.TEXTINDEXMETHODS is invalid
   ORA-06550: line 4, column 6:
   PL/SQL: Statement ignored
   ORA-06552: PL/SQL: Declaration ignored
   ORA-06553: PLS-905: object CTXSYS.CTX_CONTAINS is invalid
   ...
   ORA-06552: PL/SQL: Declaration ignored
   ORA-06553: PLS-905: object CTXSYS.CTX_CONTAINS is invalid
Oracle Text                             INVALID      18.8.0.0.0  00:00:33
...
Oracle XML Database
   ORA-04045: errors during recompilation/revalidation of XDB.XMLINDEX_NOOP
   ORA-06552: PL/SQL: Declaration ignored
   ORA-06553: PLS-905: object XDB.XMLINDEX_FUNCIMPL is invalid
   ORA-06550: line 4, column 19:
   PLS-00905: object XDB.XMLINDEXMETHODS is invalid
   ORA-06550: line 4, column 6:
   PL/SQL: Statement ignored
   ORA-06550: line 4, column 19:
   PLS-00905: object XDB.XMLINDEXMETHODS is invalid
   ORA-06550: line 4, column 6:
   PL/SQL: Statement ignored
   ORA-04045: errors during recompilation/revalidation of XDB.XMLINDEX
   ORA-06552: PL/SQL: Declaration ignored
   ORA-06553: PLS-905: object XDB.XMLINDEX_FUNCIMPL is invalid
   ORA-06550: line 4, column 13:
   PLS-00999: implementation restriction (may be temporary) XDB.XMLIDXSTATSMETHODS
   must be valid before compiling
   ORA-06550: line 4, column 6:
   PL/SQL: Statement ignored
   ORA-06550: line 4, column 13:
   PLS-00999: implementation restriction (may be temporary) XDB.XMLIDXSTATSMETHODS
   must be valid before compiling
   ORA-06550: line 4, column 6:
   PL/SQL: Statement ignored
Oracle XML Database                     INVALID      18.8.0.0.0  00:01:20
Oracle Multimedia                      UPGRADED      18.8.0.0.0  00:01:11
Spatial
   ORA-04063: type body "MDSYS.SDO_INDEX_METHOD_10I" has errors
   ORA-06512: at line 17
   ORA-06508: PL/SQL: could not find program unit being called:
   "MDSYS.SDO_INDEX_METHOD_10I"
   ORA-06512: at line 4
   ORA-06512: at line 5
   ORA-04063: type body "MDSYS.SDO_INDEX_METHOD_10I" has errors
   ORA-06512: at line 17
   ORA-06508: PL/SQL: could not find program unit being called:
   "MDSYS.SDO_INDEX_METHOD_10I"
   ORA-06512: at line 4
   ORA-06512: at line 7
   ORA-04042: procedure, function, package, or package body does not exist
   ORA-01775: looping chain of synonyms
   ORA-29815: object being associated is not present
   ORA-06512: at line 20
   ORA-06512: at line 14
Spatial                                 INVALID      18.8.0.0.0  00:02:52


These result to invalid objects such as CTXSYS.TEXTINDEXMETHODS which fail to compile successfully post-upgrade.

Changes

 

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
References


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