Oracle database patching Datapath fails with ORA-04063
Problem
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-04063: ORA-04063: package body “SYS.KUPU$UTILITIES” has errors
ORA-06508: PL/SQL: could not find program unit being called:“SYS.KUPU$UTILITIES”
ORA-06512: at line 1
Solution
First, check database components that ALL of them are VALID and OK:
select * from dba_registry;
Running prvtsqlpatch.plb,prvthpui.plb,prvtbpui.plb to recreate dbms_sqlpatch package and checking status of this package;
@?/rdbms/admin/prvthpui.plb
@?/rdbms/admin/prvtbpui.plb
@?/rdbms/admin/prvtsqlpatch.plb
alter package KUPW$WORKER compile body;
Query using a the table again:
select * from opatch_xml_inv ;
select dbms_sqlpatch.verify_queryable_inventory from dual;
select object_name,STATUS from dba_objects where object_name=’KUPU$UTILITIES’;
[oracle@oracledbwr OPatch]$ ./datapatch -verbose
TESTING:oracle $ ./datapatch -verbose
SQL Patching tool version 19.3.0.0.0 Production on on Thu Jan 15 05:05:10 2025
Copyright (c) 2012, 2017, Oracle. All rights reserved.
Log file for this invocation: Log file for this invocation: /ora00/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_5382_2025_1_15_05_05_10/sqlpatch_invocation.log
Connecting to database…OK
Bootstrapping registry and package to current versions…done
Determining current state…done
Current state of SQL patches:
Bundle series DBRU:
ID 171017 in the binary registry and not installed in the SQL registry
Adding patches to installation queue and performing prereq checks…
Installation queue:
Nothing to roll back
The following patches will be applied:
36912597 (DATABASE RELEASE UPDATE 19.25.0.0.241015)
Installing patches…
Patch installation complete. Total patches installed: 1
Validating logfiles…
Patch 26710464 apply: SUCCESS
logfile: /ora00/app/oracle/cfgtoollogs/sqlpatch/36912597/36912597/36912597_apply_CONFDB_2025Jan15_05_05_18.log (no errors)
Connect with me on:-
Telegram App:https://t.me/oracledbwr
LinkedIn:https://www.linkedin.com/in/hariprasathdba
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page : https://www.facebook.com/dbahariprasath/?
Twitter : https://twitter.com/hariprasathdba
