ORA-08103: Object No Longer Exists Error On Table AD_CHECK_FILE_TEMP While Applying Patch 5200052
Last updated on JUNE 27, 2016
Applies to:Oracle Application Install - Version 18.104.22.168 to 22.214.171.124 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 25-Jun-2013***
On R126.96.36.199, applying patch 520052 fails with the following error in the adpatch log file:
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
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
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
Million Knowledge Articles and hundreds of Community platforms