• Database Blog
  • GoldenGate 12c
    • Top 50 Oracle Goldengate Interview Questions To Get the Job!
  • Master Oracle 12c DBA
  • Oracle Tutorials
    • Oracle Tips & Tricks
    • Oracle VirtualBox
  • Learn Excel

VitalSoftTech

Database Administration | Oracle | Oracle Training | DBA Support | Oracle 12c DBA | GoldenGate | GoldenGate 12c | DBA Interview Questions | Goldengate Interview Questions | Natik Ameen

  • Digital Marketing
  • Blogging Tutorial and Tips
  • Cool Names
  •   Login
« Previous Post
Next Post »

Oracle 12c Database: Managing PDBs using Database Configuration Assistant

March 9, 2014 by Natik Ameen   /  1Z0-060, Multitenant, Oracle 12c, OraFAQ, ToadWorld

In 12c, the database configuration assistant can also be used to manage the PDB’s alongside the CDB and non-CDB databases. In this article we will look at managing the PDBs, using the database configuration assistant.


Related Articles
• SGA Instance Parameters in CDB and PDB
• Managing CDB and PDB tablespaces
• Flashback a CDB Database
• Managing Common and Local Users, Roles and Privileges for CDB and PDB
• Create 12c CDB PDB Using OUI

Managing PDBs

When you launch DBCA, you will see a new option “Manage Pluggable Databases”, as shown below.

Manage PDB

The new Manage Pluggable databases option can be used to manage the PDBs inside the different CDBs. The following sections demonstrate the different options available in DBCA, with respect to PDB management.

Create PDB Database

You can create a new PDB by clicking Next once the Manage Pluggable Databases option is selected in the DBCA. The following screens will guide you through the process of creating a new PDB database.

Create PDB 1


Choose the Create option and click Next.

Create PDB 2


Choose the CDB container for which the new PDB database should be part of. You will also have to provide the SYSDBA credentials for the CDB chosen. Then click on Next.

Create PDB 3


You can create a new database from scratch or you can create a database as a clone of some other PDB, for which you either have an archive or you unplugged earlier. So effectively, this option allows you to clone a PDB. We will create a new database. Click on Next.

Create PDB 4


Specify the name of the PDB database, the file location and the admin username and password for it. You can also optionally configure the Vault and Label security if you want to. Click Next.

Create PDB 5


Review the summary screen and Click Finish once you are OK with it.

Create PDB 6


The new PDB has been created.

Unplug the PDB Database

The DBCA can also be used to unplug a PDB from a CDB container. This is required if you want to migrate the PDB database from the current CDB container to some other or you want to clone it.

Unplug PDB 1


Select the “Unplug a database” option and then click on Next.

Unplug PDB 2


Select the CDB of which the PDB is currently part of. Provide the SYSDBA credentials and click on Next.

Unplug PDB 3


Select the PDB that you want to unplug. You can generate an archive of the PDB or you can generate an XML manifest file along with the database backup. Both will ensure that PDB can be attached later on. Provide the location where you want to store these files. Click on Next.

Unplug PDB 4


Review the summary screen and Click on Finish to start the unplugging process.

Unplug PDB 5


The PDB has been unplugged and as a result would have been deleted from its current CDB.

Delete the PDB Database

You can delete a PDB as well using the DBCA. The following screens will show you how.

Delete PDB 1


Select the delete option and click on Next.

Delete PDB 2


Select the CDB of which the target PDB is part of. Provide the SYS username and password and then click on Next.

Delete PDB 3


Select the PDB that you wish to remove. Click on Next.

Delete PDB 4


Review the details and click on on Finish, to start the removal process.

Delete PDB 5


The selected PDB has been successfully deleted.

Configure a PDB Database

The last option is to configure your already existing PDB.

Configure PDB 1


Choose the last option and then click on Next.

Configure PDB 2


Choose the CDB container which contains your PDB. Provide the SYS username and password and click on Next.

Configure PDB 3


Choose the PDB that you want to configure. Then click on Next.

Configure PDB 4


You can configure the Label security and/or database Vault. Choose the desired option and click on Next.

Configure PDB 5


Review the summary screen and click “Finish”, to start the configuration process.

Configure PDB 6


Click OK once and the configuration is completed!


External Links
• CDB and PDB Information in Views
• Using the ALTER SYSTEM Statement to Modify a PDB

Filed Under: 1Z0-060, Multitenant, Oracle 12c, OraFAQ, ToadWorld Tagged With: 1Z0-060, DBCA

« Previous Post
Next Post »

Join over 3,000 others My posts. Your Inbox. Beautiful.

Database    GoldenGate

Natik Ameen

About Natik Ameen

Natik Ameen is an Oracle Production DBA, Oracle Certified RAC Expert and a DBA track Certification trainer for over 17 years. He is an Oracle Evangelist and has presented at IOUG & UTOUG conferences. He writes on topics such as Database Administration, RAC, GoldenGate and the Cloud.

Who is Natik Ameen?

Guides

  • My GoldenGate Tutorials
  • Oracle 12c Database Tutorials
  • GoldenGate GGSCI Command Series
  • My OraTips and Tricks

Popular Blogs

  • My GoldenGate Home Page
  • Top 50 Oracle Goldengate Interview Questions To Get the Job!
  • Top 30 RAC Interview Questions That Helped Me. Are You Prepared?
  • Oracle GoldenGate Concepts and Architecture Made Simple!
  • Virtualize Oracle RAC 12c on My Laptop
  • Step by Step Oracle 12c Database Install on Virtual Box

Popular Oracle Articles

Oracle Announces Beta Availability of Oracle Database 12c Release 2
Top 5 Announcements at Oracle Open World
News on Oracle Database STANDARD EDITION 12.1.0.2

Technology Centers

Oracle Business Intelligence and DW
Cloud Computing, SOA, Virtualization
Big data, Java, Linux, PLSQL, Security
Enterprise Architecture, Digital Experience

Oracle Documentation

10g R1, 10g R2, 11g R1, 11g R2, 12c R1
Oracle CPU's, EM 11g, EM 12c
GoldenGate 12c, Oracle VM, VirtualBox

Copyright ©2021

BLOGOracle Tutorials