Oracle 12c Release 2 Database Creation


This article explains the step by step procedure to create an Oracle 12c Release 2 (12cR2) database by using Database Configuration Assistant (DBCA).

Oracle 12cR2 Database Creation Using DBCA

1. Create the required directories and set the user permissions.
# mkdir -p /u01/test/oradata
# chown -R oracle:dba /u01/test
# chmod -R 775 /u01/test
2. Login as oracle database administrative user and run dbca from the $ORACLE_HOME/bin location as below.

Select Database Operation

3. Choose Create a database option from the below listed options as we are going to create a new database. Click on Next button.

Select Database Creation Mode

4. Select Advance Configuration option and click on Next button. If you want default configurations for your database, select Typical configuration and click on Next button.

Select Database Deployment Type

5. Select Database Type as Oracle Single instance database from the drop-down menu and select database template as General Purpose or Transaction Processing. Now Click on Next button.

Specify Database Identification Details

6. Provide the details for the Global database name, SID and click on Next button. If you wish to create a container and pluggable databases, Check the mark for Create as Container database and enter the required fields. Otherwise you can skip and go with next step.

Select Database Storage Options

7. Choose Database files storage type from the drop-down menu and specify the path for Database files location. Click on Next button.

Select Fast Recovery Options

8. If you want to configure recovery options for the database, enter the required fields for Specify Fast Recovery Area and Enable archiving. Otherwise and skip this step and Click on Next button.

Specify Network Configuration Details

9. Now you will be presented with a network configuration window. Here you can optionally create a listener by entering the required fields. Click on Next button once you are done.

Select Oracle Data Vault Configuration Options

10. Here, you can optionally configure Oracle 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.

Specify Database Configuration Options

11. Here, in Oracle12c Release 2 we have three options for memory configuration.
Automatic Shared Memory Management:
The automatic shared memory management, will give you the direct control over the sizes of the System Global Area (SGA) and instance Program Global Area (PGA). This will automatically readjust the sizes of the main pools (db_cache_size, shared_pool_size, large_pool_size, java_pool_size) based on existing workloads.
Manual Shared Memory Management:
The manual Shared Memory management allows you to tune the individual parameters by specifying the size for each main pool.
Automatic Memory Management:
In this Automatic memory management, oracle database instance automatically manages and tunes the memory.
Choose the desired memory configuration option and enter the required fields.

Specify the number of Processes for operating system users that can be connected to the database simultaneously.

Character Sets:
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 as database character set.

Connection Mode:
Accept the default Dedicated Server Mode as it allocates dedicated resource for each client.

Sample Schemas:
Here, optionally you can add the Sample Schemas to your database. Click on Next button once you are done.

Specify Management Options

12. In this window, optionally you can Configure Enterprise Manager Database Express for your database and/or Register with Enterprise Manager Cloud Control. Click on Next button after making changes as per your requirement.

Specify Database User Credentials

13. Choose either Use different administrative passwords or Use same administrative passwords for all accounts and enter the password for administrative users. Click on Next button.

Select Database Creation Option

14. Select the Create Database option as we going to create a new database and click on Next button.


15. Now you will be presented with below summary screen. Read the database summary information, If you are happy with it click on Finish button to start the database creation.

Progress Page

16. The database creation progress will be shown as below. Please wait for it to complete.


17. Now after the successful database creation the below screen will be presented. Click on the Password Management button to view the list of locked user accounts. Now click on Close button to exit the installer.

This completes the Oracle 12c Release 2 or 12cR2 database creation.


Post a Comment