Most production database and e-business suite application servers do not allow access to the public-yum repository. If your company happens to be super secure, they may not even allow the development servers to access any of the servers outside their local network. The following set of instructions are instrumental if you happen to fall into either one of these situations.

In this blog, I will step you through the process to provision an E-Business Suite application server. The steps are incredibly easy and allows you to leverage the existing DVD or ISO image that we downloaded from edelivery.oracle.com. We assume that you have already installed Oracle Enterprise 5 Update 10 but these examples are applicable to any flavor of Oracle Linux 5/6 or even Red Hat 5/6 operating systems (not as clean cut but stay tuned as we will show you how you can do this). We strongly encourage the minimalistic installation of Linux. Not only does it make your environment more secure, but it also makes your environment easier to manage and update/upgrade. In addition, we assume that you have downloaded the EBS Pre Installation RPMs and required prerequisites from the
Linux Preparation for Oracle E-Business Suite R12 Installation blog article.

We heavily leverage yum so that we can easily mitigate the issues with RPM dependencies and install the RPMs that we need without issues. We start the process by building a local yum repository from the DVD image. First mount the DVD:

————————————————————————————————————————

# cd /mnt
# mkdir oel510
# mount /dev/cdrom /mnt/oel510 -t iso9660 -o ro

————————————————————————————————————————
Second, view the file that we need to create a local yum repository of the DVD

# cat /mnt/oel510/.discinfo

[root@ebs2 yum.repos.d]# cat /mnt/oel510/.discinfo
1380762881.301333
Oracle Linux Server 5.10
x86_64
1,2,3,4,5
Server/base
Server/RPMS
Server/pixmaps

————————————————————————————————————————
Leveraging the mediaid number from the DVD .discinfo file, we can create a custom repo file in /etc/yum.repos.d

[root@ebs2 yum.repos.d]# cat vna.repo
[viscosity]
mediaid=1380762881.301333
name=Local Viscosity Repo
baseurl=file:///mnt/oel510/Server
enabled=1
gpgcheck=no

————————————————————————————————————————————————————————————
Test our local yum repository by installing the libXp RPM. This happens to be a required prerequisite for the openmotif21 RPM so we will kill two birds with one stone.

[root@ebs2 yum.repos.d]# yum install libXp
Loaded plugins: rhnplugin, security
This system is not registered with ULN.
You can use up2date --register to register.
ULN support will be disabled.
viscosity                                                                                        | 1.1 kB     00:00     
viscosity/primary                                                                                | 1.5 MB     00:00     
viscosity                                                                                                     3365/3365
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package libXp.i386 0:1.0.0-8.1.el5 set to be updated
---> Package libXp.x86_64 0:1.0.0-8.1.el5 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================
 Package                  Arch                      Version                          Repository                    Size
========================================================================================================================
Installing:
 libXp                    i386                      1.0.0-8.1.el5                    viscosity                     22 k
 libXp                    x86_64                    1.0.0-8.1.el5                    viscosity                     23 k

Transaction Summary
========================================================================================================================
Install       2 Package(s)
Upgrade       0 Package(s)

Total download size: 45 k
Is this ok [y/N]: y
Downloading Packages:
------------------------------------------------------------------------------------------------------------------------
Total                                                                                    35 MB/s |  45 kB     00:00     
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : libXp                                                                                            1/2 
  Installing     : libXp                                                                                            2/2 

Installed:
  libXp.i386 0:1.0.0-8.1.el5                                libXp.x86_64 0:1.0.0-8.1.el5                               

Complete!

————————————————————————————————————————————————————————————
Install the 2 RPMs that are prerequisites for the Oracle EBS Pre Install RPM. We will leverage the rpm -ihv command to manually install the two RPMs:

[root@ebs2 ~]# rpm -ihv openmotif21-2.1.30-11.EL5.i386.rpm xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm
Preparing...                ########################################### [100%]
   1:xorg-x11-libs-compat   ########################################### [ 50%]
   2:openmotif21            ########################################### [100%]

————————————————————————————————————————
Important Notes:
1. yum local install or yum install will fail due to missing public key check
warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Public key for oracle-ebs-server-R12-preinstall-1.0.0-4.el5.x86_64.rpm is not installed
2. You can still leverage the oracle-ebs-server-R12-preinstall-1.0.0-4.el5.x86_64.rpm but need to add an option to the yum command to disable gpg signature checking. Issue the “yum -h” command for all the options.

————————————————————————————————————————
Leveraging the oracle-ebs-server-R12-preinstall-1.0.0-4.el5.x86_64.rpm and with the localinstall option, we will be able to fully take advantage of the EBS pre install RPM even if our EBS server does not have access to the public yum repository:

[root@ebs2 ~]# yum --nogpgcheck localinstall  oracle-ebs-server-R12-preinstall-1.0.0-4.el5.x86_64.rpm
Loaded plugins: rhnplugin, security
This system is not registered with ULN.
You can use up2date --register to register.
ULN support will be disabled.
Setting up Local Package Process
Examining oracle-ebs-server-R12-preinstall-1.0.0-4.el5.x86_64.rpm: oracle-ebs-server-R12-preinstall-1.0.0-4.el5.x86_64
Marking oracle-ebs-server-R12-preinstall-1.0.0-4.el5.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package oracle-ebs-server-R12-preinstall.x86_64 0:1.0.0-4.el5 set to be updated
--> Processing Dependency: /usr/bin/odbcinst for package: oracle-ebs-server-R12-preinstall
--> Processing Dependency: /usr/lib/gcc/i386-redhat-linux/4.1.1/libstdc++.a for package: oracle-ebs-server-R12-preinstall
Importing additional filelist information
--> Processing Dependency: /usr/lib/libaio.so for package: oracle-ebs-server-R12-preinstall
--> Processing Dependency: /usr/lib/libc.so for package: oracle-ebs-server-R12-preinstall
--> Processing Dependency: /usr/lib/libodbccr.so for package: oracle-ebs-server-R12-preinstall
--> Processing Dependency: /usr/lib64/libodbccr.so for package: oracle-ebs-server-R12-preinstall
--> Processing Dependency: elfutils-libelf-devel for package: oracle-ebs-server-R12-preinstall
--> Processing Dependency: elfutils-libelf-devel-static for package: oracle-ebs-server-R12-preinstall
--> Processing Dependency: gcc for package: oracle-ebs-server-R12-preinstall
--> Processing Dependency: gcc-c++ for package: oracle-ebs-server-R12-preinstall
--> Processing Dependency: glibc-devel for package: oracle-ebs-server-R12-preinstall
--> Processing Dependency: glibc-headers for package: oracle-ebs-server-R12-preinstall
--> Processing Dependency: libaio-devel for package: oracle-ebs-server-R12-preinstall
--> Processing Dependency: libgdbm.so.2 for package: oracle-ebs-server-R12-preinstall
--> Processing Dependency: libstdc++-devel for package: oracle-ebs-server-R12-preinstall
--> Processing Dependency: sysstat for package: oracle-ebs-server-R12-preinstall
--> Processing Dependency: xorg-x11-xinit for package: oracle-ebs-server-R12-preinstall
--> Running transaction check
---> Package elfutils-libelf-devel.x86_64 0:0.137-3.el5 set to be updated
---> Package elfutils-libelf-devel-static.x86_64 0:0.137-3.el5 set to be updated
---> Package gcc.x86_64 0:4.1.2-54.el5 set to be updated
---> Package gcc-c++.x86_64 0:4.1.2-54.el5 set to be updated
---> Package gdbm.i386 0:1.8.0-28.el5 set to be updated
---> Package glibc-devel.i386 0:2.5-118 set to be updated
---> Package glibc-headers.x86_64 0:2.5-118 set to be updated
--> Processing Dependency: kernel-headers >= 2.2.1 for package: glibc-headers
--> Processing Dependency: kernel-headers for package: glibc-headers
---> Package libaio-devel.i386 0:0.3.106-5 set to be updated
---> Package libstdc++-devel.i386 0:4.1.2-54.el5 set to be updated
---> Package sysstat.x86_64 0:7.0.2-12.0.1.el5 set to be updated
---> Package unixODBC.x86_64 0:2.2.11-10.el5 set to be updated
--> Processing Dependency: unixODBC-libs = 2.2.11-10.el5 for package: unixODBC
--> Processing Dependency: libodbcinst.so.1()(64bit) for package: unixODBC
--> Processing Dependency: libodbc.so.1()(64bit) for package: unixODBC
---> Package unixODBC-devel.i386 0:2.2.11-10.el5 set to be updated
--> Processing Dependency: libtdsS.so.1 for package: unixODBC-devel
--> Processing Dependency: liboraodbcS.so.1 for package: unixODBC-devel
--> Processing Dependency: libesoobS.so.1 for package: unixODBC-devel
--> Processing Dependency: libboundparam.so.1 for package: unixODBC-devel
--> Processing Dependency: libodbcnnS.so.1 for package: unixODBC-devel
--> Processing Dependency: libodbcminiS.so.1 for package: unixODBC-devel
--> Processing Dependency: liboplodbcS.so.1 for package: unixODBC-devel
--> Processing Dependency: libmimerS.so.1 for package: unixODBC-devel
--> Processing Dependency: libodbcdrvcfg1S.so.1 for package: unixODBC-devel
--> Processing Dependency: libgtrtst.so.1 for package: unixODBC-devel
--> Processing Dependency: libsapdbS.so.1 for package: unixODBC-devel
--> Processing Dependency: libodbctxtS.so.1 for package: unixODBC-devel
--> Processing Dependency: libodbccr.so.1 for package: unixODBC-devel
--> Processing Dependency: libnn.so.1 for package: unixODBC-devel
--> Processing Dependency: libodbcinst.so.1 for package: unixODBC-devel
--> Processing Dependency: libtemplate.so.1 for package: unixODBC-devel
--> Processing Dependency: libodbcdrvcfg2S.so.1 for package: unixODBC-devel
---> Package unixODBC-devel.x86_64 0:2.2.11-10.el5 set to be updated
---> Package xorg-x11-xinit.x86_64 0:1.0.2-15.el5 set to be updated
--> Processing Dependency: xauth for package: xorg-x11-xinit
--> Running transaction check
---> Package kernel-headers.x86_64 0:2.6.18-371.el5 set to be updated
---> Package unixODBC-libs.i386 0:2.2.11-10.el5 set to be updated
---> Package unixODBC-libs.x86_64 0:2.2.11-10.el5 set to be updated
---> Package xorg-x11-xauth.x86_64 1:1.0.1-2.1 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================
 Package                          Arch   Version             Repository                                            Size
