Oracle EBS R12.1 Installation and Implementation on Aws Ec2 Instance

 

Oracle E-Business Suite R12 Installation on Linux

 

Majors to be taken care for avoiding Errors during Installation:

ERRORS: R12 Rapid Install Failing With "RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported." (Doc ID 1455077.1)

 

Solution:  mv /usr/bin/unzip /usr/bin/unzip-ver6

 

RW-50015: Error: - HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button. (Doc ID 879522.1)

 

Solution: Create the below link for library file:   # ln -s   /usr/lib/libgdbm.so.2.0.0  /usr/lib/libdb.so.2

System Requirement:

The installation size of Oracle E-Business Suite R12.1.1 is:

Ø  90 GB for a fresh install with a production database.

Ø  Application tier file system – 35 GB (For HP-UX Itanium 50 Gb)
Database tier file system – 55 GB

Ø  Disk space 200 GB free hard disk space and 4 GB RAM.

 

Ø  Download the Oracle E-Business Suite R12:

From http://edelivery.oracle.com site the latest version

 

·         Oracle E-Business Suite R12.1 setup files almost have 45.3 GB size.

 

 

Ø  In Aws Cloud EC2 Instance :

ü   Operating System - Red Hat Enterprise Linux 6.10(Santiago).

ü   RAM         – 15 GB

ü  Swap Space – 31 GB

ü  Mount Point - /u01 ->100 GB for Database and Apps.

    - /Staging -> 99 GB for creating Staging Area.

 

Kernel Requirements:

Oracle Linux 6* Red Hat Enterprise Linux 6*	Install the required RPM’s: RPM for Oracle EBS can be installed using yum. cd /etc/yum.repos.d wget http://public-yum.oracle.com/public-yum-ol6.repo Using a text editor or vi command in terminal, edit the following entries in the file /etc/yum.repos.d/public-yum-ol6.repo [ol6_latest] name=Oracle Linux $releasever Latest ($basearch) baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/$basearch/ gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 gpgcheck=1 enabled=1 [ol6_addons] name=Oracle Linux $releasever Add ons ($basearch) baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/addons/$basearch/ gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 gpgcheck=1 enabled=1 [ol6_UEK_latest] name=Latest Unbreakable Enterprise Kernel for Oracle Linux $releasever ($basearch) baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/UEK/latest/$basearch/ gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 gpgcheck=1 enabled=1 Update all packages and then install the pre-install rpm by running the following yum commands:      yum update  yum install oracle-ebs-server-R12-preinstall
	Ensure the following RPMs are installed: If not using the pre-install rpm, the following packages (or versions of packages) are not part of the OS distribution media and must be downloaded separately (from http://oss.oracle.com/projects/compatoracle/ files/Enterprise Linux/) for both Oracle Linux 6 and RHEL 6 and installed manually on the application tier:   openmotif21-2.1.30-11.EL6.i686 (32-bit)1 xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386 (32-bit)   Additionally, the following rpm needs to be installed from the Oracle Linux 6 or RHEL 6 distribution media on the application tier:   libXrender-0.9.5-1.el6.i686   If not using the pre-install rpm, the following packages must be installed from the Oracle Linux 6 or RHEL 6 distribution media on both the application and database tiers:   binutils-2.20.51.0.2-5.11.el16.x86_64 compat-db43-4.3.29-15.el6.i686 gcc-4.4.4-13.el16.x86_64 gcc-c++-4.4.4-13.el16.x86_64 glibc-2.12-1.7.el6.i686 (32-bit) glibc-2.12-1.7.el6.x86_64 glibc-common-2.12-1.7.el6.x86_64 glibc-devel-2.12-1.7.el6.i686 (32-bit) glibc-devel-2.12-1.7.el6.x86_64 libgcc-4.4.4-13.el6.i686 libgcc-4.4.4-13.el6.x86_64 libstdc++-devel-4.4.4-13.el6.i686 libstdc++-devel-4.4.4-13.el6.x86_64 libstdc++-4.4.4-13.el6.i686 libstdc++-4.4.4-13.el6.x86_64 libXi-1.3-3.el6.i686 libXp-1.0.0-15.1.el6.i686 libXp-1.0.0-15.1.el6.x86_64 libaio-0.3.107-10.el6.i686 libaio-0.3.107-10.el6.x86_64 libgomp-4.4.4-13.el6.x86_64 make-3.81-19.el6.x86_64 gdbm-1.8.0-36.el6.i686 gdbm-1.8.0-36.el6.x86_64 sysstat-9.0.4-11.el6.x86_64 util-linux-ng-2.17.2-6.el6.x86_64 unzip-5.52-3.0.1.el5.x86_642 compat-libstdc++-296-2.96-144.el6.i686 compat-libstdc++-33-3.2.3-69.el6.i686   Additionally, the following RPMs are required for the database tier running 11gR2 (users must upgrade the bundled 11gR1 DB to 11gR2 either before or after installing 12.1) on the database tier:   compat-libcap1-1.10-1.x86_64 compat-libstdc++-33-3.2.3-69.el6.x86_64 elfutils-libelf-devel-0.148.1-el6.x86_64 libaio-devel-0.3.107-10.el6.x86_64 unixODBC-2.2.14-11.el6.i686 unixODBC-devel-2.2.14-11.el6.i686 unixODBC-2.2.14-11.el6.x86_64 unixODBC-devel-2.2.14-11.el6.x86_64
	This unzip package (available from EL 6 distribution) is only required for purposes of running Rapid Install to unzip the required EBS files as part of the installation and should be reverted after the install of EBS.   mv /usr/bin/unzip  /usr/bin/unzip-ver6   After installing the RPM’s, restart machine then run following command to link all libraries “ldconfig -v” to create necessary links and cache to the most recent shared libraries. ldconfig -v

 Configure hostname as per EBS guideline:

ü  Vi  /etc/hosts & /etc/sysconfig/network ü  cat /etc/sysconfig/network HOSTNAME=ebsnode12.ebs12wizer.com   ü  cat /etc/hosts 127.0.0.1           localhost.localdomain   localhost 172.31.22.57    ebsnode12.ebs12wizer.com      ebsnode12

Change SELINUX as follows and Restart Machine to take changes to effect:

        

ü  cat /etc/selinux/config SELINUX=Disabled

Stop the iptables service:

         

ü  service iptables stop ü  chkconfig iptables off ü  service ip6tables stop ü  chkconfig ip6tables off

  

Configure Kernel parameters:

ü  cat /etc/sysctl.conf

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 fs.aio-max-nr = 1048576 net.ipv4.tcp_tw_recycle = 0 kernel.shmall = 2097152 kernel.shmmax = 4294967295 kernel.shmmni = 4096 kernel.sem = 256 32000 100 142 fs.file-max = 131072 net.ipv4.ip_local_port_range = 10000 65000 kernel.msgmni = 2878 kernel.msgmax = 8192 kernel.msgmnb = 65535 net.core.rmem_default = 262144 net.core.wmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_max = 262144   Run the following command to change the current kernel parameters:   ü  sysctl –p

Add the following lines to the “/etc/security/limits.conf” file:

cat /etc/security/limits.conf * hard nofile 65535 * soft nofile 4096 * hard nproc 16386 * soft nproc 2047

         Create Oracle Inventory Directory:

        

mkdir -p /u01/app/oracle/oraInventory cat /etc/oraInst.loc inventory_loc=/u01/app/oracle/oraInventory inst_group=oinstall

       Create Appropriate Users and Groups:

groupadd oinstall groupadd dba usermod -g oinstall -G dba oracle passwd oracle usermod -g oinstall -G dba applmgr passwd applmgr

    

   

Create Directory Structure and Change Ownership & Permissions:

cd /u01 ls –ltrh mkdir –p /u01/app chown -R oracle:oinstall /u01/app chmod -R 777 /u01/app ls -ltrh

v Creating Staging Area:

Unzip all the 40 downloaded files to create the stage.

         

Ø  Unzip –d  /location_of_directory filename.zip

 

  As root user execute the following command:        

 Installation of EBS R12.1.1:

 

Ø  cd /location/startCD/Disk1/rapidwiz

Ø  ./rapidwiz

                         

Click Next button. 

Select Install Oracle Applications Release 12.1.1 and click Next button. 

                            

                                              

                                            Click Next button.
                                                          

                                     

Select Create a new configuration then click Next button.

                                         

                                        

                                            Click Next button.

                                        

Write in the Base directory field /oradata then click Next button

Select Suite Licensing then click Next button.

Click Next button.

Write in the Base directory field /apps and in the Instance directory field /apps/inst then click Next button

Click Next button.

Review System checks

 

Click Next button.

Click Next button.

Click Yes button

Click Next button.

Click on Connect to Oracle Applications Release 12.1.1 then click Finish button.

Log to oracle applications using sysadmin user name and sysadmin password.

E-Business Suite services status check, start & stop procedure

1. Start Services 

a)    Db services (With Oracle User).

i)     Listener. cd/u01/app/oracle/db/tech_st/11.1.0/appsutil/scripts/PROD_ebsnode12/            ./addlnctl.sh start    ii)    Database.             cd /u01/app/oracle/db/tech_st/11.1.0/appsutil/scripts/PROD_ebsnode12/             ./addbctl.sh start instance_name

 

 

b)    Application services (With Root User).

 

i)     Apps Service.     cd /u01/app/oracle/inst/apps/PROD_ebsnode12/admin/scripts            ./adstrtal.sh apps/apps

 

2. Stop Services

 

a)    Db services (With Oracle User).

i)     Listener. cd /u01/app/oracle/db/tech_st/11.1.0/appsutil/scripts/PROD_ebsnode12/            ./addlnctl.sh stop   ii)   Database.            cd /u01/app/oracle/db/tech_st/11.1.0/appsutil/scripts/PROD_ebsnode12/            ./addbctl.sh stop instance_name

 

 

 

b)    Application services (With Root User).

i)     Apps Service.            cd /u01/app/oracle/inst/apps/PROD_ebsnode12/admin/scripts            ./adstpall.sh apps/apps

 

3. Status Check

 

i)  Database Status.             cd /u01/app/oracle/db/tech_st/11.1.0/appsutil/scripts/PROD_ebsnode12/             ./addbctl.sh status

 

ii) Application Status:      cd /u01/app/oracle/inst/apps/PROD_ebsnode12/admin/scripts      ./adoacorectl.sh status

==========END OF EBS R12.1.1 INSTALLATION==========

 

 

Reference:-  (Doc ID 761566.1)