What is Chopt?
The Oracle Change Options utility — Chopt — is a command-line tool that enables and disables Oracle database options. It is embedded in all current versions of Oracle Database, 12.2 and above, which means every customer already has it. It lets you see which options are switched on against a given database, and switch them off again.
The options Chopt manipulates include:
- Database Vault
- Oracle Label Security
- Oracle OLAP
- Oracle Partitioning
- Data Mining
- Oracle Real Application Testing
Why you need to know which options are enabled
Under Oracle licensing you pay for the database products and options you have installed, whether or not anyone in the organisation is using them. An option left on by accident is a real cost against a capability nobody asked for.
The risk compounds because of how Oracle behaves by default. Oracle’s own guidance is explicit: if you install or clone an Oracle Database image, all Oracle Database options are enabled by default. That is not an edge case — it is the normal outcome of a normal operation. Installations that do not complete cleanly leave the same residue. Every one of those chargeable options is visible to an auditor, and the responsibility for controlling them is yours.
How Chopt limits your compliance exposure
In practice, most customers do not run Chopt after an Oracle database installation, duplication or upgrade. Those are precisely the moments when options and packs get activated and left on.
Make Chopt a mandatory step in the change process for Oracle Database environments. For any change:
Before the change. If you are cloning or modifying an existing environment, run Chopt first and record which options and packs are enabled and which are disabled. That snapshot is your reference point.
After the change. Run Chopt again and compare. Whether the change was a clone, an upgrade or a rebuild, it is not unusual to find options newly activated that alter your compliance position.
Then remediate. Use Chopt to deactivate anything that was switched on and that you are not licensed to use.
The discipline is what matters here. A snapshot taken only after the fact tells you what is on; it does not tell you what changed, or which change turned it on.
Chopt is a useful check inside a change process. It is not a licensing position.
The utility runs against one database at a time. It has no view across an environment, no notion of entitlement, and nothing to compare deployment against. That makes it good at the point of change and useless for managing Oracle at scale.
Use Chopt to stop non-compliance at source, and a proper Oracle licence engine for the wider picture. What that engine has to handle is fairly specific, and it is worth testing candidates against it. CerteroX SAM covers:
- Options and packs with the supporting evidence for each detection, and the ability to override one when the evidence is wrong
- Processor types and core factors, so the licensable core count is calculated rather than estimated
- Licence pools with hosting rights and geographic rules
- Cover-down logic for Enterprise Edition, where a higher-edition pool covers lower-edition deployments
- Uncapped quantity handling for unlimited agreements
- E-Business Suite responsibilities
- Import of entitlement into a single record, so purchased, used, available, required and variance are computed rather than assembled by hand
- A continuous compliance position, trended over time, rather than a reconciliation you rerun when someone asks
Certero is also a verified third-party tool vendor with Oracle License Management Services. In Certero’s own published wording: being a verified third-party toolset means that Oracle’s audit team can accept data from Certero during an official audit, as an alternative to installing Oracle License Management measurement tools. That is a conditional rather than a guarantee, but it is a materially better starting position than arriving with spreadsheets.
The combination is what works. Chopt keeps a single change honest. The licence engine tells you what all those changes added up to.