Monday, 2 February 2015

Installation of Oracle 11g Release2 (11.2.0.1) on OEl 5.4


Installation of Oracle 11g Release 2(11.2.0.1.0) on OEL 5.4 (Oracle Enterprise Linux).

This post describes STEP-by-STEP Installation of Oracle 11gR2 database software on OEL 5.4
This blog does not cover database creation Process.
So here,The Following Steps:
  1. Pre-Installation Tasks
  2. Download & Install
  3. Post-Installation Tasks
  4. Common Installation Errors 
Pre-Installation Tasks. 

1.      Create oracle user account.
       Login as root and create user “oracle which belong to oinstall and dba groups
       Open new Terminal “Right Click on Desktop and Click on Open Terminal”

      # mkdir  -p /oraeng/apps/oracle/product/11.2.0
      # groupadd oinstall 
      # groupadd dba
      # useradd –g oinstall –G dba –d /oraeng/apps/oracle/product/11.2.0 –m oracle
      # passwd oracle
      Changing password for user oracle.
      New UNIX password: oracle
      BAD PASSWORD: it is based on a dictionary word
      Retype new UNIX password: oracle
      passwd: all authentication tokens updated successfully.

Note: “#” sign means that you need executed this command as root user.   
   
      2.   Setting System Parameters
     Edit the /etc/sysctl.conf and add the following lines.
     # vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
    :wq

 Note: You need reboot system or execute “SYSCTL –P” command to apply above setting

# sysctl –p

Edit the /etc/security/limits.conf file and add the following lines.
# vi /etc/security/limits.conf
oracle           soft    nproc   2047
oracle           hard    nproc   16384
oracle           soft    nofile  1024
oracle           hard    nofile  65536
                        :wq

     3.      Change the ownership and permission
   # chown –R oracle:oinstall /oraeng
   # chown  -R oracle:dba /disk*
   #chmod –R 777 /oraeng /disk*

     4.      Download and Install
1.      Download and Install required .RPM packages
Some additional packages are required for successful installation of Oracle software. To check whether required package are installed on your Operating System using Following command.

# rpm –q binutils compat-db compat-libstdc++-33 glibc glibc-devel glibc-headers gcc gcc-c++ libstdc++ gdbm make ksh elfutils-libelf sysstat libaio libaio-devel unixODBC libXp libXtst xorg-x11-utils –qf’%{name}.%{arch}\n’|sort

Output for 32 bit (i386) linuxversion:
binutils-2.15.92.0.2
compat-libstdc++-33-3.2.
compat-libstdc++-33-3.2.3 (32 bit)
elfutils-libelf-0.97
elfutils-libelf-devel-0.97
expat-1.95.7
gcc-3.4.6
gcc-c++-3.4.6
glibc-2.3.4-2.41
glibc-2.3.4-2.41 (32 bit)
glibc-common-2.3.4
glibc-devel-2.3.4
glibc-headers-2.3.4
libaio-0.3.105
libaio-0.3.105 (32 bit)
libaio-devel-0.3.105
libaio-devel-0.3.105 (32 bit)
libgcc-3.4.6
libgcc-3.4.6 (32-bit)
  libstdc++-3.4.6
libstdc++-3.4.6 (32 bit)
libstdc++-devel 3.4.6
make-3.80
pdksh-5.2.14
sysstat-5.0.5
unixODBC-2.2.11
unixODBC-2.2.11 (32 bit)
unixODBC-devel-2.2.11
unixODBC-devel-2.2.11 (32 bit)

                install the required packages using the rpm command;
                        # rpm –ivh <package_name>.rpm

2.      Download the Oracle 11g release 2 software from ORACLE WEBSITE.
Linux.x64_11gr2_database_1of2.zip
Linux.x64_11gr2_database_2of2.zip

        Extract the file using following command:
# cd /disk1
Disk1]# ls
Linux.x64_11gr2_database_1of2.zip
Linux.x64_11gr2_database_2of2.zip

Disk1]# unzip linux.x64_11gr2_database_1of2.zip
Disk1]# unzip linux.x64_11gr2_database_2of2.zip
Disk1]# ls
 Linux.x64_11gr2_database_1of2.zip
Linux.x64_11gr2_database_2of2.zip
Database
# xhost +
#su – oracle
]$ vi .bash_profile
export ORACLE_HOME=/oraeng/apps/oracle/product/11.2.0
export ORACLE_BASE=/oraeng/apps/oracle/product
export PATH=$ORACLE_HOME/bin:$PATH:.
 :wq
]$ . .bash_profile

3.      Start the Oracle Software Installation Process.
Now the system is prepared for Oracle Software Installation. To start the installation process execute the following commands: Now the system is prepared for oracle software installation. To start the Installation process execute the following commands:

]$ cd /disk1/database
Database]$./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 80 MB.   Actual 6206 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 2047 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-02-02_12-59-43AM. Please wait ...[oracle@dba10 database]$









































Click on Close
So here, Oracle 11gr2 Database Software Installation is completed.
Hopefully all the fresher know got an idea how to install linux and Oracle database software.
thank you

Please Comment

3 comments:

  1. Hi Sir,

    can you give me more detail about the installation here you using vmware iam you oracel virtual box can you post installation linux and oracle database installation on oracle virtual box

    thanks

    ReplyDelete
  2. Hi Brother,
    Nice Blog will keep it up

    ReplyDelete
  3. Aasalamwalikum khadri bhai
    nice blog usefull for beginers keet it up
    best of luck

    ReplyDelete