adapcctl.sh failed to start with " failed to get an IP for the hostname" error in R12.2

This document describes how to resolve adapcctl.sh failing with " failed to get an IP for the hostname"

Issue:

You are running adapcctl.sh version 120.0.12020000.2

Starting OPMN managed Oracle HTTP Server (OHS) instance ...
opmnctl start: opmn is already running.
opmnctl startproc: starting opmn managed processes...
================================================================================
opmn id=ebsapps.apps.com:6200
Response: 0 of 1 processes started.

ias-instance id=EBS_web_PROD_OHS1
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
  EBS_web_PROD/OHS/OHS/

Error
--> Process (index=1,uid=374605334,pid=16020)
  failed to get an IP for the hostname
  failed to start a managed process after the maximum retry limit
  failed to get an IP for the hostname
  Log:
  /u01/app/applmgr/fs1/FMW_Home/webtier/instances/EBS_web_PROD_OHS1/diagnostics/logs/OHS/EBS_web_PROD/console~OHS~1.log


adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /u01/app/applmgr/fs1/inst/apps/PROD_ebsapps/logs/appl/admin/log/adapcctl.txt for more information ...


.end std out.

Cause: 127.0.0.1 is commented in /etc/hosts file. Due to that unable to find the IP address.

Solution: Uncomment 127.0.0.1 and Restart the services.

Before:

[root@ebsapps ~]# cat /etc/hosts

#127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

#::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.1.220 ebsapps.apps.com ebsapps

192.168.1.210 ebsdb.apps.com ebsdb

After:

[root@ebsapps ~]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

#::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.1.220 ebsapps.apps.com ebsapps

192.168.1.210 ebsdb.apps.com ebsdb

[applmgr@ebsapps scripts]$ adapcctl.sh start

You are running adapcctl.sh version 120.0.12020000.2

Starting OPMN managed Oracle HTTP Server (OHS) instance ...

opmnctl start: opmn is already running.

opmnctl startproc: starting opmn managed processes...

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /u01/app/applmgr/fs1/inst/apps/PROD_ebsapps/logs/appl/admin/log/adapcctl.txt for more information ...  

[applmgr@ebsapps scripts]$ 

Thanks for your patience to view this post.......

Oracle applications R12.2 installation in Linux Virtual Box

This document describes how to install Oracle Applications R12.2 in Linux 64 bit multiple nodes.

Steps:

1. Install Oracle Virtual machines (As per requirement. In my case 2 nodes)
2. System requirements
3. Prepare stage area
4. Install E-business sweet 12.2 software
5. Validate the installation

Hosts Information:

1. Install Oracle Virtual Box

Please click Here to know how install oracle virtual machine.

2. System Requirements

Install groups and users in all nodes

EBS_DB:

[root@ebsdb Softwares]# groupadd dba

[root@ebsdb Softwares]# useradd -g dba oracle
[root@ebsdb Softwares]# passwd oracle
Changing password for user oracle.
New password:
BAD PASSWORD: it is based on a dictionary word
Retype new password:
passwd: all authentication tokens updated successfully.
[root@ebsdb Softwares]#

EBS_APPS:

[root@ebsapps ~]# groupadd dba

[root@ebsapps ~]# useradd -g dba applmgr
[root@ebsapps ~]# passwd applmgr
Changing password for user applmgr.
New password:
BAD PASSWORD: it is based on a dictionary word
Retype new password:
passwd: all authentication tokens updated successfully.
[root@ebsapps ~]#

Create  directory structure across all nodes.

EBS_DB:

[root@ebsdb ~]# mkdir -p /u01/app/oracle
[root@ebsdb ~]# chmod -R 775 /u01/app/oracle/
[root@ebsdb ~]# chown -R oracle:dba /u01/app/oracle

EBS_APPS:

[root@ebsapps ~]# mkdir -p /u01/app/applmgr

[root@ebsapps ~]# chmod -R 775 /u01/app/applmgr/

[root@ebsapps ~]# chown -R applmgr:dba /u01/app/applmgr/

Configure below parameters across all nodes

[root@ebsdb ~]# vi /etc/sysctl.conf

kernel.semmsl 256

kernel.semmns 32000

kernel.semopm 100

kernel.semmni 1421

kernel.shmall 2097152

kernel.shmmax 4294967295

kernel.shmmni 4096

kernel.msgmax 8192

kernel.msgmnb 65535

kernel.msgmni 2878

fs.file-max 6815744

fs.aio-max-nr 1048576

net.ipv4.ip_local_port_range 9000 65500

net.ipv4.tcp_tw_recycle 0

net.core.rmem_default 262144

net.core.rmem_max 4194304

net.core.wmem_default 262144

net.core.wmem_max 1048576

kernel.sem = 256 32000 100 142

