How to Install FMW 11.1.1.4.0 Standalone Forms/Reports, AKA How to Get to Never Never Land

Hmmm….seems Fusion MW is Peter Panish – a child that doesn’t want to grow up.

Our team is currently using in production the 11.1.1.2.0 FMW (RH 5) install using the Standalone Forms and Reports 32-bit version. Having encountered memory leaks with this version we are now attempting to migrate to 11.1.1.4 64-bit (RH 5).

The documentation to upgrade from 11.1.1.2 to 11.1.1.4 is full of links that take you from one place to another – I am flying over these docs looking for landmarks to get me to where I want to go – Never Never Land. I expect to have lots of fun with little to no consequences when I get there. But alas the following document is giving me fits! Those nasty pirates have been here first.

11.1.1.5.0 seems to be the only ending point (at this writing it doesn’t look to have a standalone Forms Reports install available for 11.1.1.5.0)…what if you need to stop at a different version along the way. AAGH!

http://download.oracle.com/docs/cd/E23104_01/download_readme_ps3/download_readme_ps3.htm#BA BDBHCJ

Following the above documentation, I assume the way to get to Never Never Land is to start with WebLogic 10.1.3.2, install FMW 11.1.1.2.0, verify installation, upgrade Weblogic to 10.1.3.4, install 11.1.1.4.0 patchset. But these steps lead me elsewhere as shown by the following error on starting the WebLogic Node Manager after four successful (no errors reported) product installations.

WARNING: Uncaught exception in server handlerjavax.net.ssl.SSLHandshakeException: FATAL Alert:HANDSHAKE_FAILURE – The handshake handler was unable to negotiate an acceptable set of security parameters. javax.net.ssl.SSLHandshakeException: FATAL Alert:HANDSHAKE_FAILURE – The handshake handler was unable to negotiate an acceptable set of security parameters. at com.certicom.tls.interfaceimpl.TLSConnectionImpl.fireException(Unknown Source) at com.certicom.tls.interfaceimpl.TLSConnectionImpl.fireAlertSent(Unknown Source) at com.certicom.tls.record.handshake.HandshakeHandler.fireAlert(Unknown Source) at com.certicom.tls.record.handshake.HandshakeHandler.fireAlert(Unknown Source) at com.certicom.tls.record.handshake.HandshakeHandler.handleHandshakeMessage(Unknown Source) at com.certicom.tls.record.handshake.HandshakeHandler.handleVersion2HandshakeMessages(Unknown Source) at com.certicom.tls.record.MessageInterpreter.interpretContent(Unknown Source) at com.certicom.tls.record.MessageInterpreter.decryptMessage(Unknown Source) at com.certicom.tls.record.ReadHandler.processRecord(Unknown Source) at com.certicom.tls.record.ReadHandler.readRecord(Unknown Source) Time to talk to the

Go to the Fairies that live in Pixie Hollow to ask for help (AKA entering a Service Request on MOS).

Tinkerbell comes back with a revised install for the 64-bit Version of 11.1.1.4.0 Standalone Forms/Reports:

Please download the following from http://edelivery.oracle.com

  • Oracle WebLogic Server 11gR1 (10.3.4)
  • Oracle Portal, Forms, Reports and Discoverer 11g (11.1.1.2.0) (4 parts)
  • Oracle Portal, Forms, Reports and Discoverer 11g Patch Set 3 (11.1.1.4.0)

Order of installations

  • 1. Install 64 bit JDK – jdk-6u21-linux-x64-rpm.bin (at this writing)
  • 2. Install WLS 10.3.4
  • 3. Install but do not configure FMW 11.1.1.2
  • 4. Install FMW 11.1.1.4
  • 5. execute config.sh from the OracleHome/bin folder

I ask Tinkerbell why is her list different from the documentation from MOS Note: How to Install Fusion Middleware 11g Forms and Reports Only (Note:854117.1).

She brightly sighs, shrugs her shoulders and winks at me! ================================

JDK Install

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

Since we are using a 64-bit OS, we need the Sun JDK 6 64-bit.

The jdk-6u21-linux-x64-rpm.bin can be downloaded from http://java.sun.com/javase/downloads/widget/jdk6.jsp

Verify the correct version of java is installed.

which java

/usr/java/jdk1.6.0_21/bin/java java -version

In my environment there was a symbolic link for an older version of java 1.4 in /usr/bin/java which I removed. This may not be correct for your system, talk to your system administrator about the best way to install a JDK version for system-wide use.

Also you may run out of OS-level file descriptors if left unset. On Linux I edited /etc/security/limits.conf adding the following entries:

* soft nofile 4096

* hard nofile 4096 # End of file

Again, see your System Administrator especially if you want limit the number of open files by user. The example above allows any logon to have those limits.

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

Install WebLogic 10.1.3.4

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

This is a typical installation, change the directory if desired.

Install WebLogic. Unzip the file and execute

java -Xmx1024m -jar wls1034_generic.jar

Welcome Screen

Choose Middleware Home Directory

Create a new Middleware Home – /aux/oracle/middleware

Register for Security Updates

Hit Next to bypass (this is not a mandatory step)

Choose Install Type

Select Typical

JDK Selection

Select the 1.6.0_21 version (probably already selected)

Choose Product Installation Directories

WebLogic Server – /aux/oracle/middleware/wlserver_10.3

Installation Summary

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

Install Forms Reports 11.1.1.2

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

The important thing is to install the software only at this time.

Install Forms Reports. Unzip the files and execute

cd Disk1

./runInstaller

Specify Inventory Directory

screen Directory: /aux/oracle/oraInventory

Group name: dba (If prompted, run the createCentralInventory.sh as directed.)

Welcome Screen

Select Installation Type Select Install ONLY!..….you will configure using config.sh script later. Doing this method also installs all of the components but the configuration step allows you to choose which ones to configure.

Prerequisite Checks

If you receive an error like Checking for openmotif-2.2.3; not found; failed, Install the missing rpm

Specify Security Updates

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

Upgrade Forms Reports 11.1.1.4

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

Install Forms Reports patchset. Unzip the appropriate file and execute

cd Disk1 ./runInstaller

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

Configure Forms Reports 11.1.1.4

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

Execute config.sh from the $Oracle_Home/bin folder. This is a configuration tool that can be run as a GUI or command-line.

Other documents that were helpful to our team:

  • Upgrading Oracle Middleware 11g; How to Check that the Core Components are Running Successfully? [ID 1086348.1]
  • Location Of Different Forms Configuration Files in Fusion Middleware Forms and Reports 11.1.1.1, 11.1.1.2 and 11.1.1.3 Installations [ID 854124.1]
  • Maintain FMW 1073776.1

Disable IPV6 for WebCache

We disabled IPV6 because webcache wouldn’t start….see the instructions below.

14.5.3 Disabling IPv6 Support for Oracle Web Cache

By default, IPv6 support is enabled for Oracle Web Cache. You can disable it in the

webcache.xml file, which is located in the following directory:

(UNIX) ORACLE_INSTANCE/config/WebCache/webcache_name
(Windows) ORACLE_INSTANCE\config\WebCache\webcache_name

In the file, change the value of the IPV6 element to “NO”. For example:

<IPV6 ENABLED=”NO”/>

change LD_LIBRARY

If the IPV6 element does not exist in the webcache.xml file, you can add the element to the

file. Add it after the MULTIPORT element, as shown in the following example:


<LISTEN IPADDR=”ANY” PORT=”7786″ PORTTYPE=”ADMINISTRATION”/>
<LISTEN IPADDR=”ANY” PORT=”7788″ PORTTYPE=”INVALIDATION”/>
<LISTEN IPADDR=”ANY” PORT=”7787″ PORTTYPE=”STATISTICS”/>
</MULTIPORT>
<IPV6 ENABLED=”NO”/>

Advertisements

About April C Sims

Oracle DBA for over a decade...enough said.
This entry was posted in Uncategorized. Bookmark the permalink.

