Step by Step installing Oracle 11gR2 on OEL 5.5

Step by Step installing Oracle 11gR2 on OEL 5.5: "
In this step by step tutorial I’m going to show you the installation of Oracle 11gR2 on OEL 5.5

As in every my step by step and video tutorials, I use VMware virtual machine, so here also I start with creating a virtual machine

P.S. Actually I was preparing this tutorial for CentOS, but somehow mixed .iso images :) So the name of the virtual machine appears as “CentOS” but the installation is made on OEL. However, you can try the same tutorial for CentOS as well



Click Next



Select Typical and click Next



Select Linux and “Red Hat Enterprise Linux 5″ as an OS version and click next



Provide the name of virtual machine and specify the location and click next



Select “Use bridged networking” and click Next



Specify the size of the virtual machine and click Finish



Delete Floppy, USB Controller and Sound Adapter devices, set Memory to 1024 Mb, mount ISO image of the OEL 5.5 OS and click OK



Click “Power on” button to start the virtual machine



Click enter



Select Skip button



Click Next



Select Installation language and click next



Select the keyboard and click next



Click on Yes



Click Next



Click on YES to remove the partition and click next



Click Next



Select the country and click next



Provide the password of the root user and click next



To install required packages for Oracle installation select “Customize now” and click Next



Desktop Environments

GNOME Desktop Environment

Applications

Graphical Internet

Development

Development Libraries

Development Tools

GNOME Software Development

Java Development

Legacy Software Development

X Software Development (Select libxpdevel and openmotif)

Servers

Server Configuration Tools

Web Server

Windows File Server

Base System

Administration Tools

Base

Java

Legacy Software Support (select compat-db)

System Tools (select sysstat)

X Window System



Click Next to start the installation





Click on Reboot button



Click Forward



Choose the first option and click Forward



As we use the virtual machine for testing purpose, disable the firewall and click Forward



Disable Selinux and click Forward



Click Forward



Specify the time and date and click Forward



We don’t need to create a user so click Forward



Click Finish button to finish the installation of OEL



Login with the root user



From VM menu, select Install VMWare tools



If the vmware installation cd doesn’t appear automatically, Eject the previous cd (installation of OEL), doublt click on Computer and double click on Cd-rom device. This will initialize the vmware tools cd



Double click on .rpm package



Click on Apply to start the installation



After you set all configurations, open new terminal and run vmware-config-tools executable and finish the installation of vmware tools



Now let’s create a user and groups for Oracle installation

groupadd  oinstall
groupadd  dba
useradd -m -g oinstall -G dba -d /home/oracle -s /bin/bash -c "Oracle Software Owner" oracle
passwd oracle



Change the /etc/sysconfig.conf file to add (change) kernel parameters that are required for Oracle installation

The file should be as follows:

net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 2147483648
kernel.shmall = 2097152
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 = 1048576
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576



To make the active in the current session, run /sbin/sysctl -p command



Change /etc/pam.d/login file and add the followingn line:

session required pam_limits.so



Change /etc/security/limits.conf and add the following lines:

oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  1024
oracle              hard    nofile  65536





Create necessary directories for Oracle home



Change the entry of .bash_profile file of the oracle user and add following lines:

vi /home/oracle/.bash_profile

export ORACLE_HOME=/u01/home/oracle/product/11.2.0/db_1
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH





Now copy downloaded oracle installation files to the /tmp directory



Switch to the /tmp directory and unzip both files with oracle user. This will create a new folder called “database”



Logout from root user, login with oracle, switch to the /tmp/database directory and run installation by running the following executable

cd /tmp/database

./runInstaller





Select Create and configure a database and click next



Select the first option and click Next



Provide the name of the database and the password and click next







Specify the folder for the inventory directory and click Next



In the prerequisite check we was informed that we need to install three packages as well. So mount the .iso file of the OEL installation, switch to the Server folder



Install all three packages with rpm -Uvh command as it’s shown above



Click on Check Again button and you’ll see that those notifications are disappeared. Check “Ignore all” checkbox and click Next



Click Finish button to start the installation





DBCA tools automatically will start to create the database named mydb



After all, the installation finished successfully. Get the url of the database control



Open a web browser and paste that url to the address field. Click “or you can add an exception” link



Click on “Add Exception” button



Click Get Certificate and Confirm Security Exception buttons





Provide the password for sys user and password, select SYSDBA and click Login button





Switch to the installation page and run both shell scripts with root user







Open a new terminal, export ORACLE_SID variable and connect to the database

I hope by following my step by step instruction, you’ll also install Oracle 11gR2 on OEL successfully


"

Comentarios

Entradas populares de este blog

Buscar la sesión por PID y ver la query SQL en Oracle

Como mover un indice de tipo LOB a un tablespace diferente

Eliminar procesos MySQL que están en estado SLEEP por determinado tiempo