Oracle XML Database Invalid After 19c
Problem Summary
—————————————————
Oracle XML Database invalid after 19c
Problem Description
—————————————————
COMP_NAME VERSION STATUS
———————————————— —————————— ———–
Oracle XML Database 19.0.0.0.0 INVALID
Oracle Real Application Clusters 19.0.0.0.0 OPTION OFF
Oracle Database Catalog Views 19.0.0.0.0 UPGRADED
Oracle Database Packages and Types 19.0.0.0.0 UPGRADED
4 rows selected.
18:28:05 SQL> select owner, object_name, object_type, status
from dba_objects
where status = ‘INVALID’ and owner=’SYS’
order by owner, object_name;18:28:34 2 18:28:34 3 18:28:34 4
OWNER OBJECT_NAME OBJECT_TYPE STATUS
——————————————————————————————————————————– ——————————————————————————————————————————– ———————– ——-
SYS PREVENT_REPLTABS_CHANGE_V4 TRIGGER INVALID
SYS X_$KGLCURSOR VIEW INVALID
2 rows selected.
Elapsed: 00:00:00.02
18:28:35 SQL>
CHANGES
CAUSE
XDB related package bodies and other objects where invalid
XDB related package bodies and other objects where invalid
XDB DBMS_CLOBUTIL PACKAGE BODY INVALID
XDB DBMS_CSX_ADMIN PACKAGE BODY INVALID
XDB DBMS_CSX_INT2 PACKAGE BODY INVALID
XDB DBMS_JSON PACKAGE BODY INVALID
XDB DBMS_JSON_INT PACKAGE INVALID
XDB DBMS_JSON_INT PACKAGE BODY INVALID
XDB DBMS_SODA_ADMIN PACKAGE BODY INVALID
XDB DBMS_SODA_DML PACKAGE INVALID
XDB DBMS_SODA_DML PACKAGE BODY INVALID
XDB DBMS_SODA_DOM PACKAGE BODY INVALID
XDB DBMS_SODA_USER_ADMIN PACKAGE BODY INVALID
XDB DBMS_SODA_USER_DML PACKAGE INVALID
XDB DBMS_SODA_USER_DML PACKAGE BODY INVALID
XDB DBMS_XDB PACKAGE BODY INVALID
XDB DBMS_XDBNFS PACKAGE BODY INVALID
XDB DBMS_XDBREPOS PACKAGE BODY INVALID
XDB DBMS_XDBRESOURCE PACKAGE BODY INVALID
XDB DBMS_XDBUTIL_INT PACKAGE BODY INVALID
XDB DBMS_XDBZ0 PACKAGE BODY INVALID
XDB DBMS_XDB_ADMIN PACKAGE BODY INVALID
XDB DBMS_XDB_CONFIG PACKAGE BODY INVALID
XDB DBMS_XDB_CONSTANTS PACKAGE BODY INVALID
XDB DBMS_XDB_CONTENT PACKAGE BODY INVALID
XDB DBMS_XDB_PRINT PACKAGE BODY INVALID
XDB DBMS_XDB_REPOS PACKAGE BODY INVALID
XDB DBMS_XEVENT PACKAGE BODY INVALID
XDB DBMS_XLSB PACKAGE BODY INVALID
XDB DBMS_XMLDOM PACKAGE BODY INVALID
XDB DBMS_XMLDOM_ICD PACKAGE INVALID
XDB DBMS_XMLINDEX PACKAGE BODY INVALID
XDB DBMS_XMLINDEX0 PACKAGE BODY INVALID
XDB DBMS_XMLPARSER PACKAGE BODY INVALID
XDB DBMS_XMLSCHEMA_ANNOTATE PACKAGE BODY INVALID
XDB DBMS_XMLSCHEMA_LSB PACKAGE BODY INVALID
XDB DBMS_XMLSTORAGE_MANAGE PACKAGE BODY INVALID
XDB DBMS_XMLTRANSLATIONS PACKAGE BODY INVALID
XDB DBMS_XSLPROCESSOR PACKAGE BODY INVALID
XDB DEPTH OPERATOR INVALID
XDB GET_XDB_TABLESPACE FUNCTION INVALID
XDB PATH OPERATOR INVALID
XDB PRVT_DBMS_MANAGE_XMLSTORAGE PACKAGE BODY INVALID
XDB UNDER_PATH_FUNC FUNCTION INVALID
XDB XDB_ANCOP PACKAGE BODY INVALID
XDB XDB_DLTRIG_PKG PACKAGE BODY INVALID
XDB XDB_PV_TRIG TRIGGER INVALID
XDB XDB_RVTRIG_PKG PACKAGE BODY INVALID
XDB XDB_RV_TRIG TRIGGER INVALID
.
SOLUTION
COMPILE the invalid procedures and other objects manually
STEP _ 1 :-
——————
conn / as sysdba
ALTER PACKAGE XDB.DBMS_CLOBUTIL COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_CSX_ADMIN COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_CSX_INT2 COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_JSON COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_JSON_INT COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_SODA_ADMIN COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_SODA_DML COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_SODA_DOM COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_SODA_USER_ADMIN COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_SODA_USER_DML COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XDB COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XDBNFS COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XDBREPOS COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XDBRESOURCE COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XDBUTIL_INT COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XDBZ0 COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XDB_ADMIN COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XDB_CONFIG COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XDB_CONSTANTS COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XDB_CONTENT COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XDB_PRINT COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XDB_REPOS COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XEVENT COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XLSB COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XMLDOM COMPILE BODY ;
ALTER PACKAGE XDB.XDB_RVTRIG_PKG COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XMLINDEX COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XMLINDEX0 COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XMLPARSER COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XMLSCHEMA_ANNOTATE COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XMLSCHEMA_LSB COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XMLSTORAGE_MANAGE COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XMLTRANSLATIONS COMPILE BODY ;
ALTER PACKAGE XDB.DBMS_XSLPROCESSOR COMPILE BODY ;
ALTER PACKAGE XDB.XDB_ANCOP COMPILE BODY ;
ALTER PACKAGE XDB.XDB_DLTRIG_PKG COMPILE BODY ;
ALTER PACKAGE XDB.PRVT_DBMS_MANAGE_XMLSTORAGE COMPILE BODY ;
ALTER FUNCTION XDB.UNDER_PATH_FUNC COMPILE;
ALTER TRIGGER XDB .XDB_PV_TRIG COMPILE;
ALTER TRIGGER XDB .XDB_RV_TRIG COMPILE;
ALTER PACKAGE XDB .DBMS_JSON_INT COMPILE;
ALTER PACKAGE XDB .DBMS_XMLDOM_ICD COMPILE;
ALTER PACKAGE XDB .DBMS_SODA_USER_DML COMPILE;
ALTER PACKAGE XDB .DBMS_SODA_DML COMPILE;
ALTER OPERATOR XDB .DEPTH COMPILE;
ALTER FUNCTION XDB .GET_XDB_TABLESPACE COMPILE;
ALTER OPERATOR XDB .PATH COMPILE;
STEP _ 2 :-
——————
conn / as sysdba
EXECUTE DBMS_REGXDB.VALIDATEXDB;
SHOW ERR;
select schema,comp_name,comp_id,version,status,procedure from dba_registry WHERE COMP_ID=’XDB’;
SQL> select comp_name, version, status
from dba_registry
order by status, comp_name;
2 3
COMP_NAME VERSION STATUS
————————————————————————————————————————————————————————————————————————————————————— —————————— ———–
Oracle Real Application Clusters 19.0.0.0.0 OPTION OFF
Oracle Database Catalog Views 19.0.0.0.0 UPGRADED
Oracle Database Packages and Types 19.0.0.0.0 UPGRADED
Oracle XML Database 19.0.0.0.0 VALID >>>>>>>>>>>>>>>>>>
WikiDBA 