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 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 25-Jun-2013***

Symptoms

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
/export/home/dev/d01/oratst/testappl/admin/CORETEST/log/u5200052.log
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.

Cause

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