Installing Oracle Database 11gR2 on Oracle Linux 5


To install Oracle Database 11g R2 on a Linux server there if few things we need to keep in mind that installing Oracle Database is quite simple, it’s the pre-installation process that can be tricky.

In our example I will use the 64Bit Oracle Linux 5 update 7 which by default uses the Oracle’s Unbreakable Enterprise Kernel (read more about UEK)!

Our oracle installation will be on a different disk/partition than the OS’s, So we create 3 disks/partitions, one for the system root, one for the swap, and the third for the Oracle Database (I did define the third disk/partition as /u01).

if you have the system Installed from before then we can check the system architect with:

check the system architect:
# uname -m

It’s very important that we understand the relationship between the RAM and the SWAP size as defined with the table below:

If the RAM was
Between 4GB and 8GB then the SWAP should be 2 times the size of the RAM.
Between 8GB and 32GB then the SWAP should be 1.5 times the size of the RAM.
More than 32GB then the SWAP should be 32GB.

Note: it’s better that you prepare the system’s SWAP size while install a fresh copy of Linux.
To determine the RAM size, enter the following command:
# grep MemTotal /proc/meminfo
To determine the size of the configured swap space, enter the following command:
# grep SwapTotal /proc/meminfo
To determine the available RAM and swap space, enter the following command:
# free

After installing/checking Linux

We can install/run the Oracle Validate to check and configure (most of) the system setting and make it ready for database hosting.

Before Oracle build the Oracle-Validate package we had to do this manually but now no need to do this manually, we can just download and run the oracle-validate package.

We need to download and enable the repository.

# cd /etc/yum.repos.d

# wget http://public-yum.oracle.com/public-yum-el5.repo

Enable both the [el5_u7_base] repositories in the yum configuration file by changing enable=0 to enable=1 in those sections.
[ol5_u7_base]
name=Oracle Linux $releasever – U5 – x86_64 – base
baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL5/5/base/x86_64/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5
gpgcheck=1
enabled=1
Then we run the command
# yum install oracle-validated
After the command modifying most of the settings and adding users and groups
We go and check if the user “oracle” was created

# id oracle

To make sure that we have full control over the user’s password “oracle”:
We start to tune the settings and create some directories

Change the password for the user “oracle” to something you want.
# passwd oracle

Create the Oracle Base Directory.
We have created the disk/partition /u01 so here we are going to use it
# mkdir -p /u01/app/oracle
# chown -R oracle:oinstall /u01/app/oracle
# chmod -R 775 /u01/app/oracle
# chmod -R 775 /u01/app

Create the Oracle Inventory directory (oraInventory) stores an inventory of all software installed on the system.
# mkdir -p /u01/app/oraInventory
# chown -R oracle:oinstall /u01/app/oraInventory
# chmod -R 775 /u01/app/oraInventory

If not disable secure linux by editing the

/etc/selinux/config

file, making sure the SELINUX flag is set as follows:

SELINUX=disabled

Login as the user “oracle”

Edit the file (the default location) /home/oracle/.bash_profile

Add the following lines to file (do not replace):

# Oracle Settings

TMP=/tmp; export TMP

ORACLE_UNQNAME=ORCL; export ORACLE_UNQNAME

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME

ORACLE_SID= ORCL; export ORACLE_SID

ORACLE_TERM=xterm; export ORACLE_TERM

PATH=/usr/sbin:$PATH; export PATH

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

fi

Now you are ready to run the Oracle Installation Process

When we are done with Oracle installation and configuration process, there will be one things missing, it is the startup/shutdown process that integrates with Linux’s startup/shutdown process.

Note: It’s not like on windows where the database and the listener will be starting and shutting down when the system is starting or shutting down, you need to do that manually, and it’s a critical thing because you do not want to shut down the system while the database is running, you need to shut down the database and the listener before you shut down the system!

There will be another post to configure the process.

UPDATE: I wrote a post to learn how to automatically start/shutdown Oracle database in Linux (Auto Start/Shutdown Oracle Database 11g R2 on Linux)

Advertisements
This entry was posted in Oracle and tagged , , , , . Bookmark the permalink.

2 Responses to Installing Oracle Database 11gR2 on Oracle Linux 5

  1. Pingback: Auto Start/Shutdown Oracle Database 11g R2 on Linux | |S|A|R|M|A|D|

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s