458370.1: After Upgrade To Db 10.2.0.3, several Ctxsys Procedures/Packages ('WWSBR%) Are Invalid
380480.1: Invalid Objects After Upgrading Database From 220.127.116.11 To 10.2.0.2
386746.1: PORTAL Synonyms are Invalid After RDBMS Upgrade 9i to 10g
However, we had 250 invalids which were public synonyms referring to OLAPSYS, AMD and ODM. alter synonym
1. In 2004, this instance was upgraded from 11.5.8 to 18.104.22.168 and DB upgraded from 8i to 9i. The components of OLAPSYS, AMD, and ODM which come preinstalled in a fresh 22.214.171.124 installation, were not installed separately during this upgrade. Hence these schemas were missing which resulted in invalid synonyms.
2. When we upgraded 9207 to 10203, it upgraded only the components which were present in 9207. It did not install OLAPSYS, AMD and ODM.
We followed some metalink notes to create the schemas for OLAPSYS, AMD and ODM.
420791.1 How To Manually Install Data Mining
296187.1 How To Manually Install Oracle OLAP into a 9i or 10g Database After the DB Has Been Created
Once we followed the steps in these notes, the OLAPSYS, AMD and ODM schemas were created and the 250 invalid synonyms became valid.