Oracle 10g Free Training:Creating Database Using Database Configuration Assistant (DBCA)

This tutorial explains how you can Create Database Using Database Configuration Assistant (DBCA).

To create database by using database configuration go to start button and click on programs -> oracle -> configuration and migration tools ->database configuration assistant

You will get a welcome screen as below.

Click the next button to follow the next screen; in this screen you have options, to create a database, configure database options, delete a database, and manage templates.

Click the next button to get the database templates page, select the type of database template to be used in creating the database. You can click show details to see the configuration for each type of database. Choose the template suited to the type of workload your database will support. If you are not sure, select the default general template. Click Next.

Click next button to continue, here you have to enter the GLOBAL DATABASE NAME and SID.

Click the next button. By default it select the database with enterprise manager and grid control for database management .or you can choose grid control for database management as it suit to your configuration

Click the next button, enter the password.

Click the next button, Select File System, Automatic Storage Management, or Raw Devices to best suite to system.

Click the next button; specify the location for the creation of the datafiles. Choose one of the following: Use database File Locations from Template, Use Common Location for All database Files, or Use Oracle-Managed Files.

Click next button, Select Flash Recovery Area and specify a directory location and size

Click next button, Click the Sample Schemas tab. Select Sample Schemas if you want to include the Sample Schemas (EXAMPLE) tablespace in your database

Click the next button, The Memory page appears keep the defaults,

Click the next button, the database Storage page appears. Accept the configuration or make changes as needed

Click the next button, Select Create database to create your database. You can also select Save as a database Template to save your configuration

Click the finish button, the confirmation screen will appear

Click ok

After the database is created, you can change or unlock your passwords or click exit.


Recent Tutorials

Subscribe to oracle tutorials

Enter your email address:

Delivered by FeedBurner

Blog Archive

Visitors

DigNow.org