Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Patch fails with ORA-01502: index 'SYS.I_WRI$_OPTSTAT_TAB_OBJ#_ST'

edited Sep 24, 2014 1:27AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓

Hi All,

We applied patch and it failed at

Start date: Tue Aug 26 2014 10:54:18



0 "left over" javaupdates.txt files uploaded to DB: Tue Aug 26 2014 10:54:18

0 patches uploaded from the ADPSV format patch history files: Tue Aug 26 2014 10:54:18


Uploading information about files copied during the previous runs ...


Uploading "/d01/oracle/test/apps/apps_st/appl/admin/test/out/filescopied_21761.txt" ...


Start Processing Snapshot Info
  No of records processed =20
Gathering statistics for table 'AD_CHECK_FILE_TEMP'...


ORA-01502: index 'SYS.I_WRI$_OPTSTAT_TAB_OBJ#_ST' or partition of such index is in unusable state
ORA-06512: at "APPS.FND_STATS", line 2025
ORA-06512: at line 3

Error in AD_CHECK_FILE_TEMP.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center