ORA-29913: error in executing ODCIEXTTABLEOPEN callout after 19.7c DB Upgrade

Deepa Unni

Hi,

We recently upgraded from DB version - from 12.1.0.2 to 19.3 and tested everything perfect.

However based on the Interoperability recommendations we had to upgrade to 19.7 DB, to comply with our PSU/CPU patching. SO we rolled back .3 patches and installed .7 patches to bring the DB to 19.7

Since then we are encountering the below error while trying to load a external DB Table using Oracle data loader. The error details are as below:

ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-04063: ORA-04063: package body "SYS.KUPU$UTILITIES_INT" has errors

ORA-06508: PL/SQL: could not find program unit being called: "SYS.KUPU$UTILITIES_INT"

ORA-06512: at "SYS.KUPU$UTILITIES", line 85

ORA-06512: at line 1

has errors

Has anyone encountered this issue ? Any suggestions/recommendations are appreciated ..

Thanks

Deepa

2926792

select object_name,object_type,status,owner from dba_objects where owner='SYS' and status='INVALID';

 

select comp_name, version, status from dba_registry;

As considered,SYS.KUPU$UTILITIES_INT should be invalid.

connect / as sysdba;

 

SQL> set echo on

SQL> SPOOL /tmp/catalog.log

SQL> @catalog.sql <--------------$ORACLE_HOME/rdbms/admin

SQL> SPOOL off

SQL> SPOOL /tmp/catproc.log

SQL> @catproc.sql <--------------$ORACLE_HOME/rdbms/admin

SQL> SPOOL off

SQL> SPOOL /tmp/utlrp.log

SQL> @utlrp.sql <--------------$ORACLE_HOME/rdbms/admin

SQL> SPOOL off

 

Execute utlrp.sql script for multiple times like 5 times in 3 minute interval.

Wesley D-Oracle

The direct approach:

sqlplus / as sysdba

@?/rdbms/admin/prvthpui.plb

@?/rdbms/admin/prvtbpui.plb

alter package KUPW$WORKER compile body;

Confirm if "KUPU$UTILITIES_INT" has successfully validated.