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 18.104.22.168. 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.
Please see my previous blog posts starting here:
- The OJVM Saga – and how to solve it (Part 1) – Sep 5, 2016
- OJVM and Standby-First Patching – Aug 8, 2016
- OJVM Removal – Jun 22, 2015
And please see also this very important MOS Note: 2217053.1 – RAC Rolling Install Process for the “Oracle JavaVM Component Database PSU” (OJVM PSU) Patches explaining the improved process for OJVM patching avoiding downtime in many cases.… [Read More]
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
Oracle Expression Filter and Rules Manager (EXF, RUL) clean up in Oracle Database 11.2-12.2 is very simple and straight forward. One script, and several seconds later EXF and RUL are cleaned up. Both options require JAVA to be installed into the database. But their removal doesn’t do anything to JAVA.
Expression Filter and Rules Manager (EXF, RUL) Clean Up in Oracle Database 11.2-12.2
Expression Filter and Rules Manager are obsolete since Oracle Database 12c.… [Read More]
Oracle Warehouse Builder (OWB) clean up in Oracle Database 11.2-12.2 is very simple and straight forward. There’s only one script to execute. And it completes flawless and does not require any workarounds.
Oracle Warehouse Builder (OWB) Clean Up in Oracle Database 11.2-12.2
The Oracle Warehouse Builder actually does come automatically installed until Oracle Database 11.2.… [Read More]
Oracle Multimedia (ORDIM) clean up in Oracle Database 11.2-12.2 is not complicated especially as the removal script checks for the usage of the option first.
Oracle Multimedia (ORDIM) Clean Up in Oracle Database 11.2-12.2
Please be aware that Oracle Spatial (SDO) depends on Oracle Multimedia. Therefore, when you remove Oracle Multimedia then Oracle Spatial will be removed as well.… [Read More]
Oracle Text (CONTEXT) clean up in Oracle Database 11.2-12.2 is an interesting topic. A removal script exists but some additional tasks may be necessary depending on the database release.
Oracle Text (CONTEXT) Clean Up in Oracle Database 11.2-12.2
Oracle Text (formerly known as Context Option) is a excellent feature a lot of people using actively.… [Read More]