At the moment I work with one of our reference customers, Swiss Mobiliar Insurance, on their Multitenant upgrade to Oracle Database 18.104.22.168. And we encountered an “interesting” issue. After upgrade we received an ORA-44787 making it impossible to switch between containers with “alter session set container=pdb1;” commands.… [Read More]
XDB Clean Up in Oracle Database 11.2-12.2 will apply to Oracle Database 11.2.0.x only as XDB became a mandatory component since Oracle Database 22.214.171.124. You can’t have an Oracle 12c database without XDB. Therefore the following blog post won’t explain how to clean up XDB from an Oracle 12c database.… [Read More]
JAVAVM and XML clean up in Oracle Database 11.2-12.2 is a tough topic. Many have suffered from the rolling patch upgrade issues with the OJVM (Oracle Java Virtual Machine) even though most of the issues have been cured with the recent patches.
Enterprise Manager (EM) clean up in Oracle Database 11.2-12.2 is targeting Enterprise Manager Database Control only. EM DB Control does not exist anymore since Oracle Database 12c and got replaced by EM Express, a light-weight EM.
Enterprise Manager (EM) Clean Up in Oracle Database 11.2-12.2
As Enterprise Manager Database Control gets replaced by EM Express since Oracle Database 126.96.36.199 its repository must be removed when upgrading to Oracle Database 12c or later.… [Read More]