Advisor reviewing a licensing strategy document on a laptop
Oracle · 23ai Upgrade Licensing · Sub

Upgrading to Oracle 23ai: The License Review to Run Before You Migrate

The moment you upgrade from 19c to 23ai, several newly-default behaviors can quietly switch on licensable options and record usage Oracle reads in an audit. This is the pre-migration checklist that stops you inheriting exposure you never agreed to buy.

Contact Us Oracle Hub
500+Enterprise clients
$2B+Under advisory
Industry Recognized
500+ Enterprise Clients
$2B+ Under Advisory
11 Vendor Practices
100% Buyer Side Independent

The moment you upgrade from 19c to 23ai, several newly-default behaviors can quietly switch on licensable options and record usage Oracle reads in an audit. This is the pre-migration checklist that stops you inheriting exposure you never agreed to buy.

Why the upgrade itself is a licensing event

After 25 years negotiating Oracle contracts, I treat every version upgrade as a compliance event first and a technical project second. The 19c to 23ai migration is worse than most because it combines three things at once: a mandatory architecture change (CDB/PDB), a batch of features that ship enabled by default, and Oracle's own usage-recording machinery running in the background. None of that changes your entitlements. All of it changes what Oracle can point to when it audits you.

First, the naming. The product you knew as 23ai has been rebranded to 26ai (announced at Oracle AI World in October 2025, on-premises Enterprise Edition GA for Linux x86-64 in January 2026). Do not let the new label confuse your license position. The database banner reads 23.26.1 and it is a Release Update on the same 23.x code line, with (in Oracle's own words) no changes with respect to licensing. Whether your DBAs call it 23ai or 26ai, the license rules in this article apply identically. Our broader entitlement framework is in the Oracle Database 23ai licensing guide.

Second, list price. Nothing moved. Enterprise Edition remains $47,500 per Processor and $950 per Named User Plus (25 NUP minimum per processor), carried forward unchanged from 23c. EE runs roughly 2.7x the cost of SE2 on both metrics. So every option or pack that auto-enables during the upgrade lands against the most expensive line items Oracle sells. That is precisely why the pre-migration review pays for itself.

An upgrade does not add entitlements. It adds evidence. Your job before cutover is to make sure the evidence matches what you actually bought.

How default-on features become audit findings

Here is the mechanism most buyers miss. Oracle EE installs most options in a ready-to-use state. A hidden internal job updates a feature-usage view roughly once per week, and that view is the same one Oracle references in a formal audit. You do not have to install anything separately, and you do not have to intend to license anything. If a DBA touches a feature during migration, the view records it, and Oracle later reads that record as consumption.

The two most common silent findings are the Diagnostics Pack and the Tuning Pack. They price per Processor, they cover features DBAs use every single day (AWR, ADDM, SQL advisors), and they switch on without a separate install. In our audit-defense casework, in 4 out of 5 estates the packs had been used by accident through default DBA workflows, and the control parameter that gates access sat at its permissive default in roughly 80 to 90 percent of databases we swept. When we settled against narrow, evidenced scope rather than Oracle's opening position, we cut the proposed pack bill by a median of 18 to 28 percent. The related self-enabling pack risk is documented in our note on the Oracle Cloud Management Pack.

The scale of the trap is geometric, not linear. One AWR report on a sixteen-Processor cluster can imply sixteen Processor licenses for each pack. At EE-class option pricing, a single careless report during a migration weekend can generate a six-figure claim. And drift compounds silently between manual script runs: a DBA enables Advanced Compression for a one-time migration task, the quarterly audit script does not catch it until next quarter, and by then Oracle considers it in use.

The pre-migration checklist unique to 23ai

This is the sequence we run for clients before any 19c to 23ai cutover. Do it while you still control the environment and before Oracle's usage view has anything new to record.

  • Set control_management_pack_access to NONE across the entire estate before you migrate. This is the single highest-value move. It blocks Diagnostics Pack and Tuning Pack access at the database level. Oracle exposes this exact toggle for organizations with no pack entitlement.
  • Restrict Enterprise Manager to servers you have deliberately licensed, and license the advisory packs only on the named servers where those features are genuinely required.
  • Confirm your CDB/PDB target design keeps each container at three PDBs or fewer unless you hold Multitenant. The fourth PDB is the classic trap and the forced CDB architecture makes it easy to trip.
  • Inventory every tablespace default before conversion so no tablespace is set to compress new objects with Advanced Compression by default.
  • Baseline your TDE configuration, because the 26ai encryption defaults changed and Advanced Security is a licensable option except where TDE-only rights apply.
  • Run a usage sweep and separate real, licensable usage from non-licensable and spurious entries before Oracle ever sees the data.

That last point matters more than most teams appreciate. Standard queries tell you whether a feature has been used but not whether it requires a license. The feature-usage table includes entries for non-licensable features and spurious uses that can legitimately be removed from audit findings. Running the raw script and handing the output to Oracle is a rookie error. Interpret first.

The five 23ai defaults to validate line by line

These are the specific default behaviors that changed or that become easy to trip in a 23ai environment. Each one maps to a licensable option or a paid pack.

Default behavior in 23ai/26ai What it can auto-enable List price exposure Pre-migration action
Diagnostics and Tuning Pack access left at permissive defaultDiagnostics Pack, Tuning Pack (per Processor)$47,500 EE per Processor plus per-pack Processor fees, multiplied by every coreSet control_management_pack_access to NONE; restrict EM
Advanced Compression set as a tablespace or table default (ROW STORE COMPRESS ADVANCED)Advanced Compression optionPer-Processor option fee on every server where new compressed objects are createdAudit tablespace defaults; disable default compression before conversion
Fourth PDB created during CDB/PDB conversionMultitenant optionPer-Processor Multitenant fee across the CDB hostCap at three PDBs per CDB unless Multitenant is licensed
TDE default algorithm now AES256, column mode GCM, tablespace mode XTS (changed in 26ai)Advanced Security (TDE beyond TDE-only rights)Per-Processor Advanced Security feeBaseline TDE config; confirm whether TDE-only rights cover your usage
Standby or replication features enabled during migrationActive Data Guard and related options$11,500 per Processor for Active Data Guard, plus standby server licensingVerify standby servers are fully licensed before enabling

The standby line deserves emphasis because migrations routinely spin up temporary standby or replication topologies. Standby servers need full licensing, and Active Data Guard is a paid EE option. We cover the mechanics and the buyer moves in our note on Oracle Active Data Guard licensing. Treat any migration-window replication as a licensed activity, not a free convenience.

The fourth PDB, the default-compressed tablespace, and the stray AWR report are not exotic. They are Tuesday. That is exactly why they end up in audit findings.

What 23ai actually includes, so you do not over-buy

The review cuts both ways. Some 23ai features that sound premium are genuinely included in EE and SE2 at no extra option cost, and you should not let a nervous project team buy options they do not need. AI Vector Search is included as standard, along with Select AI and Wide Tables (up to 4,096 columns per table). We break down where the AI billing line actually sits in the pillar on 23ai Vector Search and AI feature licensing, and specifically whether vector search is bundled in our piece on whether 23ai AI Vector Search is included in Enterprise Edition or an extra.

Where the line gets murkier is in-database machine learning, which touches the Advanced Analytics conversation. Before you scope any ML workload into the migration, read our analysis of the 23ai in-database machine learning license question. Two more features that generate confusion in migration planning are True Cache and JSON Relational Duality; we address whether True Cache is a free feature or effectively a second licensed database in 23ai True Cache licensing, and whether the new duality views change your footprint in JSON Relational Duality and license scope.

One caveat for teams evaluating the free edition as a staging or dev target: AI Database Free does not include Advanced Compression, Storage Snapshot Optimization, Optimization for Flashback Time Travel History Tables, or Automatic Data Optimization, and several options are now marked as available only in OCI. Do not use the free edition as a proxy for what your paid production entitlements cover. The feature line is different.

Sequencing the review against your renewal and audit posture

Timing is leverage. Run the license review at least twelve months before your support renewal, not the week before cutover. That gives you time to remediate defaults, retire genuine shelfware, and rebalance editions before Oracle has any migration usage to point at. The same footprint discipline we recommend for renewals applies here; see optimizing your Oracle license footprint before renewal. If your organization is also moving workloads to public cloud during the upgrade, the BYOL and vCPU mechanics in Oracle Database licensing on AWS will change the per-Processor math again, so model both moves together rather than sequentially.

The buyer-side discipline is simple to state and hard to execute: never let Oracle's usage view become the first version of your compliance truth. Build your own baseline, disable the options you have not bought, cap the PDB count, and interpret the raw usage data before it leaves your environment. Do that, and the 23ai upgrade is what it should be, a technical project. Skip it, and the upgrade becomes the opening exhibit in an audit you did not schedule.

The three moves to make this week

  • Push control_management_pack_access to NONE on every database that lacks pack entitlement, and record the change with a timestamp.
  • Freeze the migration runbook and add a licensing sign-off gate before any standby, compression, or fourth-PDB action is permitted.
  • Commission an independent usage sweep and interpretation so you know your real exposure before Oracle does, and so you can strip spurious entries from any future audit finding.

Frequently asked questions

Does upgrading from 19c to 23ai (26ai) change my license entitlements?

No. The upgrade does not add or remove any entitlement, and Oracle confirms the 23ai to 26ai transition carries no licensing change. What the upgrade changes is what Oracle can observe. Newly-default features and the mandatory CDB/PDB architecture make it easy to trigger usage of licensable options that Oracle records in the same view it reads during an audit.

Which single control stops the most exposure before migration?

Setting control_management_pack_access to NONE across every database that lacks Diagnostics Pack or Tuning Pack entitlement. These two packs are the most common silent audit findings, they switch on without a separate install, and one AWR report on a sixteen-Processor cluster can imply sixteen Processor licenses per pack. Set the parameter and restrict Enterprise Manager before you migrate.

Is the fourth PDB still a paid trap in 23ai?

Yes. Oracle 19c and later allow up to three PDBs per CDB without a Multitenant license; a fourth PDB triggers the paid Multitenant option. Because 23ai forces the CDB/PDB architecture, it is very easy to create a fourth container during conversion and trip the option unintentionally. Cap each CDB at three PDBs unless you hold Multitenant.

Are the AI features in 23ai a hidden extra cost?

AI Vector Search, Select AI, and Wide Tables are included in Enterprise Edition and SE2 at no extra option cost. In-database machine learning, True Cache, and JSON Relational Duality require closer scrutiny because they can touch other licensed options or components. Confirm each feature against your entitlements before scoping it into the migration, and do not over-buy on the assumption that everything AI-branded is chargeable.

Did TDE encryption defaults change in 26ai, and does that affect licensing?

Yes. The default algorithm for both TDE column and tablespace encryption is now AES256, column mode moved to GCM, and tablespace encryption defaults to the new XTS mode. TDE is part of Advanced Security, a licensable option except where TDE-only rights apply. Baseline your TDE configuration before migrating and confirm whether your rights cover the new defaults.

When should we run the license review relative to cutover?

At least twelve months before your next support renewal, and well before the migration weekend. Running it early lets you disable default-on options, cap PDB counts, retire shelfware, and interpret raw usage data before Oracle has any post-upgrade consumption to point at. Reviewing after cutover means negotiating from a position where Oracle already holds the evidence.

Free White Paper

Oracle Cloud at Customer Licensing. The buyer side framework.

Oracle Cloud at Customer enterprise licensing framework. Buyer side framework across OCI Dedicated Region, Exadata Cloud at Customer, autonomous database.

Gated with a work email on the download page. No sales follow up you did not ask for.

Get the White Paper →
Independent, buyer side. We never share your details with vendors.
Run a software spend health check against your Oracle estate in under five minutes.
Open the Tool →
Deep Library

More on this topic.

Oracle Hub →
Oracle Database 23ai Vector Search and AI Feature Licensing: What Actually Triggers a Bill
Oracle · Guide
Oracle Database 23ai Vector Search and AI Feature Licensing: What Actually Triggers a Bill
The full guide this article belongs to.
Guide
Is Oracle 23ai AI Vector Search Included in Enterprise Edition or an Extra?
Oracle · Deep dive
Is Oracle 23ai AI Vector Search Included in Enterprise Edition or an Extra?
Another angle on the same decision.
Guide
Oracle 23ai In-Database Machine Learning: The Advanced Analytics License Question
Oracle · Deep dive
Oracle 23ai In-Database Machine Learning: The Advanced Analytics License Question
Another angle on the same decision.
Guide
Oracle Cloud at Customer, ten steps, two license traps.
Oracle
Oracle Cloud at Customer, ten steps, two license traps.
Migrating to Oracle Cloud at Customer takes ten steps, from entitlement baseline to cutove
Guide
Oracle Licensing in M and A. The CIO due diligence checklist.
Oracle
Oracle Licensing in M and A. The CIO due diligence checklist.
CIO checklist for Oracle licensing in M and A. 7 step pre close diligence, assignment clau
Guide
The Microsoft license usage review. Audit yourself before they do.
Oracle
The Microsoft license usage review. Audit yourself before they do.
Run a Microsoft license usage review before renewal. Pull activity data, find inactive sea
Guide
Editorial boardroom interior

The advisor your vendors do not want.

500+ enterprise clients. 11 vendor practices. Industry recognized. One conversation can change what you pay for the next three years.

Stay ahead of Oracle licensing changes.

One buyer side briefing a week. Renewal signals, audit moves, and the levers that work. No vendor spin.