Cumulative Patch 4 released for OracleAS Discoverer 10.1.2.55.26

The new cumulative patch for OracleAS Discoverer 10.1.2.55.26 has been just released. You can connect to http://metalink.oracle.com and download it, the id is 7595032.

Opatch is used to install Discoverer Cumulative Patches. The patch readme has all the install/rollback instructions.

I'd like to remind that OracleAS Discoverer 10.1.2.55.26 is a release version obtained by installing the Oracle Application Server PLACEHOLDER patch: 5983622.

Discoverer Plus Generate "java.io.FileNotFoundException:disco5i.jar" after Cumulative Patch 7 (6778560) installation

Discoverer Plus 10.1.2.54.25 generate the following exception in Java Console, and cannot be loaded :

java.io.FileNotFoundException: File not found:
https://servername.domain/discoverer_disco/plus_files/disco5i.jar
at sun.plugin.proto .jdk12.http.HttpURLConnection.getInputStream(Unknown Source)
at oracle.jre.protocol.jar.HttpUtils.followRedirects(Unknown Source)
at oracle.jre.protocol.jar.JarCache$CachedJarLoader.download(Unknown Source)
at oracle.jre.protocol.jar.JarCache$CachedJarLoader.load(Unknown Source)
at oracle.jre.protocol.jar.JarCache.get(Unknown Source)
at oracle.jre.protocol.jar.CachedJarURLConnection.connect(Unknown Source)
at oracle.jre.protocol.jar.CachedJarURLConnection.getJarFile(Unknown Source)
at sun.misc.URLClassPath$JarLoader.getJarFile(Unknown Source)
at sun.misc.URLClassPath$JarLoader.(Unknown Source)
at sun.misc.URLClassPath$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.misc.URLClassPath.getLoader(Unknown Source)
at sun.misc.URLClassPath.getLoader(Unknown Source)
at sun.misc.URLClassPath.getResource(Unknown Source)
at sun.misc.URLClassPath.getResource(Unknown Source)
at sun.applet.AppletPanel.loadJarFiles(Unknown Source)
at sun.plugin.AppletViewer.loadJarFiles(Unknown Source)
at sun.applet.AppletPanel.runLoader(Unknown Source)
at sun.applet.AppletPanel.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
WARNING: Unable to cache
https://appsppesdev.oracleoutsourcing.com/discoverer_disco/plus_files/disco5i.jar
Could not load progress dialog image:
https://appsppesdev.oracleoutsourcing.com/discoverer_disco/plus_files/plugin/images/download.jpg
load: class oracle.disco.DiscoApplet not found.
java.lang.ClassNotFoundException: java.io.IOException: open HTTP connection failed.
at sun.applet.AppletClassLoader.getBytes(Unknown Source)
at sun.applet.AppletClassLoader.access$100(Unknown Source)
at sun.applet.AppletClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.applet.AppletClassLoader.findClass(Unknown Source)
at sun.plugin.security.PluginClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.applet.AppletClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.applet.AppletClassLoader.loadCode(Unknown Source)
at sun.applet.AppletPanel.createApplet(Unknown Source)
at sun.plugin.AppletViewer.createApplet(Unknown Source)
at sun.applet.AppletPanel.runLoader(Unknown Source)
at sun.applet.AppletPanel.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

The error_log files, shows errors like :

[error] [client 140.85.190.243] [ecid: 82133192743,1] File does not exist: $OH/Apache/Apache/htdocs/disco/discoverer_disco/plus_files/disco5i.jar

Changes

The problem appeared after the installation of the Cumulative Patch 7 on a Complex / Load Balanced environment, with BigIP and security rules.

Cause

Due to the

Bug 5948646 NEED TO CHANGE THE CONTEXTROOT FOR DISCOVERER PLUS&VIEWER

the $OH/discoverer/config/disco.conf has been updated from :

# Virtual path for plus jar and related files
AliasMatch ^/disco/plus_files/(..*)
"$OH/discoverer/plus_files/$1"

to :

