Update Readiness Tool fails with error 'ORA-04063: package body "SYS.DBMS_SQLTUNE_INTERNAL" has errors'
search cancel

Update Readiness Tool fails with error 'ORA-04063: package body "SYS.DBMS_SQLTUNE_INTERNAL" has errors'

book

Article ID: 385008

calendar_today

Updated On:

Products

Data Loss Prevention Endpoint Prevent

Issue/Introduction

Running Update Readiness Tool (URT) prior to upgrade, may fail on Index Definition Validation with errors.

Example errors from URT log:

DECLARE
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_SQLTUNE_INTERNAL" has errors
ORA-06512: at "SYS.DBMS_STATS", line 40751
ORA-06512: at "SYS.DBMS_STATS", line 40035
ORA-06512: at "SYS.DBMS_STATS", line 38912
ORA-06512: at "SYS.DBMS_STATS", line 37089
ORA-06512: at "SYS.DBMS_STATS", line 34971
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SQLTUNE_INTERNAL"
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 11319
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 11428
ORA-06512: at "SYS.DBMS_STATS", line 34937
ORA-06512: at "SYS.DBMS_STATS", line 36653
ORA-06512: at "SYS.DBMS_STATS", line 38738
ORA-06512: at "SYS.DBMS_STATS", line 39738
ORA-06512: at "SYS.DBMS_STATS", line 40183
ORA-06512: at "SYS.DBMS_STATS", line 40732
ORA-06512: at "PROTECT.DSH_OBJECTS_VALIDATION", line 1899
ORA-06512: at line 11errors:

Cause

Bad/Corrupt Oracle Packages

Resolution

For Oracle Enterprise customers, contact your DBA to have them repair the packages.

If Oracle Standard was purchased through Broadcom, or a partner, please contact your DLP Technical Support team for further assistance.