upgrade from to gives 100s of invalid objects

  • From: Howard Latham <howard.latham@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 12 Jul 2011 12:06:58 +0100

Platform Redhat Linux

3 Databases on 1 box 2 dbs upgraded ok the other one very old - was once v7
has hundreds of invalid objects
and status of server component invalid.

Can't downgrade as the other 2 are ok.

I have logged an SR and we have tried uninstalling and reinstalling

Ideas seem to have run out.

I wonder wherher the 'inavalidity' Matters if all the queries we do work ok.

I also wonder whether I should just go ahead and upgrade to 11 which was why
we started upgrade in first place.

This DB is 500gigs of data.

Thoughts ?

Howard A. Latham

Sent from my Nokia N97

Other related posts: