Oracle 11g Release 2 Database Creation Using DBCA


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

Database Creation Using DBCA:

1. Create the required directories and set the user permissions.
# mkdir -p /u01/testdb/oradata

# chown -R oracle:dba /u01/testdb

# chmod -R 775 /u01/testdb
2. Login as oracle database administrative user and run dbca from the $ORACLE_HOME/bin location as below.


3. Now you will be presented with a database configuration assistant welcome window. Click on Next button.


4. Choose Create a Database from the below listed options as we are going to create a new database. Now click on Next button.

Database Templates

5. Select General Purpose or Transaction Processing from the below three database templates and click on Next button.

Database Identification

6. Now the database identification window will be displayed. Specify the Global Database Name and SID. Click on Next button.

Management Options

Enterprise Manager:
7. Here, optionally you can Configure Enterprise Manager for the database. If you want to configure enterprise manager while creating database, specify the information in required fields. Otherwise, please uncheck the box.

Automatic Maintenance:
8. In this window, optionally you can enable Automatic Maintenance tasks. Automatic maintenance tasks are the predefined tasks in the database such as optimizer static collection and proactive advisor reports. Click on Next button.

Database Credentials

9. In this database credentials window choose either Use Different Administrative Passwords or Use Same Administrative password for all accounts. Specify the password for administrative account and click on Next button.

Database File Locations

10. Now you will be presented with a below screen. Specify the Storage Type and Storage Locations for the database files as per your requirement. Click on Next button.

Recovery Configuration

11. Here optionally you can enable Flash Recovery Area and Archive Log Mode for the database. If you want to enable flash recovery area and archive mode, specify the required parameters and click on Next button.

Database Content

Sample Schemas:
12. Here optionally you can add the Sample Schemas to your database.

Custom Scripts:
13. If you want to run any custom scripts after the database creation, choose Run the following scripts option and add the scripts. Otherwise choose No scripts to run and click on Next button.

Initialization Parameters

14. Choose either Typical Settings or Custom Settings and specify the memory size or PGA and SGA size based on your selection.

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

Character Sets:
16. 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:
17. Accept the default Dedicated Server Mode as it allocates dedicated resource for each client. Now click on Next button.

Database Storage

18. The below database storage window allows you to specify the storage parameters. You can create or delete database objects by selecting each folder. If you are happy with your previous parameters just click on Next button.

Creation Options

19. Choose Create Database option, as we are going to create new database and click on Next button.


20. Now the confirmation window will be presented as below. Read the database summary information and click on OK button to start the installation.

Database Configuration Assistant

21. The database creation will be processed as below.

22. Now After the successful database creation the below screen will be shown. Select the Password Management button to view the list of locked account users. Click on Exit button to exit the installer.
This completed the database creation.


Post a Comment