XDB invalid 12c with invalid XMLINDEXMETHODS, XMLIDXSTATSMETHODS, XMLINDEX_FUNCIMPL,XMLINDEX_NOOP and XMLINDEX

(Doc ID 2386916.1)

Last updated on APRIL 16, 2018

Applies to:

Oracle Database - Standard Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

db version:12.1.0.2
OS;Linux x86-64


XDB Oracle XML Database INVALID 12.2.0.1.0

 

Changes

Upgrading the db showing the errors below

ORA-04045: errors during recompilation/revalidation of XDB.XMLINDEX_NOOP ORA
-06552: PL/SQL: Declaration ignored
ORA-06553: PLS-905: object XDB.XMLINDEX_FUNC
IMPL is invalid

ORA-06552: PL/SQL: Declaration ignored ORA-06553: PLS-905: object XDB.XMLIND
EX_FUNCIMPL is invalid

ORA-06553: PLS-905: object XDB.XMLINDEX_FUNCIMPL is invalid
ORA-06550: line 4, column 19: PLS-00905: object XDB.XMLINDEXMETHODS is inval
id
ORA-06550: line 4, column 6:
PL/SQL: Statement ignored

PLS-00905: object XDB.XMLINDEXMETHODS is invalid ORA-06550: line 4, column 6
:
PL/SQL: Statement ignored

ORA-06550: line 4, column 6: PL/SQL: Statement ignored

PL/SQL: Statement ignored
ORA-06550: line 4, column 19: PLS-00905: object XDB.XMLINDEXMETHODS is inval
id
ORA-06550: line 4, column 6:
PL/SQL: Statement ignored

PLS-00905: object XDB.XMLINDEXMETHODS is invalid ORA-06550: line 4, column 6
:
PL/SQL: Statement ignored

ORA-06550: line 4, column 6: PL/SQL: Statement ignored

PL/SQL: Statement ignored
ORA-04045: errors during recompilation/revalidation of XDB.XMLINDEX ORA-0655
2: PL/SQL: Declaration ignored
ORA-06553: PLS-905: object XDB.XMLINDEX_FUNCIMPL
is invalid

ORA-06552: PL/SQL: Declaration ignored ORA-06553: PLS-905: object XDB.XMLIND
EX_FUNCIMPL is invalid

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms