R12 installation 64 bit on OEL 5 update

5(From Scratch to END)

1. Download R12 64 bit software from
https://edelivery.oracle.com (create your account if you using this site first time).
Select product E-business suite on 64 Bit.
Oracle E-Business Suite Release 12.1.1 Media Pack for Linux x86-64-bit ; download first 39 cd. and
unzip them on the host where you want to perform the installation.
2. Set Up Stage Area Directory
$ cd /u01
$ mkdir StageR12
3. Unzip the Files
$ cd /u01/download
$ unzip -d /u01/StageR12 <ZipFile>
Prerequisites before Starting Installation:a. Make sure these package has been installed manually:
openmotif21-2.1.30-11.EL5.i386
xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386
These two rpm can be download from here:
http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/
For Update 1 or 2:
binutils-2.17.50.0.6-6.0.1.x86_642
For Update 3:
binutils-2.17.50.0.6-9.0.1.x86_642
For Update 4 (5.4) or higher, see workaround listed below in the 'After Installing or Upgrading' section.
The following packages must be installed from the Oracle Linux 5 or RHEL 5 distribution media:
gcc-4.1.2-14.el5.x86_64
gcc-c++-4.1.2-14.el5.x86_64
glibc-2.5-18.i686 (32-bit)
glibc-2.5-18.x86_64
glibc-common-2.5-18.x86_64
glibc-devel-2.5-18.i386 (32-bit)
glibc-devel-2.5-18.x86_64
libgcc-4.1.2-14.el5.i386
libgcc-4.1.2-14.el5.x86_64
libstdc++-devel-4.1.2-14.el5.i386
libstdc++-devel-4.1.2-14.el5.x86_64
libstdc++-4.1.2-14.el5.i386
libstdc++-4.1.2-14.el5.x86_64
make-3.81-1.1.x86_64
gdbm-1.8.0-26.2.1.i386
gdbm-1.8.0-26.2.1.x86_64
libXp-1.0.0-8.1.el5.i386

libXp-1.0.0-8.1.el5.x86_64
libaio-0.3.106-3.2.i386
libaio-0.3.106-3.2.x86_64
libgomp-4.1.2-14.el5.x86_64
sysstat-7.0.0-3.el5.x86_64
util-linux-2.13-0.45.el5.x86_64
compat-libstdc++-296-2.96-138.i386
compat-libstdc++-33-3.2.3-61.i386

b. Kernel Settings
Edit the /etc/sysctl.conf
Parameter Value
kernel.semmsl 256*
kernel.semmns 32000*
kernel.semopm 100*
kernel.semmni 142*
kernel.shmall 2097152
kernel.shmmax Half the size of the physical memory (in bytes), and at least 2147483648
kernel.shmmni 4096
kernel.msgmax 8192
kernel.msgmnb 65535
kernel.msgmni 2878
fs.file-max 65536
net.ipv4.ip_local_port_range 10000 65000**
net.core.rmem_default
262144
net.core.rmem_max 262144
net.core.wmem_default 262144
net.core.wmem_max 262144
c. Verify that the /etc/hosts
There should be information of hostname with IP address.
d. Modifying the Number of Open File Descriptors
Edit /etc/security/limits.conf
* hard nofile 65535
* soft nofile 4096
* hard nproc 16384
* soft nproc 2047
e. OS Library Patch for Oracle HTTP Server (on Oracle Linux 5 and RHEL 5 only)
Download and apply the patch 6078836 from My Oracle Support to fix an issue with the Oracle HTTP
Server (missing libdb.so.2) bundled
Create User & Group:a) Create group dba and user oracle & .
# groupadd dba
#useradd -g dba oracle

b) Create directory

# mkdir -p /d01/oracle
# chown -R oracle:dba /d01/oracle
# chmod -R 775 /d01/oracle
INSTALLATION PROCESS:a. Login as applmgr and change directory to /stage/StageR12/StartCD/Disk1/rapidwiz
b. Run Rapidwiz ...Type './rapidwiz' and press Enter
c. A screen appears which takes you through the installation steps .....Click Next on first 3 screens.
d. Enter the CSI number, Metalink account and country and click Next else Ignore that.
e. Choose create new configuration and Click Next
f. Choose a port pool and Click Next
g. Choose Database type Vision/fresh, Specify a SID,verify host and domain.....
Give the username as applmgr and group as dba and specify the directory as /oraDB and Click Next
h. Select Suite Licensing and Click Next
i. Click Next on the Next 2 screens to accept license products and country specific functionalities.
j. Choose Database character set as UTF8 and click Next
k. Verify the host,domain and specify the base directory as /oraAPP and instance directory as
/oraAPP/inst and Click Next
l. Click Next ...The rapidwiz verifies and validates the system configuration and notifies if there are any
errors...All the checks have to return a GREEN
tick mark if passed. Correct the errors if there are any RED cross marks and restart the rapidwiz.
m. Click Next and then Yes on the next screen to start the installation .
n. Once the installation is finished it performs post installation checks and notifies if there are any errors.
It should return all GREEN marks if successfully installed
o. Click on Finish and that Ends the Installation Steps
Common Error after Installation:a) rw-50015 error - HTTP is not responding

ln -s /usr/lib/libgdbm.so /usr/lib/libdb.so.2
but in my case it just created a broken link.
I had to use this instead:
ln -s /usr/lib/libgdbm.so.2 /usr/lib/libdb.so.2
Restart the Application and database server.
Start rapid installation again with $rapidwiz -restart

Oracle Applications (12.1.1) Installation on OEL 5

In this article; i will try to explain step by step Oracle Application installation R12.1.1 on OEL
5
Reference:
Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86 [ID
761564.1]
Oracle Applications Installation Guide: Using Rapid Install

http://download.oracle.com/docs/cd/B53825_03/current/acrobat/121oaig.pdf
A. Before start installation:
1. The installation of E-Business Suite R12.1.1 needs, secure Linux disabled and the following
package groups installed:

ar
gcc
g++
ld
ksh
make
X Display Server

I strongly suggest , try to install everything while you are making OEL installation. Its little
hard to try install-add some rpms and other tools on OEL.
In this article, i assume that you have been installed everything.
2.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

243 GB for a fresh install with a Vision Demo database.

Application tier file system 35 GB

Database tier file system208 GB (For HP-UX Itanium 210 Gb)
3. Create stage area folder:
You need to setups file for can make Oracle E-Business Suite R12.1 installation. You can use
edelivery.oracle.com site for can download Oracle E-Business Suite the lastest version.
Oracle E-Business Suite R12.1 setup files almost have 50 GB size(with NLS patch)
You can create stage folder by following:
Oracle E-Business Suite R12.1 installation manual Page 1-14 Setting Up the Stage Area
Mainly;

Put all the files under one directory (i.e. /data/R12stage), and extract all the files under the same
directory and give it to 777 permission
For instance:
[root@test]# mkdir /data/R12Stage
[root@test]# chown R 777 /data/R12Stage
[root@test]# cd /data/R12Stage
For Start Here DVD create below:
mkdir startCD
For APPL_TOP DVD create below:
mkdir oraApps
For RDBMS DVD create below:
mkdir oraDB
For Tools DVD create below:
mkdir oraiAS
For Databases DVD create below:
mkdir oraAppDB
Before start to installation, i strongly suggest check below:
MD5 Checksums for R12.1.1 Rapid Install Media [ID 802195.1] note for can observe you
have any problem wiht your stage or not(Corrupted zip etc)
In this article, i assume you have installed everything on you OEL5 installation.
For related requiriments(tools&rmp etc) please follow below:
http://download.oracle.com/docs/cd/B53825_01/current/html/docset.html
Oracle Applications Installation Guide: Using Rapid Install
B. Installation steps preparings:

1. Edit Host file:

The /etc/hosts file must contain a fully qualified name for the server:
<IP-address> <fully-qualified-machine-name> <machine-name>
Example:
[root@test]# more /etc/hosts
127.0.0.1

localhost.localdomain localhost

Open your hosts file wiht editor(I will use vi editor in this article),put your info in this file and
save it. In this article my localhost will be test, my localdomain will be helios.com
PS: If you are using standalone server or pc you can give use any domain name you want.
But if your server or pc on any domain you must use localdomain.
[root@test]# vi /etc/hosts
127.0.0.1

localhost.localdomain localhost

10.100.x.x

test.helios.com test

2. Set Kernel Parameters:

Add following line in end of the /etc/sysctl.conf file.
[root@test]# vi /etc/ sysctl.conf
#R12.1.1 kernel settings
kernel.shmall = 2097152
kernel.shmmax = 4294967295
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 256 32000 100 142
fs.file-max = 327679
net.ipv4.ip_local_port_range = 10000 65000

net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=4194304
#full qualified hostname(format is host.localdomain) << optional
kernel.hostname = test.helios .com << optional
#correct domain name !! << optional
kernel.domainname = helios.com << optional
After this steps you must set your new settings wiht below command:
/sbin/sysctl p
3. Update /var/tmp/.oracle with 777 permissions
chmod 777 /var/tmp/.oracle
4. Edit /etc/security/limits.conf file:
Add the following lines to the /etc/security/limits.conf file:
[root@test]# vi /etc/ security/limits.conf
* hard nofile 65535
* soft nofile 4096
* hard nproc 16384
* soft nproc 2047
5. Edit /etc/resolv.conf file:
Add the following lines to the /etc/resolv.conf file:
options attempts:5
options timeout:15

6. Check /etc/sysconfig/network files format:

Verify that the /etc/sysconfig/network file is formatted as follows:
HOSTNAME=[node_name].[domain_name]
7. If the /etc/sysconfig/networking/profiles/default/network file exists, remove it.
If you changed any files in the previous steps, restart the system.
Be sure you have below rmp on your system:
Oracle Enterprise Linux 5*:
Update 1 (5.1) or higher of Oracle Enterprise Linux (OEL) 5 is required
Update 1 (5.1) or higher of Red Hat Enterprise Linux (RHEL) 5 is required
The following i386 packages are not part of the OS distribution media and must be downloaded
separately (from http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux for both
OEL 5 and RHEL 5) and installed manually:

openmotif21-2.1.30-11.EL5.i3861
xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386
For Update 1 or 2:
2
o binutils-2.17.50.0.6-6.0.1.i386
For Update 3:
2
o binutils-2.17.50.0.6-9.0.1.i386
For Update 4 (5.4) or higher, see workaround listed below in the After Installing or Upgrading
section.

The following i386 packages must be installed from the OEL 5 or RHEL 5 distribution media:

compat-glibc-2.3.4-2.26
gcc-4.1.2-14.el5
gcc-c++-4.1.2-14.el5
glibc-2.5-123
glibc-common-2.5-123
glibc-devel-2.5-12
libgcc-4.1.2-14.el53
libstdc++-devel-4.1.2-14.el5
libstdc++-4.1.2-14.el53
make-3.81-1.13
gdbm-1.8.0-26.2.13
libXp-1.0.0-8.1.el5
libaio-0.3.106-3.23
libgomp-4.1.2-14.el5

sysstat-7.0.0-3.el5
compat-libstdc++-296-2.96-138
compat-libstdc++-33-3.2.3-61

Additionally, the following RPMs are required for an 11gR1 Database (which is bundled with
the 12.1.1 release) on the database tier:

elfutils-libelf-devel-0.125
elfutils-libelf-devel-static-0.125
libaio-devel-0.3.106
unixODBC-2.2.11
unixODBC-devel-2.2.11
kernel-headers-2.6

Note:
1: The openmotif package version must be 2.1.30 (for example, openmotif-2.2.3-10.RHEL4.5 is
not supported).
2: This GNU linker (ld) version 2.17 provided by Oracle is required for relinking the modules in
Advanced Planning & Scheduling (MSC, MSO, MSR)
3: This rpm is distributed as part of the default installation of Enterprise Linux
Oracle Applications Installation and Upgrade Notes for Linux x86-64(64-bit) Release 12
(12.1.1)//

OS Library Patch for Oracle HTTP Server (on OEL 5 and RHEL 5 only)
Download and apply the patch 6078836 from My Oracle Support to fix an issue with the Oracle
HTTP Server (missing libdb.so.2) bundled with the E-Business Suite technology stack.
Note that this patch (which includes a required operating system library) must be applied before
installing Oracle E-Business Suite.
8. Link to Motif library for Oracle Application Server 10.1.2 (on OEL 5 and RHEL 5 only)
Perform the following command (as root on your system) to update a required link to a Motif
library prior to relinking or patching the 10.1.2 Application Server Oracle Home:
# unlink /usr/lib/libXtst.so.6
# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6

