A journey towards oracle.....!!!: Oracle 11g

Oracle released 11g Release 2 and I was just waiting to get my fingers on it…!!! So downloaded the software from OTN and installed it on Linux. As of now, the software is available only on Linux.

The installation screens are catchy, oracle has left those blue installation screens of OUI, so altogether new screens. Another thing that I noticed that installation took damn good time, the reason being moving between the screens took lots and lots of time. I was doing the installation on remote server using Xmanager, but I don’t think that could be the reason for slowness, already installed 10g lot of times on the server and it was damn good.

Another new thing is the software can be installed for single instance or RAC installation. There is an option to check the language during software installation. There is an option to create response file at the end of installation which can help in future installations. So my software download is complete…Let's get to real work…

Download Software
Download the following software from OTN

http://www.oracle.com/technology/software/products/database/index.html

Oracle Database 11g Release 2 (11.2.0.1.0) for Linuxx86

linux_11gR2_database_1of2.zip (1,285,396,902 bytes) (cksum -2237015228)

linux_11gR2_database_2of2.zip (995,359,177 bytes) (cksum - 2649514514)

Unpack Files

unzip linux_11gR2_database_1of2.zip

unzip linux_11gR2_database_2of2.zip

This will create a directory called database and extract both the zip files into it.

[root@oracle10g u02]# ls -rlt

total 2229520

drwxr-xr-x 8 oracle dba 4096 Aug 19 01:24 database

drwx------ 2 root root 16384 Sep 12 15:07 lost+found

-rw-r--r-- 1 oracle dba 1285396902 Sep 12 15:54 linux_11gR2_database_1of2.zip

-rw-r--r-- 1 oracle dba 995359177 Sep 12 15:57 linux_11gR2_database_2of2.zip

[root@oracle10g u02]#

Minimum hardware requirements:

32-bit (x86)

x86 compatible CPU
1 GB RAM

64-bit (x86_64)

x86_64 compatible CPU
1 GB RAM

32-bit (x86) Installations

Check your kernel version by running the following command:

uname -r
[root@oracle10g ~]# uname -r

2.6.9-89.0.0.0.1.ELsmp

The minimum Linux version required for 11gR2 is RHEL 4.0

Required package versions (or later):

compat-libstdc++-33-3.2.3-61
elfutils-libelf-0.125-3.el5
elfutils-libelf-devel-0.125-3.el5
glibc-2.5-12
glibc-devel-2.5-12
glibc-common-2.5-12
gcc-4.1.1-52.el5
gcc-c++-4.1.1-52.el5
kernel-headers
libgcc-4.1.1-52.el5
libaio-0.3.106-3.2
libaio-devel-0.3.106-3.2
libstdc++-4.1.1-52.el5
libstdc++-devel-4.1.1-52.el5
unixODBC-2.2.11-7.1
unixODBC-devel-2.2.11-7.1
sysstat-7.0.0-3.el5
binutils-2.17.50.0.6-2.el5
make-3.81-1.1

Run the following command to check the RPMs.

rpm -q binutils-2.15.92.0.2 \

compat-libstdc++-33.2.3 \

elfutils-libelf-0.97 \

elfutils-libelf-devel-0.97 \

gcc-3.4.6 \

gcc-c++-3.4.6 \

glibc-2.3.4-2.41 \

glibc-common-2.3.4 \

glibc-devel-2.3.4 \

glibc-headers-2.3.4 \

libaio-devel-0.3.105 \

libaio-0.3.105 \

libgcc-3.4.6 \

libstdc++-3.4.6 \

libstdc++-devel-3.4.6 \

make-3.80 \

pdksh-5.2.14 \

sysstat-5.0.5 \

unixODBC-2.2.11 \

unixODBC-devel-2.2.11

Create the Oracle Groups and User Account

Next, create the Linux groups and user account that will be used to install and maintain the Oracle Database 11g Release 2 software. The user account will be called oracle, and the groups will be oinstall and dba. I usually use only dba group in my installations.Execute the following commands as root:

# /usr/sbin/groupadd dba
# /usr/sbin/useradd -m -g dba oracle

# id oracle
uid=501(oracle) gid=502(oinstall) groups=502(oinstall),503(dba)

Set the password on the oracle account:

passwd oracle

# passwd oracle
Changing password for user oracle.
New password:
Retype new password:
passwd: all authentication tokens updated successfully.

Configuring the Linux Kernel Parameters

Oracle Database 11g Release 2 requires the kernel parameter settings shown below. The values given are minimum, so if your system uses a larger value, don't change it. Linux allows modification of most kernel parameters while the system is up and running, so there's no need to reboot the system after making kernel parameter changes.

cat >> /etc/sysctl.conf <

kernel.shmall = 2097152

kernel.shmmax = 536870912

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 6815744

fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default=262144

net.core.wmem_default=262144

net.core.rmem_max=4194304

net.core.wmem_max=1048586

EOF

Setting shell limits for the oracle user 
Oracle recommends setting limits on the number of processes and open files each Linux account may use. To make these changes, cut and paste the following commands as root:
cat >> /etc/security/limits.conf <> /etc/pam.d/login <Change the default profile for bash and ksh as well as the default login script for cshell.
cat >> /etc/profile <> /etc/csh.login <

Installation

Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable:

DISPLAY=:0.0; export DISPLAY

Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory:

[root@oracle10g database]# pwd

/u02/database

[root@oracle10g database]# ./runInstaller