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”/>
Pingback: STATEMENT OF DIRECTION
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.
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.
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
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.
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.
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.
April,
Love the Peter Pan references in your article. This makes reading your post more palatable for folks like me. Thanks for sharing.
dave
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
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)
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
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.
Sorry, but I have no experience with installing FMW on Windows. I “hear” that having the correct JAVA_HOME defined can be one issue.
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.
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.
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.
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