Visit Counter

Wednesday, August 9, 2017

Installing Oracle EBS 12.1.1 on Oracle Linux 6 (64-bit)

Env:

EBS: 12.1.1
O/S:  Oracle Linux 6 (64-bit)
-------------------------------------------

Prerequisites:

  • Edit ‘/etc/hosts’ file and add the hostname in the below shown format

[root@apps12 rapidwiz]# cat /etc/hosts



127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1              localhost localhost.localdomain localhost6 localhost6.localdomain6

192.0.0.28 apps12.ora.com apps12

[root@apps12 rapidwiz]#

---------------------------------------------------------------------------------------------------------

  • Edit the /etc/sysctl.conf file and configure the kernel settings as shown below. After editing the file, use the
  •  “sysctl -p” command or restart the system to invoke the new settings.


[root@apps12 rapidwiz]# cat /etc/sysctl.conf
# Kernel sysctl configuration file for Oracle Linux
#
# For binary values, 0 is disabled, 1 is enabled.  See sysctl(8) and
# sysctl.conf(5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
net.ipv4.conf.default.rp_filter = 1

# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0

# Controls whether core dumps will append the PID to the core filename.
# Useful for debugging multi-threaded applications.
kernel.core_uses_pid = 1

# Controls the use of TCP syncookies
net.ipv4.tcp_syncookies = 1

# Disable netfilter on bridges.
net.bridge.bridge-nf-call-ip6tables = 0
net.bridge.bridge-nf-call-iptables = 0
net.bridge.bridge-nf-call-arptables = 0

kernel.shmall = 2097152
kernel.shmmax = 5203054592
kernel.shmmni = 4096
kernel.sem = 256 32000 100 142
fs.file-max = 9815744
net.ipv4.ip_local_port_range = 10000 65000
kernel.msgmni = 2878
fs.aio-max-nr = 1048576
kernel.msgmax = 8192
kernel.msgmnb = 65535
net.core.rmem_default = 10485762
net.core.wmem_default = 10485762
net.core.rmem_max = 4194304
net.core.wmem_max = 10485762


[root@apps12 rapidwiz]#  /etc/sysctl.conf/sysctl -p

----------------------------------------------------------------------------------------------------------------


  • Edit the /etc/security/limits.conf file and change the existing values for “hard” and “soft” parameters as below.

hard nofile 65536
soft nofile 4096
hard nproc 16384
soft nproc 2047
hard stack 16384
soft stack 10240


-------------------------------------------------------------------------------------------------


  • Two Domain Name System (DNS) resolver parameters (timeout and attempts) are set by default to low values when the operating system is installed. These low values may cause attempted network connections to an Oracle database to fail. Add or update the following entries to these minimum settings in the /etc/resolv.conf file.
options attempts:5
options timeout:15
-------------------------------------------------------------------------------------------------
Create oraInst.loc if not exists and add below entry.

[root@apps12 etc]# ls -l oraInst.loc
-rwxrwxrwx. 1 oracle dba  59 Jul 18 14:02 oraInst.loc


[root@apps12 etc]# cat oraInst.loc

inventory_loc=/ora/oracle/CRP/oraInventory
inst_group=dba

[root@apps12 etc]#


--------------------------------------------------------------------------------------------------
http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/


openmotif21-2.1.30-11.EL6.i686 (32-bit)
xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386
libXrender-0.9.5-1.el6.i686
binutils-2.20.51.0.2-5.20.el6.x86_64
compat-libstdc++-296-2.96-144.el6.i686
compat-libstdc++-33-3.2.3-69.el6.i686
gcc-4.4.5-6.el6.x86_64
gcc-c++-4.4.5-6.el6.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
libXtst-1.0.99.2-3.el6.i686
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
redhat-lsb-4.0-3.0.1.el6.x86_64
sysstat-9.0.4-11.el6.x86_64
util-linux-ng-2.17.2-6.el6.x86_64
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.i686
libaio-devel-0.3.107-10.el6.x86_64
unixODBC-2.2.14-11.el6.i686
unixODBC-devel-2.2.14-11.el6.i686
xorg-x11-utils-7.4-8.el6.x86_64







---------------------------------------------------------------------------------------------------
  • Create users and assign default groups as shown below. ‘oracle‘ user is the owner of database tier and ‘applmgr‘ is the owner of application tier and these users belong to ‘dba’ group. We follow these notations through out the installation process. Also create required directories and change permissions as shown below.


# groupadd dba
useradd -g dba oracle
useradd -g dba applmgr
mkdir /ora/apps121stage
chmod -R 777 oracle:dba /ora/apps121stage
chown -R oracle:dba /ora/apps121stage
chgrp -R dba /ora/apps121stage





Error: 


AC-00402: Unable to read driver file: /opt/oracrp/db/tech_st/11.1.0/appsutil/template/addbtmpl.drv


Solution:

First of all rename the unzip version 6 because unzip ver 6 does not support staging of EBS 12.1.1 so we need download and install ver 5 for staging EBS 12.1.1

Rename the unzip version 6

# mv /usr/bin/unzip  /usr/bin/unzip6

Download unzip version 5 for staging below the steps

https://oss.oracle.com/el4/unzip/unzip.html

unzip utility
unzip-5.51-10.el5.src.rpm