17 Responses to How to Install FMW 11.1.1.4.0 Standalone Forms/Reports, AKA How to Get to Never Never Land

  1. Pingback: STATEMENT OF DIRECTION

  2. Daniel Brody says:

    Great right up! I agree I spent a month trying to make all this work back in Sept 2010 even with Oracle’s help it was a no go. Noting in your right you have found that they will have a fully functioning standalone version of forms and reports soon? I really hope so we clients that want 64bit forms to improve performance.

    • April C Sims says:

      This version 11.1.1.4 standalone forms/reports does work, it is fully functional in our test environment. There isn’t a 11.1.1.5 version for standalone forms/reports.

      • Dan Brody says:

        I have spent the better part of an hour looking for Forms and Reports 11g (11.1.1.4) can be downloaded from My Oracle Support. The support site which I personally hate takes you in circles and no downloads. It actual tells you to go to e-delivery or OTN downloads. Neither place has the files. If you happen to know where the magic download is please let me know. Much appreciation Daniel

      • April C Sims says:

        I agree, it isn’t found anymore on edelivery.com, otn or MOS. Looks like you are going to have to request a copy by entering a non-technical SR.

  3. What is the main reason to migrate to 64 bit other than the memory leaks? If you had it to do over, would you start with 64 bit? Per my e-mail, we are in the process of deploying a test environment and want the most stable platform.

    With the 64 bit version of JDK 6 on INB server, will 32 bit client browsers (i.e. Firefox and IE) for INB and Self Service Banner still work?

    Thanks in advance. Your article is very informative and valuable for those needing to move to OAS 11g.

    • April C Sims says:

      Yes, I would only go with 64-bit. The main reason was the limit on the amount of memory that a 32-bit software can access at the OS level. We expect the 64-bit to support more INB users than the 32-bit with better performance overall. Self Serve Banner still works great on 32-bit. No problems with 32-bit browsers.

  4. David Gibson says:

    April,
    Love the Peter Pan references in your article. This makes reading your post more palatable for folks like me. Thanks for sharing.

    dave

  5. Dan Brody says:

    Oracle Portal, Forms, Reports and Discoverer 11g Patch Set 3 (11.1.1.4.0) for Microsoft Windows (32-bit) is this patch three really the stand alone? This is what they gave me.
    https://edelivery.oracle.com/EPD/Download/get_form?egroup_aru_number=11493752

    • April C Sims says:

      You will need V18646-01 (there are 4 different parts) which is 11.1.1.2.0 as well as weblogic 10.1.3.4. Install as I indicated in the blog post.
      1. Weblogic 10.1.3.4
      2. FMW 11.1.1.2 (don’t configure)
      3. FMW 11.1.1.4 (patchset that you downloaded)
      4. config.bat (for windows)

  6. Chris Jackson says:

    You can find 11.1.1.4 forms and reports by searching on edelivery for FMW Middleware and Linux x86-64. When you execute the search for it you will see a result for “Oracle Fusion Middleware 11g Media Pack for Linux x86-64 release 11.1.1.5”. You select this media pack to get to the versions of Forms, Reports and Discoverer that it contains.

    Since 11.1.1.4 is a patch set, you need to install Oracle Portal, Forms, Reports and Discoverer 11g (11.1.1.2.0) for Linux x86-64 first and then run the patch upgrade to get to 11.1.1.4 as April states.

    -Chris

  7. Skip says:

    I made it all the way down to the Configuration of Forms 11.1.1.4 (config.bat) and made it to the last step, “click configure”. The Progress bar is at 0% and Elapsed time is 28m so far. The configuration process seems to be stuck.

    Any suggestions? I am running Windows 2008 R2 64bit.

    • April C Sims says:

      Sorry, but I have no experience with installing FMW on Windows. I “hear” that having the correct JAVA_HOME defined can be one issue.

  8. Wonderful goods from you, man. I have bear in mind your stuff previous to and you are just extremely excellent. I really like what you’ve received here, certainly like what you are stating and the best way during which you assert it. You make it enjoyable and you continue to take care of to keep it smart. I can not wait to learn much more from you. This is really a terrific web site.

  9. Hank Classe says:

    Ah, your posting has helped me end the “round and round she goes” game with Oracle. You are right as there is no end in sight with the Oracle doc. Thanks again.

  10. krishnakumar says:

    we are facing REP-501 error while generating reports on 11.1.1.4.0 Version & Could you please tell necessary opatch for 11.1.1.4.0.

    • April C Sims says:

      Type: Code/Readme
      Name: Linux-x86-64__11.1.1.4.0_REP-300 REP-501 AFTER A WHILE OF USING REPORTS SERVER EVEN WITH PATCH 10100777_p13327994.zip
      Date: 1/24/2012
      Path: Linux\11\Linux-x86-64__11.1.1.4.0_REP-300 REP-501 AFTER A WHILE OF USING REPORTS SERVER EVEN WITH PATCH 10100777_p13327994.zip

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s