Non-CDB architecture still exists in Oracle Database 12.2.

I received a question whether the Non-CDB architecture still exists in Oracle Database 12.2.from 3 different colleagues in the past week: “Does Oracle Database 12.2 still allow us to create non-CDB databases?” And as I get this question at every customer-facing workshop these days as well before being able to talk about Single/Multitenant – I think it is important to clarify it. The statement is misleading. And I can’t blame anybody about misreading it. Is the non-CDB architecture still available/supported in Oracle Database 12.2? I did blog about it a while ago – but Google is not always your friend…

Non-CDB architecture of Oracle databases is DEPRECATED since Oracle Database 12.1.0.2

Please find an updated blog post here: https://mikedietrichde.com/2015/09/04/oracle-non-cdb-architecture-may-be-desupported-after-oracle-database-12-2/ https://mikedietrichde.com/2017/03/14/non-cdb-still-exists-in-oracle-database-12-2-oracle-18-oracle-19/ as the text in the Database Upgrade Guide has been changed as well. See the Oracle Database 12.1.0.2 Upgrade Guide: https://docs.oracle.com/database/121/UPGRD/deprecated.htm#BABDBCJI — What does this mean? Deprecation first of all does not mean “desupported”. It means in this case that you of course can have still stand-alone Oracle databases as you know the architecture from previous releases. But you can also have a single-tenant deployment (a CDB with one PDB – no Multitenant license required) or multitenant databases (a CDB with up to 252 PDBs – Multitenant Option license required). But…