Database creation using DBCA

Before stating the dbca you need to set the display variable.

#export DISPLAY=host-ip:0.0

#xhost +

You can start the DBCA using the below command

$dbca

Click Next on the welcome screen

select create database option.


Click Next.

                                                              

Select the type of database template to create a database.



Click Next.

Mention the Global DB Name and
SID for the database.



Click Next.

Select the check box if OEM need
to be configured.



Click Next.

Confirm the password for each user or you can mention same password for all the users.



Click Next.

Select the type of storage for the database files. In my case i used Unix file systems.


Click Next.

Specify the location to store the database files.






Click Next.

Select the check box "specify flash recovery area" to store archive logs, backups etc.

To keep the database in archive log mode select the check box "Enable archive log"


Click Next.

Select the check box if we need the sample schema's.






Click Next.

Allocate the memory for SGA components.

Click on the "All initialization parameters" button to check all the parameters.

Click Next.

check the physical location of the database files.

Click Next.

Select the check box "create database" and click finish.




Click Next.

click ok.

Database creation in progress.  If you need to stop the DB creation click on stop button.














Click Exit.