Steps to create database using DBCA tool

Steps to create database using DBCA tool

1) Open a terminal and invoke DBCA




2) Click next to proceed further




3) Click create database and then click next to proceed further




4) Click general purpose and then click next to proceed further

5) Give database name and then click next to proceed further

6) To configure Enterprise Manager tick the checkbox and then click next to proceed further

7) Give the password for the following users and then click next to proceed further

or

8) Select file system and then click next to proceed further

9) Select the location to create database and then click next to proceed further

10) Tick checkbox of flash recovery area and to put database in archivelog mode Tick the checkbox of enable archiving and then click next to proceed further

11) Tick checkbox of sample schema to create some default users for testing purpose and then click next to proceed further

12) Select custom to alter sga size and pga size and then click sizing tab to proceed further

13) You can alter number of process according to your requierment and then click Character set to proceed further

14) Click connection mode to proceed further

15) Select network connection mode and then click next to proceed further

Select shared server mode

Select edit shared server parameter

Select number of dispatcher

16) Select ok to proceed further

17) Database creation will take place

18) Click exit to proceed further