wq!

[root@ebsdb ~]# vi /etc/security/limits.conf

*   hard nofile 65536

*   soft nofile 4096

*   hard nproc 16384

*   soft nproc 2047

*   hard stack 16384

*   soft stack 10240

:wq!

Make sure below RPMs installed on both DB node and APPS nodes.

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)

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

Additionally, the following RPMs are required for 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.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

Note: Please click here if you could not find any RPMs in linux distribution media.

Step 3: 

Prepare stage area: Unzip start CD disk.
Go to startCD/Disk1/rapidwiz/bin location and prepare stage by using buildstage.sh

[root@localhost bin]# ./buildStage.sh

                      Build Stage Menu

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

   1.     Create new stage area

   2.     Copy patches to existing stage area

   3.     List files in TechPatches directory

   4.     Exit menu


   Enter your choice [4]:

Enter 1 and press enter

            Rapid Install Platform Menu

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

   1.    Oracle Solaris SPARC (64-bit)

   2.    Linux x86 (64-bit)

   3.    IBM AIX on Power Systems (64-bit)

   4.    HP-UX Itanium

   5.    Exit Menu

   Enter your choice [5]:

Enter 2 and press to continue

Enter staging area location and press enter

Step 4:

Install E-business suite

Set the Display by executing below command.

[root@localhost rapidwiz]# xhost +

access control disabled, clients can connect from any host

Go to startCD/Disk1/rapidwiz and run rapidwiz

[root@localhost rapidwiz]# pwd

/u02/software/1222/startCD/Disk1/rapidwiz

[root@localhost rapidwiz]# ./rapidwiz 

Click on "Next"

Click on "Next"

Click on "Next"

Click "Yes"

Click "Next"

Click "Next". 

Provide database name, hostaname, db user and group names, data files location and click on "Next"

Click "Next"

Click "Next"

Click "Next"

Click "Next"

Provide application server host, username, group and directory locations. Click "Next"

Provide passwords for all users and click "Next"

Click "Next"

Click "Next"

Click "Next"

Click "Yes"

Click "Next"

Click "Finish"

EBS_APPS:

Go to stage location and run rapidwiz

[root@ebsapps rapidwiz]# pwd

/u02/software/1222/startCD/Disk1/rapidwiz

[root@ebsapps rapidwiz]# ./rapidwiz 

Click "Next"

Click "Next"

Uncheck the security updates box and click "Next"

Click "Yes"

Pass database server, SID, port and passwords. Click "Next"

To get rid of this error, copy the configuration file which rapidwiz created while installing Ebiz in database node to application node.

[root@ebsdb bin]# scp /u01/app/oracle/11.2.0/appsutil/conf_PROD.txt root@ebsapps.apps.com:/tmp

The authenticity of host 'ebsapps.apps.com (192.168.1.220)' can't be established.

RSA key fingerprint is 77:89:bf:80:23:2e:d8:e0:67:98:6a:bb:7f:ff:2e:d1.

Are you sure you want to continue connecting (yes/no)? yes

Warning: Permanently added 'ebsapps.apps.com,192.168.1.220' (RSA) to the list of known hosts.

root@ebsapps.apps.com's password: 

conf_PROD.txt                                                                                                                               100%   28KB  27.8KB/s   00:00    

[root@ebsdb bin]# 

Pass the copied configuration file to load the configuration details and click "Next"

Click "Next"

Click "Next"

Click "Yes"

Please click Here to resolve above issue. Below is the screen shot after resolve it.

Click "Next"

Click "Finish"

5. Validate the applications

Connect to database as apps user and find the url to login Ebiz.

Login Ebiz with above url as sysadmin user.

Login Weblogic Admin console to check the status.

Click on severs after login console to check servers status.

Thanks for your patience to view this post...

Reference Document: 

Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1)

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.

Issue: Getting below error when installing R12.2.0 applications

checking URL = http://ebsapps.apps.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://ebsapps.apps.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

Cause:

Oracle http server is not starting up due to missing library.

Solution:

shutdown applications and make below softlink. Then start the applications.

[root@ebsapps ~]# ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

Start the applications and click on "Retry" button.

Thanks for your patience to view this blog....

How to find SID(session ID) of connected session in sqlplus

This document describes how to find SID of connected session in SQLPLUS.

[oracle@server1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sat Aug 4 19:37:58 2018

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL>

SQL> select distinct(sid) "Your Session ID" from v$mystat;

Your Session ID
---------------
           6417

SQL> select sid from v$session where audsid = userenv('sessionid');

       SID

----------

44

SQL> select sid from v$mystat where rownum = 1;

       SID

----------

44

SQL> select sid from v$session where audsid = sys_context('userenv','sessionid');

       SID

----------

44

Thanks for your patience view this post.................