Installing Oracle R12 EBS in my Living Room

Sep 26, 2008 / By Lukas Vysusil

Tags: ,

I decided to build my first sand box ever. I always wanted one, but there was no time or reason until now. Fortunately, hardware is ridiculously cheap these days compared to the past, so you can actually run full-blown Oracle Applications on your home PC without compromises.

I built a Dual Core box with 8G of RAM for an install of E-Business Suite R12. For OS I chose Oracle EL5U2, mainly because I’m used to the RH/OEL clones, and also because I expected it to be less painful than other distributions.

I started slowly, as time allowed, spending some time chasing various libraries and packages on the Net. Eventually it took me a week to realize how tedious it is to go the manual way. I got so frustrated by the dependencies that I gave up and purchased access to the ULN network.

Just to illustrate the type of struggle I went through, I found four distinct lists of required packages for 10g installation (in Oracle documentation and metalink combined). I’d recommend Note 421308.1 – Requirements For Installing Oracle10gR2 On RHEL/OEL 5 (x86_64), which summarizes the database part in a neat way. I also encourage you not to underestimate requirements of related Note 376183.1 – Defining a “default RPMs” installation of the RHEL OS.

Nevertheless, it’s just way more easy to use the oracle-validated package, which will download all dependencies for you. Well, almost all.

The next step was to prepare the machine. The only tricky part (from the DBA point of view) is to setup a DNS server, but even that went well. There are plenty of nice howtos on the web — search for keyword “rndc”.

Once I had all the required packages installed, users created, kernel parameters set, domain name resolution working, and Xvnc started, it was time to call a wizard.

Using rapidwiz is relatively easy. If you’re familiar with standard EBS terminology, you will have no issues. The only new term is the “instance home”, a good concept that allows you to put all applications logfiles and configuration files into one place. Point this location to where you want to have them.

The decisions rapidwiz will allow you to make are fewer than when installing a standalone database, so there’s not much to say about installation itself.

The first problem came in the final stage of installation — starting the HTTP_server container failed. After checking the logfile I figured out that there was a library missing.

The library name was libdb.so.2, and as I discovered on OTN forums, many more people had encountered this problem before. The library is in package called

compat-db-4.1.25-9.i386.rpm

(Don’t be confused by “i386″ — you need this even for x64EL.)

It wouldn’t install easily because of a conflict with another existing package, but I couldn’t remove that other package because it’s dependent on the oracle-validated package.

A workaround that worked for me (and that you’ll see once more before end of this post) is the following:

$ cat compat-db-4.1.25-9.i386.rpm | rpm2cpio | pax -r

This will unpack the RPM package, and then you can get libdb.so.2 and copy it to /usr/lib. Don’t forget to make the symlink with the correct name.

Okay, now I was able to start apache . . .but unable to access forms. Clicking on a link that was supposed to launch forms just did nothing. Digging in the j2ee log directory (cleverly hidden at $INST_TOP/logs/ora/10.1.3/j2ee/forms/forms_default_group_1/application.log ), I found the error:

08/09/25 20:46:11.875 formsweb: 10.1.3.0.0 Started
08/09/25 20:57:27.501 formsweb: ListenerServlet init()
08/09/25 20:57:28.631 formsweb: Forms session  aborted: runtime process failed during startup with errors /d01/PVISII/tools/10.1.2/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

08/09/25 20:57:28.632 formsweb: Forms session  exception stack trace:
oracle.forms.engine.RunformException: Forms session  failed during startup: no response from runtime process
        at oracle.forms.servlet.RunformProcess.connect(Unknown Source)
        at oracle.forms.servlet.RunformProcess.dataToRunform(Unknown Source)
        at oracle.forms.servlet.RunformSession.dataToRunform(Unknown Source)
        at oracle.forms.servlet.ListenerServlet.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.ServletRequestDispatcher.invoke
(ServletRequestDispatcher.java:702)

Yet another library missing — this time it’s libXm.so.2. After searching the web, I found there seemed to be two packages containing it:

openmotif21-2.1.30-11.0.1.RHEL4.6.i386.rpm

and

gnome-libs-1.4.1.2.90-44.2.x86_64.rpm

At the time of this writing there doesn’t appear to be an EL5 version of openmotif21. The gnome-libs package had a number of other dependencies and I didn’t want to spoil the system with an RHEL4 package, so once again I extracted only the library needed:

