• Arun Kumar

Oracle 11g installation on OEL 6.5

Hi guys, in this article I will show you how to install Oracle 11g software on Oracle Enterprise Linux 6.5.

Please note that the steps are same for RedHat Linux!


Pre-Install Steps


Create and install OEL 6.5 on a new virtual box machine. Make sure to give proper hostname and IP addresses. In our practice, we choose


Hostname = ogprod.dbagenesis.com

Allocate 2 GB RAM and 80 GB HDD to the virtual machine.



OS Pre-Requisites


Check the Linux hostname to make sure you are installing on correct machine


# hostname

Check free space on your server where you can install oracle


# df -h

Create directory location if not already available


# mkdir -p /u01 /u02

Copy downloaded files from oracle.com to /u02 using winSCP


Install oracle-rdbms* package to complete OS level pre-requisites


# yum install oracle-rdbms*

The above script will create oracle user also. we need to change password for oracle user


# passwd oracle

As the directory is created via root user, give permissions and ownership to Oracle user


# chown -R oracle:oinstall /u01 /u02

Check the ownership on above folders via below command


# ls -ld /u01 /u02

Once files are copied via winSCP, unzip them one by one


# cd /u02  --> or the location where you copied files

The downloaded files from Oracle will be in zip format, let us unzip the files


# unzip <file_1>


# unzip <file_2>

If you unzip above files as root user, you need to change ownership


# cd /u02


# chown -R oracle:oinstall *

Make sure to start xming at windows level as we will use graphical interface to install oracle



Error – Package Failure


If you see 32 bit packages installation error, follow below:

yum -y install i686


yum -y install glibc-devel-2*i686*
yum -y install glibc-2*i686*
yum -y install libaio-0*i686*
yum -y install libaio-devel-0*i686*
yum -y install libgcc-4*i686*
yum -y install libstdc++-4*i686*
yum -y install compat-libstdc++-33*i686*

Note: With the above method, you can install any 32 bit RPM on any Linux machine.


Install Oracle 11g Software


Before Proceeding

  • Make sure you have unzip the software files

  • Make sure Xming is started at OS level

  • Take a fresh session in putty and login as Oracle user

Begin Installation


If you face error – “Clould not retrive local node names” then # vi /etc/hosts at the end of the file add below <your_machine_ip> <your_machine_hostname> Example 192.168.0.100 ogprod.dbagenesis.com

Start the run installer


# cd /u02/database
# ./runInstaller

Follow the installer and proceed with installation.


Setting Environment Variables


Get the location of ORACLE_HOME in a notepad. This is the location where you installed oracle software


ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

Switch to oracle user at OS level if already not


# su - oracle

Check the oracle home location if software files are visible


# ls /u01/app/oracle/product/11.2.0/dbhome_1

With oracle user open the .bash_profile to set variables. To come at oracle user home location, use below command


# cd
# vi .bash_profile

Add below line above the PATH variable


export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

Also change HOME to ORACLE_HOME in PATH variable. Save and exit


Execute the .bash_prfile only once


# . .bash_profile

Check if ORACLE_HOME is set or not


# echo $ORACLE_HOME
# env | grep ORA

See if you are able to start sqlplus. If not, your ORACLE_HOME is set wrong


# sqlplus

Done!

278 views

Recent Posts

See All

Reclaim Unused Space in Oracle

Over a period of time, updates and deletes on objects within a tablespace can create pockets of empty space that individually are not large enough to be reused for new data. This type of empty space i