In Oracle 12c, Container Databases were introduced which allowed for multiple separate database to be placed in a single oracle instance to reduce the amount of resource consumed. This procedure covers the creation of a CDB using Oracle Database Configuration Assistant in a Windows environment.
- Logon your windows server as the administrator.
- Open Oracle Database Configuration Assistant.
- At the Database Operation Page select “Create Database”
- At the Creation Mode Page select “Advanced Mode”
- At the Database Template Page select the Desired type of database, in This example we select “General Purpose or Transaction Processing”
- At the Database Identification Page enter the Global Database Name and SID, then select “Create as Container Database” and “Create an Empty Container Database”
- At the Management Options Page, select Configure Enterprise Manger (EM) Database Express if desired.
- At the Database Credentials Page, select Use the Same Administrative Password for All Accounts and enter a valid password.
- Additionally enter a password the administrative account on the windows system.
- On the Network Configuration Page, select the Listener to be used by the new database.
- At the Storage Location Page, select the appropriate storage for your database.
- At the Database Options page select nothing and Press Next button.
- At the Initialization Parameters Page, select the defaults and Press the Next button.
- At the Creation Options Page, select Create Database and Generate Database Creation Scripts (giving a valid destination directory) and press Next button.
- At the Summary Page, press the Finish button.
- The Progress Page, a confirmation of script creation will be displayed, once complete press OK.
- The CDB will now be created in Windows.
- A confirmation screen will appear once the install is completed and press the Close button to terminate Database Configuration Assistant.
This completes creation of Oracle 12c CDB in Windows environment with Database Configuration Assistant.
Larry Catt
OCP