Without this updated link, you may see the following errors during a relink of the 10.1.2 Oracle
Home:
/usr/lib/libXtst.so.6: undefined reference to
/usr/lib/libXtst.so.6: undefined reference to
/usr/lib/libXtst.so.6: undefined reference to

`__stack_chk_fail@GLIBC_2.4'
`__fprintf_chk@GLIBC_2.3.4'
`__sprintf_chk@GLIBC_2.3.4'

9. Create user and group for installation:

[root@test]# groupadd dba
[root@test]# useradd g dba d /home/appltest appltest
[root@test]#useradd g dba -d /home /oratest oratest
We will use appltest to can manage Application Tier and we will use oratest for can
manage Database Tier. Our installation folder will be TEST,also our SID will be TEST.
10. Create folder for Oracle E-Business Suite R12.1.1 installation
Firstly, i want to show you my mount point size of server
[root@test]# df h
Filesystem

Size

Used

Avail

Use%

Mounted

/dev/cciss/c0d0p6

355G

55G

300G

6%

/data

As you can see i have 300 GB free space, so i will create my stage folder and my installation
folder on this mount point.
[root@test]# cd /data
[root@test data ]#mkdir TEST
In this article i will make Fresh Installation(Normaly, If i will make DEMO installation, I like to
call installation folder VIS, if i will make fresh installation(TEST or PROD) i like to call
installation folder TEST or PROD)
Give 777 to installation folder
[root@test]# chmod 777 /data/TEST
Option 1:
Create related folder for Application and Database tier(optional)
If we want to put application tier installation folder together(also database tier instalaltion
folder) together we can create 2 subfolders under my main installation folder TEST.
[root@test]# cd /data/TEST

[root@test TEST]# mkdir apps

[root@test TEST]#mkdir db
We must give permisson to our user for can make installation of those folder
[root@test]# chown R appltest:dba /data/TEST/apps
[root@test]# chown R oratest:dba /data/TEST/db
Option two:
Just create TEST folder and give it 777 and use it for installation and application and db tiers
folders will be created under this main folder.
11. I assume that you will not make installation on server room, you will try to make installation
on your local laptop or on your pc. So we need to set our xdisplay settings. If this is your first
time on server you need to start vncviwer services,before start sevices please follow below steps:
Open /root/.vnc/xstartup file with vi and edit it as:
[root@test]# vi /root/.vnc/xstartup
Delete # from below lines
unset SESSION_MANAGER
exec /etc/X11/xinit/xinitrc
[root@test]# service vncserver status <<if it return not running result,than
[root@test]# service vncserver start
Starting VNC server: [ OK ]
If first time you are starting VNCSERVER after your OLE installation, than you need to give
password can connect from your local machine
[root@test]# vncserver
[root@test]# export DISPLAY=test:1.0
[root@test]#xhost+ << it should return below line
Access control disabled, client can connect from any hosts

12. Open your vncviewer from your local machine and follow installation wizard (if you dont
have this program please download it from http://www.realvnc.com)
C. Installation wizard steps:
When you run vncviewer from your local,than you will see installation screens,For can see
screen shoots, Please follow C. Installation wizard steps part on my previous post which is
avaliable here
D. After Installing or Upgrading:
Perform the following steps after installing or upgrading to Release 12.1.1 and before allowing
users to access the system.

Relink Advanced Supply Chain Planning executables (for SLES 10 and

OEL/RHEL 5.4 or higher only)
During the relink phase of the installation of EBS Release 12 (12.1.1) on SLES 10 or
OEL/RHEL 5.4 (Update 4 or higher), failures will result while relinking the Advanced Supply
Chain Planning (ASCP) executables. To fix this problem, users are required to replace the
following line under the Linux section of the $AD_TOP/bin/adrelinknew.sh:
CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh'

with
CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh -Wl,-noinhibit-exec'

After making this change, users are then required to run the adadmin utility and relink
application executables.
Installing Oracle E-Business 12.1.1 on Oracle Enterprise Linux 5.4 64-bit
By V.J. Jain, December 2009 (varun.jain@varunjaininc.com)
Varun Jain, Inc. (an Oracle Consulting Firm)
A portion of this article has been shared on OraFAQ.com
My Background (Are you Technical or Functional, Apps or DB?)
I am an Oracle Database Consultant and an Oracle Applications Consultant. My area of expertise for
most on-site projects that I personally work on is a Functional role for Oracle E-Business Suite (Oracle
Applications) with a focus on Financials and Distribution. However, I work on remote projects that are not
related to the E-Business Suite, such as database design, development, XML DB and ETL, performance
tuning, etc. I have written many database-related articles and even been a co-author of an Oracle 11g
book. As a result, my skill-set ranges from pure database to ERP Functional. Till recently, I had not
developed my skills with system administration or Applications DBA. The goal of this in-house project was

twofold. First, I needed to provide my consultants with a testing environment. Second, I wanted to
expand my knowledge of Apps DBA and Linux.
I want to emphasize that I am not an Applications DBA and I am not a Unix system administrator.
Why I think this is Valuable
As a Functional Consultant, I have the responsibility of translating business requirements from my clients
into solutions. When designing solutions to business requirements, it is important that the person who
architects the solution understands the available components and tiers to the solution. For example, if a
client had a requirement to manage a large amount of XML data, one solution might be (very high level)
to load the data into Oracle. I can think of hundreds of other possible solutions based on many different
criterion. For each business requirement, there are usually many sub-optimal solutions. Ultimately, the
ability to design an optimal solution depends greatly on the awareness of the solution architect. An
increased "awareness" increases the number of potential solutions for any requirement and I think that
without exception, this leads to the optimal solution. Generally, this will save time and money while
outperforming the other potential solutions.
The Adventure Begins
I started by purchasing a brand new enterprise server without an OS. My first goal was to install the latest
release of Oracle Enterprise Linux for the operating system and then to install the latest release of Oracle
Database (11.2). My next goal was to install the latest release of Oracle E-Business Suite for Linux x8664 (12.1.1).
A few months ago I installed Oracle Enterprise Linux (Red Hat Enterprise Linux 5.4) on the brand new
server. This was relatively easy and being comfortable with Unix probably helped. My next step was to
install the latest Oracle Database which was (and still is) 11.2. This step was slightly more difficult as
being "comfortable with Unix" does not translate to "proficiency with Unix". After dealing with a few issues
(dependencies top the list), I successfully installed and configured my 11.2 instance.
In my opinion, the performance of Oracle 11.2 on RHEL5 (OEL) is extremely good. I have instances on
Windows, HP-UX, and Solaris; RHEL is the fastest and most stable. Obviously, my experience is limited
to the features that I use and transactions that I perform.
The Adventure Continues
Im finally getting around to installing Oracle E-Business Suite 12.1.1 on Oracle Enterprise Linux 5.4
(RHEL 5). This is being built on an Oracle 11.2 Database and so far things are going smoothly. I'm kind of
surprised with how smooth the installation has been so far.
The only bump that I ran into was because I didnt have Xming program installed. I was trying to get the
X11 port forwarding (in Putty) to work for the GUI needed for the Oracle Rapid Install since I didnt feel
like hooking up the monitor directly to the server. It worked like a charm once I installed Xming.
Im looking forward to having a fully functional R12 Vision instance in this hardware/OS/database
configuration. From my experience with the 11.2 Database in RHEL5 so far, I have a feeling the
performance will be excellent.
Installation and Post-Installation Challenges
Probably my most obvious challenge is that I am not an Apps DBA and I don't know Linux. With that
said...

Ever since Oracle migrated from Metalink to Oracle Support, my Metalink account has had problems
logging in. I called Oracle Support to get help with it but after holding for 15 minutes, I had to hang up.
Since then, I've avoided calling again and now I really regret not checking the Metalink Notes for the
particular installation that I did. Oracle Apps Release 12.1.1 on Oracle Enterprise Linux 5.4 64-bit has
quite a few issues since it is still a relatively new configuration.
Missing Disks/Files
My first specific challenge was during the installation, the installer kept prompting me for the location of
Disks. Since I downloaded the software from Oracle E-Delivery, this was confusing. Eventually, I realized
that you need to download and extract almost all of the 54 files that are in the Media pack. Originally, I
had only downloaded the first set of files for the rapid installation. I won't make that mistake again.
The files can be downloaded from http://edelivery.oracle.com/
Port Unavailable
After the installation was complete, the post-installation checks occur. My first failure was that the port
was not available. This was because I already installed Oracle 11g a few months ago. The default port
1521 was already in use and consequently, it was not available for the Vision database. I went into my
original Oracle home and changed the listener and the tnsnames to 1522 and resumed the Rapid
Installation.
Environment not Working
I had several issues that were probably related to having a previous Oracle database installation. The
post-installation step for database availability kept failing even after the port was available. I logged into
the server and tried to SQL Plus into the database but the environment was still set for my original DB.
After some digging, I found the Apps generated .env file and used it in my session. I started up the
listener, connected to the idle Vision instance, started up the database and RETRIED the postinstallation. The error in the log said:
riwTDBup.sh started at Thu Dec 3 19:28:14 PST 2009
Parameters passed are : /u01/oracle/VIS/db/tech_st/11.1.0/VIS_localhost.env APPS/APPS
The environment settings are as follows ...
ORACLE_HOME : /u01/oracle/VIS/db/tech_st/11.1.0
ORACLE_SID : VIS
TWO_TASK :
PATH :
/u01/oracle/VIS/db/tech_st/11.1.0/perl/bin:/u01/oracle/VIS/db/tech_st/11.1.0/bin:/usr/bin:/usr/sbin:/u01/ora
cle/VIS/db/tech_st/11.1.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/bin:/stage/startCD/Disk1/rapid
wiz/unzip/Linux_x64:/usr/bin:/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin:/usr/kerberos/bin:/usr/
local/bin:/bin:/usr/bin:/home/oracle/bin:.
LD_LIBRARY_PATH :
/u01/oracle/VIS/db/tech_st/11.1.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/oracle/VIS/db/tech_st/11.1.0/lib:/
usr/dt/lib:/u01/oracle/VIS/db/tech_st/11.1.0/ctx/lib
Executable : /u01/oracle/VIS/db/tech_st/11.1.0/bin/sqlplus
riwTDBup.sh exiting with status 3
RW-50011: Error: - Database ORACLE_HOME connection test has returned an error: 3
command: /stage/startCD/Disk1/rapidwiz/bin/riwTDBup.sh
/u01/oracle/VIS/inst/apps/VIS_localhost/ora/10.1.2/VIS_localhost.env APPS/APPS
I tested this by creating a new session and executing the command

[root@localhost tmp]# /stage/startCD/Disk1/rapidwiz/bin/riwTDBup.sh

/u01/oracle/VIS/inst/apps/VIS_localhost/ora/10.1.2/VIS_localhost.env APPS/APPS
After this exited with status 3, I looked at the file /stage/startCD/Disk1/rapidwiz/bin/riwTDBup.sh and saw
that it sets the environment using the first input VIS_localhost.env. The environment file looked fine so for
some reason the script that was not working correctly; probably some kind of conflict with my previous
Oracle installation. I overcame this by setting the environment in my session, starting the listener, logging
into the VIS database, and starting up the database.

OHS Oracle HTTP Server not Starting

The next failure in the post-installation checks was the HTTP server not starting. The log file showed:
HTTP
----checking URL = http://localhost.localdomain: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
The HTTP log showed:
/u01/oracle/VIS/inst/apps/VIS_localhost/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/u01/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries:
libdb.so.2: cannot open shared object file: No such file or directory
This is an error with libdb.so.2 stating "error while loading shared libraries: libdb.so.2: cannot open shared
object file: No such file or directory". After noticing that many people encounter this issue, I posted the
solution for this available here.
Login Page - RW-50016 Error
The next issue I faced was to do with creating the Login Page. I kept getting:
Login Page
----------checking URL = http://localhost.localdomain:8000/OA_HTML/AppsLogin
RW-50016: Error: - {0} was not created:
File = {1}
instantiate file:
source : /stage/startCD/Disk1/rapidwiz/etc/adxdbctx.tmp
dest : /u01/oracle/VIS/db/tech_st/11.1.0/appsutil/VIS_localhost.xml
I got around this by unlocking the Oracle accounts, running autoconfig, and bouncing the services. I
posted a more detailed guide to fixing this here.
Forms Server Error

Finally, I was able to see the login page and log in as sysadmin. I went to open the Applications by
clicking on one of the forms and I faced yet another problem. When opening the forms I received this
error:
FRM-92101: There was a failure in the Forms Server during startup. This could happen due to invalid
configuration
Please look into the web-server log file for details
Details
Java Exception
oracle.forms.net.ConnectionException:Forms sessionfailed during startup:no response from runtime
process
at oracle.forms.net.ConnectionException.createConnectionException(Unknown Source)
at oracle.forms.net.HTTPNStream.getResponse(Unknown source)
at oracle.forms.net.HTTPNStream.doFlush(Unknown Source)
at oracle.forms.net.HTTPNStream.flush(Unknown Source)
at java.io.DataOutputStream.flush(Unknown source)
..
I looked into the forms server log file which is given below
$LOG_HOME/ora/10.1.3/opmn/forms_default_group_1/formsstd.out
and found the following error
testMode: false
09/04/09 08:12:17 Oracle Containers for J2EE 10g (10.1.3.0.0) initialized
09/04/09 08:14:27 ListenerServlet init()
09/04/09 08:14:28 Forms session aborted: runtime process failed during startup with
errors /u03/oracle/VIS/apps/tech_st/10.1.2/bin/frmweb: error while loading shared libraries:
/usr/X11R6/lib/libXm.so.2: ELF file data encoding not little-endian
This required installing the openmotif package, openmotif21-2.1.30-11.EL5.i3861.rpm, from Oracles
download site http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/
In the web-server log, it showed: error while loading shared libraries: libXm.so.2: cannot open shared
object file: No such file or directory. After some research, I found that I needed to install an additional
package - openmotif21 which can be downloaded from http://oss.oracle.com/projects/compatoracle/files/Enterprise_Linux/
After installing this, the a similar error appeared showing: error while loading shared libraries: libXp.so.6:
cannot open shared object file: No such file or directory.
09/12/04 11:55:22.317 formsweb: Forms session <1> aborted: runtime process failed during startup with
errors /u01/oracle/VIS/apps/tech_st/10.1.2/bin/frmweb: error while loading shared libraries: libXp.so.6:
cannot open shared object file: No such file or directory
Metalink says the following about the libXP package
The i386 version of the libXp package is missing. The Oracle Universal Installer ( OUI ) requires the file
libXp.so.6 and this file is installed with the package libXp in RHEL 5 and OEL 5.
Issue the following to confirm the missing rpm:

% rpm -qa queryformat %{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n | grep libXp

The package libXp was not installed in RHEL 5/OEL 5 with default RPM packages, so it will need to be
installed manually. In RHEL 4 this file was provided by the package xorg-x11-deprecated-libs which is
installed with default package installation but this is not the case for RHEL5/OEL5 and is now provided
with a different rpm, the libXp rpm.
Install the package libXp by the command:
# rpm -ivh </path/to/>libXp.<version>.i386.rpm
Unfortunately, I did not have the DVD in front of me, so I found the RPM on http://rpm.pbone.net
[root@localhost tmp]# rpm -ivh libXp-1.0.0-8.1.el5.i386.rpm nodeps
warning: libXp-1.0.0-8.1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID a7048f8d
Preparing
########################################### [100%]
1:libXp
########################################### [100%]
[root@localhost tmp]# rpm -qa queryformat %{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n |
grep libXp
libXp-1.0.0-8.1.el5 (i386)
Apparently, I needed to install i386 libXp which is included on the RHEL5.4 CD/DVD. I didn't have the
DVD at the time, so I found the RPM online and installed it... and...
Success!
After installing the libXp package, my forms successfully opened and I was able to open and use my R12
Vision instance.
About the author
V.J. Jain is an Oracle Database Consultant and an Oracle Applications Consultant. He is the owner is an
Orange County based Oracle Consulting Firm, Varun Jain, Inc.. When personally performing work on-site,
he works as a Consultant for Oracle E-Business Suite (Oracle Applications) with a focus on Financials
and Distribution. With over 13 years of experience with database systems, he also specializes in
database performance, custom database development, XMLDB/ETL, Oracle interfaces, and high
performance solutions. Additional material by him can be found at http://www.oracle-developer.com. Also,
Connect with V.J. Jain on LinkedIn