# Virtual path for plus jar and related files
AliasMatch ^/discoverer_disco/plus_files/(..*)
"$OH/discoverer/plus_files/$1"

Solution

Change the BigIP security rules for the Virtual Path from /disco/ to /discoverer_disco/

Cumulative Patch Certification with Applications

Numbers of questions coming for information about the certification of Cumulative Patches with Applications installation. First of all, it is important to clarify the types of Discoverer solutions to 'Apps certification' :

1. Custom Solution
   - Custom solution is built by customer and is not dependent on any 'Apps certification' ;
   - Custom solution is simply using the Discoverer native functionality to connect to EBS DB.
   
2. (2) BIS Solution
   - BIS is an Oracle pre-built and shipped with EBS solution.
   - This solution comprises of BAs, folders, workbooks, etc.
   - The 'Apps certification' means that BIS Dev team tests all BAs and workbooks with a new Discoverer version against EBS.
   

In any case customers using Discoverer 10.1.2.2 against EBS 11i are still fully supported and all new problems will be handled normally even reported to Development as bugs if needed. Concerning the Cumulative Patches, you can go for any Cum. Patch version higher than Cum.Patch 3 (6155500) (You may want to skip Cum.Patch 5 6472361, which I see is not fully stable).

Cumulative Patch for Oracle Discoverer 10.1.2.2

This will be implemented for iAS 10.1.2.2 (Discoverer 10.1.2.54.25) version going forward. This is only for Plus/Viewer. (D40 patches will also be using this cumulative model)
Discoverer Admin/Desktop 10.1.2.54.25 (part of iDS 10.1.2.2) will continue to use the current patching model. Previous versions, iAS 10.1.2.0.2 / 10.1.2.1 (Discoverer 10.1.2.48.18
or 10.1.2.50.05) will continue to use the current patching model.


First Cumulative Patch (for example, let's call it PATCH1) contains 70 bug fixes over 10.1.2.2. Or in other words, PATCH1 = 10.1.2.2 + 70 bug fixes If second Cumulative Patch (PATCH2) request MLR receives 30 bugs, PATCH2 will end up containing 70 + 30 = 100 bug fixes over 10.1.2.2 or, in other words, PATCH2 = 10.1.2.2 + PATCH1 + 30 bug fixes and so on for PATCH3 ... PATCH3 = 10.1.2.2 + PATCH2 + x bug fixes

Opatch is used to install Discoverer Cumulative Patches. The patch readme has all the install/rollback instructions.


Patch 5943426 - CUMULATIVE PATCH I: (AVAILABLE FOR SOLARIS, LINUX 32BIT, WINDOWS 32BIT, AIX 5L 64BIT)

Patch 6129303 - CUMULATIVE PATCH II: (AVAILABLE FOR SOLARIS, LINUX 32BIT, WINDOWS 32BIT, HPUX 64BIT)

Patch 6155500 - CUMULATIVE PATCH III: (AVAILABLE FOR LINUX/INTEL, SOLARIS-64, WINDOWS/NT, AIX 5L 64BIT, HPUX 64BIT, HP/IA64 (HP UX ITANIUM))

Patch 6357481 - CUMULATIVE PATCH 4 : (AVAILABLE FOR LINUX/INTEL, SOLARIS-32, WINDOWS/XP, AIX 5L 64BIT, HPUX 32BIT, HP/IA64 (HP UX ITANIUM))

Patch 6472361 - CUMULATIVE PATCH 5: (AVAILABLE FOR HP ITANIUM IA64, LINUX 32BIT, WINDOWS 32BIT, SOLARIS 64BIT (23), AIX 5L 64BIT)

Patch 6669003 - CUMULATIVE PATCH 6 : (AVAILABLE FOR WINDOWS, SOLARIS-32, LINUX/INTEL, IBM/AIX-5L, HP-32, HP/IA64 (ITANIUM))

Cumulative Patch 7 - ETA not available

Patch 67xxx60 - CUMULATIVE PATCH 7 : (AVAILABLE FOR LINUX 32BIT, AIX 5L 64BIT, SOLARIS-32, WINDOWS 32BIT)