This manual is about removing a pluggable database from an existing container database. The multi-tenant option introduced in Oracle Database 12c can be a single container database ( CDB) to create multiple separate pluggable databases ( PDB). This pluggable database you can delete if you no longer need. In the Database Creation Assistant ( DBCA ) is a new option available. The ” Database Operation ‘ screen where the opportunity is offered to remove pluggable databases from an existing container database.
Prereq
- Installation of Oracle Enterprise Linux
- Installation of Oracle Database Server
Software
Inapplicable
Display
If you do not work directly from the console, you can start a terminal session to the server.
On the server, the display must be exported to the machine from where you will perform the installation.
1 2 3 4 |
prompt> su - oracle oracle> export DISPLAY=<local hostname>:0.0 oracle> export TMP=/var/tmp oracle> export TEMP=/var/tmp |
Remove pluggable database with DBCA
1 2 |
prompt> su - oracle oracle> ./dbca |
Vervolg
One Response to “Remove multitenant PDB Oracle Database 12c”
Amit
Question
Suppose, if You administer a three-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1, PDB_2, and PDB_3.
You want to drop PDB_3.
Manually created services for PDB_3 are not removed automatically from the OCR when
dropping PDB_3. is this true?
Please let me know.
Thanks,
Amit