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
    ( to configure

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 

    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..

Vidya Sagar


  1. Hi this is Kathiresan i am having 3 years of experience as a dot net developer and i am certified. i have knowledge on OOPS concepts in .NET but dont know indepth. After learning android will be enough to get a good career in IT with good package? and i crossed Android Training in Chennai website where someone please help me to identity the syllabus covers everything or not??


    1. IEEE Final Year Project centers make amazing deep learning final year projects ideas for final year students Final Year Projects for CSE to training and develop their deep learning experience and talents.

      IEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation.

      corporate training in chennai corporate training in chennai

      corporate training companies in india corporate training companies in india

      corporate training companies in chennai corporate training companies in chennai

      I have read your blog its very attractive and impressive. I like it your blog. Digital Marketing Company in Chennai Project Centers in Chennai

  2. Hi, I am christina lives in Chennai. I am technology freak. I did Android mobile application development course in Chennai at reputed Android Training Institutes in Chennai, this is very usful for me to make a bright carrer in IT industry.

  3. Hi, I am christina lives in Chennai. I am technology freak. I did Android mobile application development course in Chennai, this is very useful for me to make a bright career in IT industry. So If anyone want to get best Android training please visit fita academy which offers real time Android Training Chennai at reasonable cost.

  4. Thanku for sharing...
    SAS Institute introduced the SAS Certified Professional Program,training proper understanding of how the SAS software works. Among the five certification programs that SAS Institute has come up with, SAS training can be considered as the entry point into the big data and the data analytics industry.
    SAS online training in hyderabad

  5. Thanks for sharing this information article
    Hi we at Colan Infotech Private Limited , a company which is Situated in US and India, will provide you best service and our talented team will assure you best result and we are familiar with international markets, We work with customers in a wide variety of sectors. Our talented team can handle all the aspects of custom application development, we are the best among the dot net development companies in Chennai .
    asp .net web development company.
    We have quite an extensive experience working with
    asp .net development services. we are the only web development company
    which offer custom services to a wide range of industries by exceeding our client’s expectations.You can even interact directly with the team regarding your project, just as you would with your in-house team.
    hire programmers
    to achieve your dream product.
    Custom application development company, development companies, asp .net web development company,Hire asp .net programmers, web development services,dot net development companies in chennai
    Hire asp .net programmers.
    Here is a good resource if anyone in need of web development services
    dot net development companies in chennai.

  6. Thats true.Fantastic caption you have provided.THe article yousubmitted for aracle is amazing.Thank you for your potentials to assemble all these screenshots to give meaning for your blog.
    ipad service center in chennai
    ipad service center
    apple mobile service centre in chennai

  7. Hi, thank you very much for new information, i learned something new. Very well written.It was so good to read and usefull to improve knowledge.Keep posting. If you are looking for any big data hadoop related information please visit our website.
    big data hadoop training in bangalore.

  8. Thanks for sharing useful information. I learned something new from your bog. Its very interesting and informative. keep updating. If you are looking for any Big Data related information, please visit our website bigdata training institute in bangalore.

  9. Good Blog, well descrided, Thanks for sharing this information.
    Big Data and Hadoop Online Training

  10. Very helpful blog,
    Thanks for sharing with us,
    We are again come on your website,
    Thanks and good day,
    If you need any logo then,
    Please visit our site,

  11. your company has shifted to a hybrid events strategy and wants to produce engaging and impactful virtual events. virtual edge and thanks for your accompany

  12. Keep sharing continue with us.
    It's very unique and helpful for us.
    Custom Logo

  13. Hey everyone.
    We are giving you the big best offer to buy logo design for your business with 80% off I expect You will be happy with us.Logo Designers

  14. I really don't have the interest to read articles or blogs but sometimes you need to do what you really think is useless but believe I am trying to find this kind of article since morning and now I found it...
    if you are really interested in web designing or logo designing then visit us we surely can help you?
    Logo Designers