DB Upgrade Command Failed While Upgrading (PDB) To 19.11 (Doc ID 2808274.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

DBUpgrade command failed while upgrading 18.12 PDB to 19.11 and below are the errors
*** WARNING: ERRORS FOUND DURING UPGRADE ***
 1. Evaluate the errors found in the upgrade logs
  and determine the proper action.
 2. Rerun the upgrade when the problem is resolved
REASON:
  ERRORS FOUND: During Upgrade
  FILENAME: /home/oracle/N0123355_logs/catupgrdn01233550.log AT LINE NUMBER: 1173849
------------------------------------------------------
Identifier XDB 21-06-24 10:17:30
SCRIPT = [/u02/app/oracle/product/19.0.0.0/dbhome_7/rdbms/admin/catxdbdl.sql]
ERROR = [ORA-22288: file or LOB operation FILEOPEN failed No such file or directory
ORA-06512: at "SYS.DBMS_LOB", line 822
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 131
ORA-06512: at line 16
]
STATEMENT = [declare
  c number;
  schema_exists EXCEPTION;
  PRAGMA EXCEPTION_INIT(schema_exists,-31085);
  XINCLUDEXSD BFILE := dbms_metadata_hack.get_bfile('xinclude.xsd.12.1');
  CSX_XINCLUDEURL VARCHAR2(2000) := 'http://www.w3.org/2001/csx.XInclude.xsd';
begin
select count(*) into c
from resource_view
where equals_path(RES, '/sys/schemas/PUBLIC/www.w3.org/2001/csx.XInclude.xsd')=1;
dbms_metadata_hack.cre_dir();
if c = 0 then
  xdb.dbms_xmlschema.registerSchema(CSX_XINCLUDEURL, XINCLUDEXSD, FALSE, FALSE, FALSE, FALSE, FALSE, 'XDB', options=>DBMS_XMLSCHEMA.REGISTER_BINARYXML);
end if;
exception
  when schema_exists then
  NULL;
end;]
------------------------------------------------------
------------------------------------------------------
Identifier XDB 21-06-24 10:17:30
SCRIPT = [/u02/app/oracle/product/19.0.0.0/dbhome_7/rdbms/admin/catxdbdl.sql]
ERROR = [No such file or directory ORA-06512: at "SYS.DBMS_LOB", line 822
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 131
ORA-06512: at line 16]

Changes

 Upgrade

Cause

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