ArcSDE for Oracle: The sdesetup command should ensure there are no invalid objects after the installation or upgrade completes. (Please see technical article 34771 for a suggested workaround.)
Use Oracle package or another tool to recompile packages bodies and functions. There are dependencies, so this must be done in the correct order. (Please see technical article 34771 for a suggested workaround.)