Oracle 11g installation on Linux

In this article we will look at Oracle 11g installation on Oracle Linux 6.5. We will be using Oracle 11g silent method for installation and database creation.

• OS Pre-Requisites 

• Install Oracle 11g Software 

• Error – Package Failure 

OS Pre-Requisites

Create two directories /u01 and /u02 which will serve the base for the installation and give ownership to Oracle user

mkdir -p /u01 /u02
chown -R oracle:oinstall /u01 /u02

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

Switch to Oracle user and update the bash profile

su - oracle
vi .bash_profile

Make sure your bash profile looks like below

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific environment and startup programs
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_SID=prod

export NLS_LANG=american_america.al32utf8
export NLS_DATE_FORMAT="yyyy-mm-dd:hh24:mi:ss"

PATH=$PATH:$HOME/.local/bin:$ORACLE_HOME/bin

export PATH

Export the bash profile

. .bash_profile

Check if ORACLE_HOME is set or not

env | grep ORA

We have two option to install oracle software: Silent Method and GUI method. We will go with silent method as its fast and used by all experienced DBAs.

Install Oracle 11g Software

Download Oracle 11g from edelivery.oracle.com and copy files to /u02 using winSCP. 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 *

Create response file under /tmp location

vi /tmp/11g_response.rsp

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=${HOSTNAME}
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/oracle/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=${ORACLE_HOME}
ORACLE_BASE=${ORACLE_BASE}
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=dba
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true

Go to 11gR2 installation software location and fire the runInstaller in silent mode

./runInstaller -silent -ignoreSysPrereqs -ignorePrereqs -responseFile /tmp/11g_response.rsp

NOTES:

• ignoreSysPrereqs will ignore any pre-requisite errors

• silent will force runInstaller to run in silent mode (no GUI)

• responseFile is the name & location of your response file (create above)

Post installation, run the root scripts and update the bash_profile to reflect correct ORACLE_HOME.

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*

Enjoy!!!