Oracle-Developer.com

 

Navigation: Home  | Discussion Forums (Get expert advice)  |  Scripts  |  About Us  | Links  | Job Openings  

 

 

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 x86-64 (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

I’m 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 didn’t 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 didn’t feel like hooking up the monitor directly to the server. It worked like a charm once I installed Xming.

I’m 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 post-installation. 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/oracle/VIS/db/tech_st/11.1.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/bin:/stage/startCD/Disk1/rapidwiz/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 Oracle’s 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/compat-oracle/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


 

 

 

Owned and Operated by Varun Jain, Inc, www.varunjaininc.com

Copyright ©2007 Oracle-Developer.com