Create Database using DBCA (Database Configuration Assistant)

1) You all may know how to configure your UNIX server to install ORACLE 10R2. If you have any doubts
     on setting up hosts, installing rpm's, configuring kernel parameters and etc., please check my third post
    (http://sagardba.blogspot.in/2012/05/installing-linux-and-oracle-10g-r2-on.html) to configure
     requirements.

2) Once you are done with configuring requirements, which makes clean Oracle installation, such as kernels,
     rpm's etc.  Log in as ORACLE user issue the following command..
    a) ./runinstaller

3) As we need to create database using DBCA. Just you can install oracle software, For that you need to 

    Advanced installation and then next

4) a) Now select installation type, select Enterprise Edition 

        and click next and then next 

    b) Now prerequisite checks

     

   c) It shows one requirement need to to verify. You no need to worry about that warning. Simply mark on 

       it as shown in figure and then select next .

5) Now select 3rd option install software only and then click on next

Now Oracle software is installing on your LINUX server.

6) Run the scripts as root user..

7) After completion of Oracle software installation. Log in as Oracle user 

   a) open terminal

   b) type dbca as shown in picture.

   c) A new window will open to create a database, click next

8) Now mark on create database,

    and then click on next. You can see in picture two options under Create database option are not 

    Highlighted, which I marked Green .

   

   Since we installed only Oracle software, as we don't have even a single database those two options are 

   not highlighted. We will see how to use those two options in our next sessions.

9) a) Tick on General purpose and click on next

    b) Give database name of your choice and click on next

10)  UN-MARK configure database using enterprise management

11) Give password of your own to your database and click on next

     

12) a) Now select File system and click next

      b) Mark second option and Give the path where datafiles you want to place as shown in picture and  

         click next

13) Now flash recovery, simply click next and  finish and then OK. AS shown in figure

     

14) Now password assistant. click on EXIT. Now you are about to complete configuring database using 

      DBCA

    a) Open terminal

    b)sqlplus / as sysdba

    c) After connected to Oracle, Issue below command

    d) select name from v$database;

    e) select name from v$controlfile;

    f) select name from v$datafile;

     Now you are about to completed creating database named vidya.

I will be back to you with another topic..

Thanks

Vidya Sagar