DB Upgrade Command Failed While Upgrading (PDB) To 19.11
(Doc ID 2808274.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.0.0.0 and laterInformation in this document applies to any platform.
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
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 |
References |