In Oracle 12c, Container Databases (CDB) were introduced which allowed for multiple Pluggable Database (PDB) to be placed in a single oracle instance to reduce the amount of resource consumed.   This procedure covers the creation of a PDB in an already existing CDB using Oracle Database Configuration Assistant in a Windows environment.

 

1. Logon your windows server as the administrator.

 

2. Open Oracle Database Configuration Assistant.

3. At the Database Operation Page select “Create Database”

 

4. At the Manage Pluggable Database Page select “Create a Pluggable Database”

5. At the Database List Page, select the Container Database CDB you would like your PDB to be created in.

6. At the Create Pluggable Database page, select “Create a new Pluggable Database” and press Next.

7. At the Pluggable Database Options page, Enter the name of the Pluggable Database, Storage options, and Password Credentials. NOTE:  This is an administrator account inside of the new PDB, not administrator account of OS or CDB.  Press Next button.

8. At the Summary Page, Press the Finish button.

9. The PDB will now be created in Windows.

10. A confirmation screen will appear once the install is completed and press the OK button.

11. Back at the Progress Page, press the Close button to terminate Database Configuration Assistant.

 

 

This completes creation of Oracle 12c PDB in an existing CDB with Database Configuration Assistant.

 

 

Larry Catt

OCP