Installation

  • Download tar archive containing unzip utility
  • Extract the unzip utility from the tar file
  • # tar -xf unzip.tar
  • Copy this utility to /usr/local/bin

  • Provide execute permission to downloaded file using command :
  • # chmod +x /usr/local/bin/unzip
  • Make sure you run unzip as /usr/local/bin/unzip


Creating Staging Area (All Zip files in apps121stage folder)


 # cd /ora/apps121stage

 # unzip \*.zip


[root@apps12 apps121stage]# pwd
/ora/apps121stage

[root@apps12 apps121stage]# ls

oraAppDB oraApps oraAS oraDB startCD 

B53824-01_1of4.zip  V15680-01_1of3.zip  V15684-01_1of3.zip  V15688-01_1of2.zip
B53824-01_2of4.zip  V15680-01_2of3.zip  V15684-01_2of3.zip  V15688-01_2of2.zip
B53824-01_3of4.zip  V15680-01_3of3.zip  V15684-01_3of3.zip  V15689-01.zip
B53824-01_4of4.zip  V15681-01_1of3.zip  V15685-01_1of3.zip  V15690-01_1of3.zip
V15681-01_2of3.zip  V15685-01_2of3.zip  V15690-01_2of3.zip
V15681-01_3of3.zip  V15685-01_3of3.zip  V15690-01_3of3.zip
V15682-01_1of3.zip  V15686-01_1of3.zip  V15691-01_1of3.zip
V15682-01_2of3.zip  V15686-01_2of3.zip  V15691-01_2of3.zip
V15682-01_3of3.zip  V15686-01_3of3.zip  V15691-01_3of3.zip
V15679-01_1of3.zip  V15683-01_1of3.zip  V15687-01_1of3.zip
V15679-01_2of3.zip  V15683-01_2of3.zip  V15687-01_2of3.zip
V15679-01_3of3.zip  V15683-01_3of3.zip  V15687-01_3of3.zip

[root@apps12 apps121stage]#


[root@apps12 rapidwiz]# pwd

/ora/apps121stage/startCD/Disk1/rapidwiz

[root@apps12 rapidwiz]# ls

adautostg.pl   driver  images  oui           RapidWiz.ini         template
bin            etc     jlib    rapidwiz      RapidWizVersion      unzip
ClientWiz.cmd  File    jre     RapidWiz.cmd  RapidWizVersion.cmd


[root@apps12 rapidwiz]# ./rapidwiz





















 http://apps.ora.com:8000















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



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






/ora/apps121/PROD/inst/apps/PROD_apps12/logs


HTTP

-----
   checking URL = http://apps12.ora.com:8000

   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.
Help Page

----------
   checking URL = http://apps12.ora.com:8000/OA_HTML/help

   RW-50015: Error: - Help Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Virtual Directory

------------------
   RW-50015: Error: - Http Server Virtual Directories is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
JSP

----
   checking URL = http://apps12.ora.com:8000/OA_HTML/jtfTestCookie.jsp

   RW-50015: Error: - JSP is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Login Page

-----------
   RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
[root@apps12 logs]#





Checking Application status :-
=================================================================



At last steps of Installation during validating system configuration it failed on HTTP, loginpage, Help Directory and JSP.
When checked all services were up and running except web server.
checking status of OPMN managed processes…
Processes in Instance: PROD_ebs.ebs.ORACLE.com

———————————+——————–+———+———
ias-component                    | process-type       |     pid | status
———————————+——————–+———+———
OC4JGroup:default_group          | OC4J:oafm          |   13776 | Alive
OC4JGroup:default_group          | OC4J:forms         |   13703 | Alive
OC4JGroup:default_group          | OC4J:oacore       |   13617 | Alive
HTTP_Server                              | HTTP_Server       |   13560 | Down

Http_server is shown as Down.


===============================================================

 Due to missing library.  /usr/lib/libdb.so.2
if you got this type of error then you can take a new terminal and Down the all application services and follow below steps.








Solution:=
================================================================ 
* Shut DB services. (Database User oracle)

$ cd /ora/apps121/PROD/db/tech_st/11.1.0/appsutil/scripts/PROD_apps12

$./addlnctl.sh

$./addbctl.sh stop


Shut Application Services (Application user appsmgr)

/ora/apps121/PROD/inst/apps/PROD_apps12/admin/scripts

./adstpall.sh apps/apps


* create the below link for library file 


  root  ]# ln -s   /usr/lib/libgdbm.so.2.0.0  /usr/lib/libdb.so.2


# vi  /etc/selinux/config

change the SELINUX=enforcing


* Startup all application services. And press the Retry button 
 
after  check the oacore status


./addlnctl.sh start PROD

./addbctl.sh start

./adstrtal.sh start




[root@apps12 scripts]#  ./adoacorectl.sh status

You are running adoacorectl.sh version 120.13

Checking status of OPMN managed OACORE OC4J instance ...

Processes in Instance: PROD_apps12.apps12.ora.com
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group          | OC4J:oafm          |     715 | Alive
OC4JGroup:default_group          | OC4J:forms         |     644 | Alive
OC4JGroup:default_group          | OC4J:oacore        |     559 | Alive
HTTP_Server                              | HTTP_Server        |     502 | Alive


adoacorectl.sh: exiting with status 0

adoacorectl.sh: check the logfile /ora/apps121/PROD/inst/apps/PROD_apps12/logs/appl/admin/log/adoacorectl.txt for more information ...

[root@apps12 scripts]#