========================================================================================================================
Installing:
 oracle-ebs-server-R12-preinstall x86_64 1.0.0-4.el5         /oracle-ebs-server-R12-preinstall-1.0.0-4.el5.x86_64  63 k
Installing for dependencies:
 elfutils-libelf-devel            x86_64 0.137-3.el5         viscosity                                             24 k
 elfutils-libelf-devel-static     x86_64 0.137-3.el5         viscosity                                             64 k
 gcc                              x86_64 4.1.2-54.el5        viscosity                                            5.3 M
 gcc-c++                          x86_64 4.1.2-54.el5        viscosity                                            3.8 M
 gdbm                             i386   1.8.0-28.el5        viscosity                                             28 k
 glibc-devel                      i386   2.5-118             viscosity                                            2.1 M
 glibc-headers                    x86_64 2.5-118             viscosity                                            601 k
 kernel-headers                   x86_64 2.6.18-371.el5      viscosity                                            1.5 M
 libaio-devel                     i386   0.3.106-5           viscosity                                             12 k
 libstdc++-devel                  i386   4.1.2-54.el5        viscosity                                            2.8 M
 sysstat                          x86_64 7.0.2-12.0.1.el5    viscosity                                            188 k
 unixODBC                         x86_64 2.2.11-10.el5       viscosity                                            291 k
 unixODBC-devel                   i386   2.2.11-10.el5       viscosity                                            738 k
 unixODBC-devel                   x86_64 2.2.11-10.el5       viscosity                                            793 k
 unixODBC-libs                    i386   2.2.11-10.el5       viscosity                                            551 k
 unixODBC-libs                    x86_64 2.2.11-10.el5       viscosity                                            554 k
 xorg-x11-xauth                   x86_64 1:1.0.1-2.1         viscosity                                             32 k
 xorg-x11-xinit                   x86_64 1.0.2-15.el5        viscosity                                             26 k

