:

ORA-31154 Invalid XML Document

The Problem

During an 11g DB upgrade I got this error:

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-31154: invalid XML document
ORA-19202: Error occurred in XML processing
LSX-00020: unknown type “string”
ORA-06512: at “XDB.DBMS_XDB”, line 528
ORA-06512: at line 55

The Cause

Not quite sure…

The Solution

Use Metalink note 556610.1 to download script dbupgdiag.sql. If the results of running this script show no problems, then your DB is OK.

This was confirmed to me by Oracle support after raising an SR with them.

If, however, the health check script dbupgdiag.sql script returns rows you should investigate them in more detail.

Like it, share it...

Category: 11g


Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *