XDB. DBMS_XMLSCHEMA error reported during Oracle 11g upgrade to 11.2.0.3

Record:
Upgrade Oracle11g to version 11.2.0.3 and execute @? In the process of/rdbms/admin/catupgrd. SQL, the following error message is displayed:
ORA-00604: error occurred at recursive SQL level 1
ORA-01704: string literal too long
ORA-00932: inconsistent datatypes: expected XDB. XDB $ SCHEMA_T got
ORA-06512: at "XDB. DBMS_XMLSCHEMA_INT", line 173
ORA-06512: at "XDB. DBMS_XMLSCHEMA", line 231
ORA-06512: at line 288
ORA-00604: error occurred at recursive SQL level 1
ORA-00932: inconsistent datatypes: expected XDB. XDB $ SCHEMA_T got
ORA-06512: at "XDB. DBMS_XMLSCHEMA_INT", line 173
ORA-06512: at "XDB. DBMS_XMLSCHEMA", line 231
ORA-06512: at line 31

The error message above is related to upgrading the Oracle Multimedia component. According to Oracle, replace the SQL statement after the script and re-execute it. Therefore, if the Oracle Multimedia component is VALID after the upgrade, this error can be safely ignored.

After the upgrade, query the status of the Oracle Multimedia component:
SQL> conn/as sysdba
SQL> set serveroutput on
SQL> execute validate_ordim;

PL/SQL procedure successfully completed.

SQL> select comp_name, version, status from dba_registry where comp_id = 'ordim ';

COMP_NAME VERSION STATUS
----------------------------------------------------
Oracle Multimedia 11.2.0.3.0 VALID

The component Status is VALID, so the error can be ignored.

Revelation:
Create a database manually in the production environment and install the minimum and required components.
-- Reduces the chance of bugs and the execution time of upgrade scripts.

Recommended reading:

Oracle 10g 10.2.0.1 32-bit migration upgrade to 10g 10.2.0.5 64-bit

Oracle Upgrade (10.2.0.1-> 10.2.0.3)

Upgrade Oracle 10g rac to 10.2.0.5

Oracle 10g upgrade to 11g Training Project

RedHat 5.5 Oracle RAC database upgraded from 10.2.0.1 to 10.2.0.5