Transaction Summary
========================================================================================================================
Install      19 Package(s)
Upgrade       0 Package(s)

Total size: 19 M
Total download size: 19 M
Is this ok [y/N]: y
Downloading Packages:
------------------------------------------------------------------------------------------------------------------------
Total                                                                                   4.7 GB/s |  19 MB     00:00     
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : unixODBC-libs                                                                                   1/19 
  Installing     : unixODBC                                                                                        2/19 
  Installing     : xorg-x11-xauth                                                                                  3/19 
  Installing     : xorg-x11-xinit                                                                                  4/19 
  Installing     : sysstat                                                                                         5/19 
  Installing     : gdbm                                                                                            6/19 
  Installing     : unixODBC-libs                                                                                   7/19 
  Installing     : libstdc++-devel                                                                                 8/19 
  Installing     : unixODBC-devel                                                                                  9/19 
  Installing     : unixODBC-devel                                                                                 10/19 
  Installing     : kernel-headers                                                                                 11/19 
  Installing     : glibc-headers                                                                                  12/19 
  Installing     : glibc-devel                                                                                    13/19 
  Installing     : libaio-devel                                                                                   14/19 
  Installing     : gcc                                                                                            15/19 
  Installing     : gcc-c++                                                                                        16/19 
  Installing     : elfutils-libelf-devel                                                                          17/19 
  Installing     : elfutils-libelf-devel-static                                                                   18/19 
  Installing     : oracle-ebs-server-R12-preinstall                                                               19/19 

Installed:
  oracle-ebs-server-R12-preinstall.x86_64 0:1.0.0-4.el5                                                                 

Dependency Installed:
  elfutils-libelf-devel.x86_64 0:0.137-3.el5              elfutils-libelf-devel-static.x86_64 0:0.137-3.el5             
  gcc.x86_64 0:4.1.2-54.el5                               gcc-c++.x86_64 0:4.1.2-54.el5                                 
  gdbm.i386 0:1.8.0-28.el5                                glibc-devel.i386 0:2.5-118                                    
  glibc-headers.x86_64 0:2.5-118                          kernel-headers.x86_64 0:2.6.18-371.el5                        
  libaio-devel.i386 0:0.3.106-5                           libstdc++-devel.i386 0:4.1.2-54.el5                           
  sysstat.x86_64 0:7.0.2-12.0.1.el5                       unixODBC.x86_64 0:2.2.11-10.el5                               
  unixODBC-devel.i386 0:2.2.11-10.el5                     unixODBC-devel.x86_64 0:2.2.11-10.el5                         
  unixODBC-libs.i386 0:2.2.11-10.el5                      unixODBC-libs.x86_64 0:2.2.11-10.el5                          
  xorg-x11-xauth.x86_64 1:1.0.1-2.1                       xorg-x11-xinit.x86_64 0:1.0.2-15.el5                          

Complete!

For additional insight into preparing an EBS server, please visit this blog entry:
Linux Preparation for Oracle E-Business Suite R12 Installation

For insight into building Oracle Linux 6 server, please visit this blog entry:
Oracle Linux 6 Installation and Configuration Step-By-Step


Comments are closed