My Oracle Support Banner

XDB invalid 12c with invalid XMLINDEXMETHODS, XMLIDXSTATSMETHODS, XMLINDEX_FUNCIMPL,XMLINDEX_NOOP and XMLINDEX (Doc ID 2386916.1)

Last updated on SEPTEMBER 15, 2022

Applies to:

Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database - Standard Edition - Version 12.1.0.2 to 19.16.0.0.0 [Release 12.1 to 19]
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

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.