$ cat openmotif21-2.1.30-11.0.1.RHEL4.6.i386.rpm | rpm2cpio | pax -r

Then I copied the extracted library to /usr/X11R6/lib/. Once I did this, forms came up and I could finally sleep well! If there’s anything I missed in the install guide which could have prevented these errors please let me know, because I didn’t read it.

9 Responses to “Installing Oracle R12 EBS in my Living Room”

  • Jeffrey says:

    I faced the same errors, good solution!

  • Britt says:

    How did you determine libXm.so.2 was in gnome-libs? I have looked at the files provided by that package a few different ways and am not seeing libXm.so.2 in gnome-libs-1.4.1.2.90-44…

  • Lukas says:

    Hi Britt,

    that’s a good catch. I looked at the file manifests and that library is not in gnome-libs packages. I was trying to recall how I arrived at that conclusion, but no luck.
    Sorry for confusion and thanks for clarification. I guess openmotif21 is the way to go then.

    Cheers,
    Lukas

  • Clifford Moore says:

    I’m having problem with the forms loading on my desktop at home. I can login to app, but forms won’t load. All the services start. I’m on Fedora 11, Firefox 3.5.3., EBS R12

    java -version
    java version “1.6.0_0″
    OpenJDK Runtime Environment (IcedTea6 1.6) (fedora-29.b16.fc11-i386)
    OpenJDK Server VM (build 14.0-b16, mixed mode)

    -

    update-alternatives –config java

    There are 3 programs which provide ‘java’.

    Selection Command
    ———————————————–
    *+ 1 /usr/lib/jvm/jre-1.6.0-openjdk/bin/java
    2 /usr/lib/jvm/jre-1.5.0-gcj/bin/java
    3 /usr/java/jre1.6.0_07/bin/java

    Enter to keep the current selection[+], or type selection number:

    When I look in R12 Java Console it says – Standard Edition 6 Version 6 Update 7 (Build 1.6.0_7-b06).

    I ran yum for libXm.so.2 even though I don’t have error in application log.

    What can I look at to try and find error?

    Cliff

  • Lukas Vysusil says:

    Cliff,
    there are 2 possibilities what can be wrong, either client side or server side.

    Let’s check both, first the client side: In Firefox the java plugin version needs to exactly match the java version used by EBS.

    See this example from my install:

    Client:

    [root@blackbox ~]# cd /usr/lib/mozilla/plugins
    [root@blackbox plugins]# ls -l libjavaplugin_oji.so
    lrwxrwxrwx 1 root root 62 Sep 21 11:05 libjavaplugin_oji.so -> /usr/java/jdk1.5.0_13/jre/plugin/i386/ns7/libjavaplugin_oji.so

    server:
    [applmgr@vm3 ~]$ $AFJVAPRG -version
    java version “1.5.0_13″
    Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_13-b05)
    Java HotSpot(TM) Client VM (build 1.5.0_13-b05, mixed mode, sharing)

    If the problem is not with the firefox java plugin, I’d start by looking at the forms logs in $INST_TOP/logs/ora/10.1.3/j2ee/forms/forms_default_group_1/application.log
    and see if any evidence of problem is there.

    Good luck and let us know if you find anything.

    Lukas

  • Andrew says:

    Hi,

    Thanks for this post and sharing your knowledge. I resolved my problem and it saved me a lot of time.

    Andrew

  • M Ratek says:

    The funny thing is that the problems that you encountered are typical of any Oracle EBS installation being at home on a small PC to even a huge server with the backing of a major corporation.
    Oracle has never improved this. If you think that the initial installation was a pain, just wait to when you have to start installing patches. Ugh!

  • Carlos says:

    Hello, I have a similar problem, when I call the Forms from IE:

    http://195.5.113.93:7777/forms/frmservlet?config=config_form_index

    FRM-92101 – Forms session failed during startup: no reponse from runtime process

    application.log says the same message.

    OC4J~OC4J_BI_Forms~default_island~1 says:
    error while loading shared libraries: libjvm.so: cannot open shared object file: No such file or directory

    rpm -aq openmotif says:
    openmotif-2.3.1-2.el5
    openmotif-2.3.1-2.el5

    All paths where is included the library libjvm.so, are alright.

    Could you help me please?, I don´t now how to follow.

    Thankyou!

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>