Saturday, April 30, 2016

ORACLE 11gR2 INSTALLATION ON RHEL 5.6 USING VMWARE WORKSTATION-GUI Mode

STEPS FOR INSTALLING ORACLE 11gR2 DB SERVER:

  • Download Oracle DB Server and Prepare it to Install
  • Check OS level Parameters Required
  • Kernel Parameters Setup
  • Security Limits Setup
  • RPM Packages Installation for Oracle
  • Users and Groups creation
  • Directories and Permissions Setup
  • Install RDBMS (Oracle DB Server) software
  • Check the Installed RDBMS software

Downloading Oracle DB Server software and Prepare it ready to Install:

Download the software from the below given Links..


From anyone of those links, we can get the oracle software as two seperate .zip files as below

      Linux.x64_11gR2_database_1of2.zip
      Linux.x64_11gR2_database_2of2.zip

Now we have to goto that files location and Unzip those files

      $unzip *.zip


Then we can get a single directory for those two files named as "database"

      $cd database
      $ls
      $cd


Checking OS level Parameters Required:

 Before the Oracle software, We have to know about our Operating System.

To Know about the Flavour and Version of OS, use below commands


$cat  /etc/* release
$cat  /etc/redhat-release
$uname  -r
$uname  -a
$lsb_release  -a



To know the Bit Version of the Operating System whehter it is 32-bit or 64-bit

      $getconf  LONG_BIT



To work with the Oracle databse, we require minimum 1GB RAM atleast. To know about the allocated RAM size

     $cat  /proc/meminfo  |  grep memtotal



To know the currently allocated SWAP size

     $cat  /proc/meminfo  |  grep swaptotal



While Installing Oracle software, the TEMP space must be available about 5GB. So to check the available tmp space

    $df -h /tmp


To check the mount point size where  you want the oracle software

    $df -h /uo1


Kernel Parameter Setup:

-          Automatic Setup(From Online)

           #yum  install  oracle-validated
           #yum  update

                           ( OR )

-          Manual Setup

          #vi   /etc/sysctl.conf

                        #(Add the following lines in this file)
fs.suid_dumpable = 1
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
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!

-          Run the following command to change the current kernel parameters

            # /sbin/sysctl   -p


   Security Limits Setup:


-          Add the following lines to the below file

            #vi  /etc/security/limits.conf
oracle              soft     nproc   2047
oracle              hard    nproc   16384
oracle              soft     nofile   4096
oracle              hard    nofile   65536
oracle              soft     stack    10240
            :wq!




   RPM Packages Installation for Oracle:


-          Install the following RPM packages, If they are not already present

-          From Oracle Linux 5 DVD


#cd /media/cdrom/Server

#rpm -Uvh binutils-2.*
#rpm -Uvh compat-libstdc++-33*
#rpm -Uvh compat-libstdc++-33*.i386.rpm
#rpm -Uvh elfutils-libelf*
#rpm -Uvh gcc-4.*
#rpm -Uvh gcc-c++-4.*
#rpm -Uvh glibc-2.*
#rpm -Uvh glibc-common-2.*
#rpm -Uvh glibc-devel-2.*
#rpm -Uvh glibc-headers-2.*
#rpm -Uvh ksh*
#rpm -Uvh libaio-0.*
#rpm -Uvh libaio-devel-0.*
#rpm -Uvh libgomp-4.*
#rpm -Uvh libgcc-4.*
#rpm -Uvh libstdc++-4.*
#rpm -Uvh libstdc++-devel-4.*
#rpm -Uvh make-3.*
#rpm -Uvh sysstat-7.*
#rpm -Uvh unixODBC-2.*
#rpm -Uvh unixODBC-devel-2.*
#rpm -Uvh numactl-devel-*

#cd /
eject


   Users and Groups creation:


        #groupadd  oinstall

        #groupadd  dba
              
        #useradd  -g  oinstall  -G  dba  oracle

        #password  oracle


   Directories and Permissions Setup:


        #chmod    -R   777   /u01
        #chown   -R   oracle:oinstall   /u1
        #mkdir   -p   /u01/app/oracle/product/11.2.0/db_1
        #xhost   +    
        #su   -oracle

        $ vi   .bash_profile
export  ORACLE_BASE=/u01/app/oracle;  
export  ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; 
export  PATH=$ORACLE_HOME/bin:$PATH;   
export  LD_LIBRARY_PATH=$ORACLE_HOME/lib; 
       :wq!
$

   Install RDBMS (Oracle DB Server) Software:

-       Goto  the  directory  “database” where the oracle software is kept ready by unzipping the 2 software files above.

-          Start the Oracle Universal Installer (OUI) by issuing the following command in the “database” directory.


            $cd  database/

            $ .  /runInstaller

-          From here onwords, we get the installation process as Graphically..



-          For above window, uncheck the “Security Upadates” option  and then click on NEXT.


-          Select  ‘Create and Configure a database’ option and then click  on  NEXT.





-          Check  “Ignore all” option from right side top of window and then click NEXT.

-          Now Click on FINISH button.







-          Click on OK button of POPUP window.






-          We must Execute the above 2 Scripts as a ROOT users

    #/u01/app/oraInventory/orainstRoot.sh
    #/u01/app/oracle/product/11.2.0/dbhome_1/root.sh


-          Now click on the CLOSE button.
-          Now check the Oracle DB Server is installed or not
    
         #find  /  -name  oraInst*
  
       oraInst.loc  file shows the location of inventory files. There are 2 types of Inventory files are      there.They are
               

1.  Gloabal Inventory

It contains the consolidated information about all the oracle db server softwares installed on this machine.

There is only one Gloabal Inventory file for the entire server.

$cat  oraInst.loc
$cd  /home/oracle/oraInventory
$ls
$cd  contentsXML/
$ls
$cat  inventory.xml



2. Local Inventory

It contains the information about all the components which are being installed with the certain oracle product.

The name of the local inventory is  conps.xml

The location of the local inventory is specified by ORACLE_HOME.


$cd  conps.xml


No comments:

Post a Comment