• 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!

Recent Posts

See All

How to plan database creation

Database creation process involves several operating system files to work together. You create database only once and later on keep on adding more data files. Before you can simply go ahead and start

Oracle Transportable Tablespace

Assume that you have a schema (IQS) on production server and you want to import the schema into test server. The ideal approach would be to perform entire schema export and import using data pump. Rig

Grant Select on all tables in a schema

I encountered this situation where I wanted to grant SELECT on all the tables owned by one user to another user. There are two simple ways to achieve this: Generate SQL for each table In this method,

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis

Feedback