Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is there any way to disable oracle Multitenant feature

We are using Oracle docker image for Oracle database 12.2.

By default it seems the Multitenant feature is enabled.

Is there any way it can be disabled?

We have only one application to support and do not want to create pluggable database for that.

Any help greatly appreciated!

Thanks

like image 968
explorer Avatar asked Mar 12 '20 15:03

explorer


People also ask

What is Oracle Multitenant?

Oracle Multitenant enables an Oracle Database to function as a container database (CDB). A CDB consolidates multiple pluggable databases (PDB), a portable collection of schemas, schema objects, and non-schema objects.

Is Oracle Cloud Multitenant?

All Oracle databases from version 12.1 in the Oracle Cloud are automatically deployed using the Multitenant architecture.


1 Answers

Fair warning:

The non-CDB architecture is desupported starting in Oracle Database 20c.

You can use the CDB architecture with one user-created PDB without a Multitenant license. From Oracle Database 19c, this extended to three user-created PDBs in a CDB.

The short answer is there's no way to disable the CDB architecture.

To switch to it, you'll need to install a new non-CDB database. Then migrate the data from your existing database to it. For example with Data Pump export/import or some other data replication/migration tool.

like image 60
Chris Saxon Avatar answered Nov 15 '22 08:11

Chris Saxon