Oracle OLAP (XOQ, APS, AMD) Clean Up in Oracle Database 11.2-12.2

Oracle OLAP (XOQ, APS, AMD) Clean Up in Oracle Database 11.2-12.2 requires recompilation and some workarounds in most releases. Nevertheless, I’m documenting the removal steps for all 3 OLAP parts: XOQ – OLAP API APS – OLAP Analytical Workspace AMD – OLAP Catalog Again, let me emphasize that none of these blog posts is meant to recommend the removal of any component. It is just meant to explain procedures and workarounds as I sometimes face the situation to remove a component from a database. Oracle OLAP (XOQ, APS, AMD) Clean Up in Oracle Database 11.2-12.2 Even though a lot of…

Remove components from Oracle’s kernel with chopt

I’ve had an interesting discussion today. Somebody removed OLAP with chopt – and got issues afterwards. My guess: chopt will only remove the binary option and is meant to be used before a database got created. But if you use it afterwards you’ll have to make sure to remove the dictionary components as well. A while back a blogged about chopt already: Removing Options from the Oracle Database kernel in 12c And there are some helpful Support Notes out there: MOS Note: 948061.1 How to Check and Enable/Disable Oracle Binary Options This note WILL NOT address product specific scripts that…