Oracle 12cR1 Database Creation Using DBCA


This article explains the step by step procedure to create an Oracle 12c Release 1 database by using DBCA.

Database Creation Using DBCA:

1. Login as a database administrative user and Navigate to oracle home bin location. Start the Database Configuration Assistance by running dbca as below.

Database Operations:

2. Now you will be presented with the below welcome screen. Select Create Database option as we are going to create a new database. Click on Next button.

Creation Mode:

3. Select Advanced Mode for custom configuration. Click on Next button. You can select Create a database with default Configuration, if you want the default configuration for your database. 

Database Template:

4. From the below three database templates, choose General purpose or Transactions Processing and click on Next button.

Database Identification:

5. In this Database Identification screen specify the Global database name and SID name and click on Next button. Additionally, you can create container database by choosing Create As Container Database and entering the required fields.

Management Options:

6. Here optionally you can either configure Enterprise Manager Database Express or Register Enterprise Manager Cloud Control for your database. If do not want to configure Enterprise Manager, please uncheck the box for Configure Enterprise Manager and click on Next button.

Database Credentials:

7. Choose either Use Different Administrative Passwords or Use Same Administrative Passwords. Please enter the password for administrative user accounts and click on Next button.

Network Configuration:

8. Now network configuration window will be displayed as shown below. Enter the details for Listener Name and Listener Port and click on Next button.

Storage Locations:

9. Choose the Database Files Storage Type from the drop down menu. Specify the location for database files storage. You can optionally configure Fast Recovery Area and Archive log mode for the database. Click on Next button once you are done.

Database Options:

10. Sample Schemas
Here optionally create Sample Schemas and select a script to run after database creation.

11. Database Vault & Label Security
Here you can optionally configure Database Vault and Label Security for the database by entering the requested fields. After Making the changes as per your requirement and click on Next button.

Initialization Parameters:

12. Memory
Choose either Typical Settings or Custom Settings for Database Memory Management options. Specify the memory size or PGA and SGA size based on your selection.
13. Sizing
Specify the number of Processes for operating system users to connect the database.

14. Character Sets
You should select the Character Set type carefully. It is difficult to change the character set after installation, and there are many restriction for character set conversion. AL32UTF8 supports almost all languages, so it’s recommended that you use AL32UTF8 if there is a chance of using more than two different languages.

15. Connection Mode
Accept the default Dedicated Server Mode as it allocates dedicated resource for each client. Click on Next button.

Creation Options:

16. Now you will be presented with the below screen. Choose Create Database option as we are going to create a new database and click on Next button.

Prerequisite Checks:

17. Now the Installer will perform prerequisite checks and displays the summary screen if you don’t have any errors or warnings. If you have any warnings or failed errors, please resolve before proceeding.


18. Click on Finish button to start the database creation.

Progress Page:

19. The database creation progress will be shows as below. Please wait for it to complete.


20. Now After the successful database creation the below screen will be presented. Select the Password Management button to view the list of locked account users. Click on Close button to exit the installer.

This completes the successful creation of oracle 12cR1 Database using dbca.


Post a Comment