ORA-08103: Object No Longer Exists Error On Table AD_CHECK_FILE_TEMP While Applying Patch 5200052

(Doc ID 1296769.1)

Last updated on JUNE 27, 2016

Applies to:

Oracle Application Install - Version to [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 25-Jun-2013***


On R11.5.10.2, applying patch 520052 fails with the following error in the adpatch log file:

Updating the checkfile repository if necessary...

Processing the last batch...: Sun Feb 13 2011 06:45:10
ORA-08103: object no longer exists
ORA-06512: at "SYS.DBMS_STATS", line 10502
ORA-06512: at "SYS.DBMS_STATS", line 10516
ORA-06512: at line 1

AutoPatch error:
Error while executing statement (Begin DBMS_STATS.Gather_Table_Stats ( Ownname => 'APPLSYS', Tabname => 'AD_CHECK_FILE_TEMP', Estimate_percent => 10 ); End;)
Error calling aiuoraRunStmt(cf_stat_sql).

Error calling adphistMaintainCFRepos().

You should check the file
for errors.

Although the error implies that the table does not exist, querying the table dba_objects, shows that table AD_CHECK_FILE_TEMP still exists, and in a valid status.

Also, using adodfcmp to compare the definition of the table against what is stored in the database shows that the table exists, and all of its columns exist, and in perfect state.

Steps To Reproduce
The steps for reproducing the issue are unknown.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms