Step by Step Installation of Oracle 10G on Linux using VMware Server – Part 1

Installing Oracle Database 10g Release 2 on Linux

Installing oracle 10G on windows in very simple. By following the prompts correctly you can install Oracle on Windows with ease as there are no prerequisite actions before installation. But same is not the case in Linux as you need to follow some prerequisite actions as well. Assumptions: You have already downloaded CentOS from and you also have VMware 1.0.4. In this tutorial, I will guide you to install oracle database on  CentOS.  This whole installation would be done on VMware 1.0.4 hence make sure you have downloaded VMware on your computer as well

Installing CentOS on VMware – Step by Step Instructions

  • Go to File –> New –> Virtual Machine


  • Click on Next


  • Select Custom and Click Next


  • Select Linux and Choose ‘RED HAT LINUX’ as the version


  • Type in the Virtual Machine Name and select the location of the Virtual Machine.– Click Next


  • Leave the box unticked if you want this installation to work on other computers that have VMware installed on it and click Next


  • Click Next


  • Select the number of processors as per your requirement and proceed


  • Set the Memory for the Virtual Machine – Note: Oracle 10g requires at least 1 GB of RAM


  • Select the Network type as per your choice and click next


  • Choose  LSI Logic as the SCSI Adapter –> Next


  • Choose ” Create a New Virtual Network” and click Next 


  • Under Virtual Disk Type select IDE –> Next


  •  Enter disk size as per your choice but  don’t tick on allocate all disk space now as this option will reserve the selected space even if its not used. Hence its always recommended to leave it unticked unless you have a lots of free space


  • Click Next and Finish


  • Now Click on Edit Virtual Machine Settings, Click on CD- ROM —> Select use ISO Image (Browse and specify the location of the CentOS ISO file) –> Then press OK


  • Now its time to start the Virtual Machine


  • Hit the Enter Key to install CentOS in graphical mode


  • Now you need to click on SKIP


  • Press Next 


  • Select your preferred language and then click next


  • Click on Yes and proceed


  • Don’t make any changes, just click next again


  • Now it will give you a message ” You have chosen to remove all linux partitions on the following drives:  Are you sure you want to do this”   just click on YES


  • You may now have to configure IP address, just select “Automatically via DHCP” or You can also configure IP address manually 
  • Now select your location and press next


  • Enter the root password and confirm it by retyping it and then click next


  • Now you need to select customize now  and then next
  • Select Desktop Environments  and choose GNOME  Desktop Environments


  • Go to Applications and then choose Graphical Internet and leave all other options as it is


  • Go to  Development and then choose GNOME Software Development, Java Development, X Software Development, Development Tools, Development Libraries and Legacy Software Development


  • Click on Servers  and  select Web server ,Server Configuration Tools, Windows File Server


  • Finally go to Base System and choose Base, Java, Legacy Software Support, System Tools, X Window System and Administration Tools and then click Next


  • Click Next again and Reboot


  • After its rebooted ,click  the forward button 


  • Change the Firewall state to Disabled and click forward


  • Disable  SELinux  too and click forward


  • Don’t make any changes on the next screen (Keep the Kdump disabled) and click Next
  • Set the date and time  and click forward
  • Create a new user by filling the details (you can also skip this step)


  • Click Forward and then click Finish.  Now click ok so that the system would reboot


  • Once restarted, it will ask you to enter username and password, hence enter the correct details


  • Once logged in you would see the below screen


  • This is the end of PART 1 . In my next post I will cover Installing RPM packages which are required for Oracle Installation , Configuring Kernel Parameters, creating groups and users for Oracle Installation etc. Till then stay tuned 🙂


How to Write a Basic Select Statement in SQL Plus

You can display all the date in a table by using the select statement. By using * asterisk in a select statement it displays the data of all the columns in the table

Example 1:  select * from team;

Where team is the table name and ( * ) Asterisk is a wildcard character  which displays all the data in the table along with all the columns


Selecting Specific Columns

Example 2:

If you want to display certain columns from the team table then you need to write the name of the columns after the (*) Asterisk.Question 1) Display First_name, Sex, Age from team

Answer)        select first_name,sex,age from team;


In similar manner you can write your own statements and display the required results.


How to Insert Data into a Table in SQL Plus – Oracle 10G

In the previous post we learned to create a table in oracle. Today lets insert data into the table we created. Below is the format of the table we created. first_name, last_name, sex and age are the columns in our table.

table format

So to insert data into these columns  type :

insert into team values(‘Anish’,’Sangamam’,’male’,23);

Here team is the table name. Similarly,   insert into team values(‘anish’, ‘last’, ’20’, 10);

oracle 1

Insert Values into the Table at Run-time

Inorder to insert values at run time you need to add the amperand sign before the column names and instead of putting in the values you simply type ampersand followed by the column name.

Insert into team values(‘&first_name’,’&last_name’,’&sex’,’&age’);

When you run the query it will ask you for the firstname, lastname,sex and age.



How to Create a Table in SQL Plus – Oracle 10G

Today, I would like to share what I have learned while studying oracle.  I’m not going by the books right now as in the books you would learn on how to fetch data from the data base using the select statement but I’m starting of with creating a table.

Before we start, you need to have knowledge about the commonly used data types.  They are char, varchar, number and date. To get more information on data types and their size read Oracle Data Types.

Syntax to Create a Table :

create table tablename (“column1” “data type” [constraint], “column1”  ‘datatype'[constraint], “column1” ‘datatype’ [constraint], “column1”  ‘datatype’ [constraint]);

  • “Constraint”  –  we use constraints to limit the type of data that go into a table

Exercise 1

create table team (first_name varchar(20), last_name varchar(20) , sex varchar(10), age varchar(99));

Here team is the tablename , first_name is the column, varchar is the datatype and the values in parenthesis are constraints

oracle 1

That’s how you create a table.  you can create your own table. Check out another example


create table linkinpark (first_name varchar(20), last_name varchar(20));