How to create local database in Oracle 10g

Hi Guys here is my first post in this blog.

So many students as well as professional faced problem creating a database in local system /desktop.So after finishing the installation of the Oracle 10g we can proceed ..

After the successful completion of the Oracle 10g installation click on

Start ->Oracle ->OraDb10g_home1 -->Configuration and Migration Tools -->Database configuration assistant. It will open a window of Database Configuration Assistant.

Step 1:

Select ‘create a database’ option then click next.

Step 2:

Select the options ‘General Purpose’ then click next.

Step 3:

Provide the database name relevant to your work. Then click next.

Note: Here database name has been written as ‘ds011’.

Step 4:

Select the checkbox ‘Configure database with enterprise manager’ and also select the option ‘Use Database Control for Database Management’. Then click next.

Step 5:

Provide “oracle” for password and confirm password. Then click next.

Step 6:

Select ‘File System’ option. Then click next.

Step 7:

Select option ‘Use Database File Locations from Template’ and click next.

Step 8:

Select ‘Specify Flash Recovery Area’ option and click next.

Note: The flash Recovery Area and Flash Recovery Area size will be populated automatically.

Step 9:

Select next to proceed to next step.

Note: You can select ‘Sample Schema’ if you need it otherwise ignore the option.

Step 10:

Keep everything as default in this step and then click next.

Note: Memory allocation should be selected as ‘Typical’ before going to next step.

Step 11:

A window will show the summary of the Database Storage page. Click on next to proceed to the next step.

Step 12:

Select the ‘Create Database’ checkbox and click next.

At last it will show a confirmation page for the common options just click ‘OK’ button and database creation will start automatically.

The database creation process will take 2 -5 minutes to complete. Click on the finish button to finish the process and come out of the ‘Database Configuration Assistant’ manager. Your database has been created.