Do not forget to execute catsbp.sql after oracle upgrade
I still see some people forget to execute catsbp.sql after upgrade database. In the SBP installation guide (readme file), it has below content:
The point 5 lets us know we do not need to execute 6, 7 during upgrade, but the guide does not mention whether we should do this after upgrade. After testing upgrading from 10g to 11g again, we definitely need to run catsbp.sql after upgrade! If we do not run this script, the oracle internal dictionary is not updated. For example, we cannot query SBP information from dba_registry_history.
So by following the oracle upgrade guide and SBP readme file, below should be the right steps:
1. install oracle software only
2. install SBP by referring the readme file (note: it tells us we don’t need to execute catsbp.sql in this phase)
4. database upgrade post actions
5. back to SBP readme file and run catsbp.sql, utlrp.sql for target instance.