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:
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 are required at the database
level for specific components to further complete the install/deinstall process. Please refer to the appropriate Oracle Component Guide or as a starting point - Note 472937.1 Information On Installed Database Components and Schemas
This applies especially to OLAP. When you remove it with chopt make sure you have removed all OLAP components from the database beforehand (AMD, APS, XOQ). Check COMP_ID in DBA_REGISTRY. And extra attention is required for CDBs as removing components afterwards from the dictionary may be not straight forward.
An interesting finding on the side for Oracle Database 12.2:
chopt can now remove the following options from the database kernel:
olap
oaa (Advanced Analytics - this is a new chopt option in 12.2)
partitioning
rat
Further Links and Information
- Oracle Database 19c – chopt command
- MOS Note: 948061.1 – How to Check and Enable/Disable Oracle Binary Options (does not cover 19c as of June 2020)
–Mike
This applies especially to OLAP. When you remove it with chopt make sure you have removed all OLAP components from the database beforehand (AMD, APS, XOQ). Check COMP_ID in DBA_REGISTRY. And extra attention is required for CDBs as removing components afterwards from the dictionary may be not straight forward.
Hi Mike,
Does chopt on 12.2 remove component from database side ?
Or just link with off flag the Oracle Binary?
BR,
Nope – chopt removes ONLY options from the kernel (aka binary) but never from the database itselves (aka DBA_REGISTRY).
Cheers
Mike
Hi Mike,
Cant find any update on how to enable/disable for 19c?
Note 948061.1 only covers up to 18C and only for a smaller subset of options
What is the supported method now for 19c (19.6 in my case) for disabling all the available options?
Thanks
Neil
Hi Neil,
https://docs.oracle.com/en/database/oracle/oracle-database/19/ssdbi/chopt-tool.html#GUID-057E4EFC-74ED-43B3-B03B-C83C5A5D3C7F
I’m adding the link to the blog post.
Cheers,
Mike