Forum Stats

  • 3,874,121 Users
  • 2,266,687 Discussions
  • 7,911,730 Comments

Discussions

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

Deepa Unni
Deepa Unni Member Posts: 46
edited Sep 21, 2020 9:32PM in Database Upgrade

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

Answers

  • 2926792
    2926792 Member Posts: 1
    edited Sep 21, 2020 9:32PM

    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
    Wesley D-Oracle Posts: 193 Employee
    edited Oct 5, 2020 12:32AM

    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.

    User_6UV0X