Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Error in catupgrd From 9.2.0.8 to 11.2.0.4 in AIX 7.1

edited Sep 13, 2018 12:03PM in Database Install/Upgrade/Opatch (MOSC) 1 commentAnswered ✓

Hello

When running catupgrd.sql   one step says:

......

- we also need to update the statistic

begin

   dbms_stats.delete_table_stats('SYS', 'OBJ$MIG');

   dbms_stats.delete_table_stats('SYS', 'USER$MIG');

   dbms_Stats.gather_table_stats('SYS', ' ',  estimate_percent => 100,method_opt=>'FOR ALL COLUMNS SIZE SKEWONLY');

   dbms_Stats.gather_table_stats('SYS', 'USER$MIG', estimate_percent => 100,method_opt=>'FOR ALL COLUMNS SIZE SKEWONLY');

end;

/

ERROR at line 1:

ORA-01114: IO error writing block to file  (block # )

ORA-06512: at "SYS.DBMS_STATS", line 24281

ORA-06512: at "SYS.DBMS_STATS", line 24332

ORA-06512: at line 4

But running  only for this one is fine: USER$MIG

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