From time to time I publish a release guide for Oracle Discoverer. This posting contains the latest information, as of October 26, 2010. I will endeavor to update this every couple of months with the latest information, with a complete new posting every 12 months.Best wishes, Michael
- Discoverer 11g - release 1 of this new version was released during summer 2009. Over the years, many people have tended to stay away from first releases in production but it does depend on the size and scope of your organization or project as well your resources and further needs. Personally, I would err on the side of caution before installing this in a production environment but rather wait either for patch set 1, which I believe is now out, or for 11g release 2 which will be in 2010. Many exciting new features will be added as part of Discoverer 11g R2, including interfacing to many of the OBI EE tools.
Note 1: Discoverer 11g will be the first version of Discoverer to be certified with the Microsoft IE 8 browser.
Note 2: Premier Support for Discoverer 11g is scheduled to end in June 2014, with extended support available until June 2017 followed by indefinite sustaining support. Discoverer 11g is pat of Oracle Fusion Middleware. Click here for more details
- Discoverer 10g (10.1.2.0.2) - Originally known by the code name Drake, this is the current and most up-to-date release and the one you should be on if you can. Notwithstanding the fact that this is the current version it is also an excellent piece of software. It has a much improved user interface when compared to previous versions and is packed with lots of new and exciting features, and can even be interfaced to BI Publisher (part of OBI EE).
This version has two current release levels depending upon which patch you have applied. 10.1.2.54.25 (installed using patch 4960210) is the version number for 10.1.2.2, while 10.1.2.55.26 (installed using patch 5983622) is the version number for 10.1.2.3. Ideally you should be using 10.1.2.3.
As for Microsoft IE certification, 10.1.2.2 is certified for use only with IE6, while 10.1.2.3 is certified for use with both IE6 and IE7.
10.1.2.3 is the recommended version that you should be on with the most recent cumulative patch applied. As of this posting the most recent cumulative patch was CP8 (patch number 9694503) which was released during October 2010. The last cumulative patch for 10.1.2.2 was CP8 (patch number 7111816 for Windows and Sun Solaris x86, path 7306816 for all other platforms). For more information regarding patch levels for 10.1.2 please click here.
Note 1 Oracle have no plans to certify 10.1.2 with IE8. The first version of Discoverer that will be certified with IE8 is the 1st patch set for Discoverer 11g which you should expect to see during 2010. For more information regarding IE8 certification please refer to My Oracle Support (formerly MetaLink) note 843865.1
Note 2: Discoverer 10.1.2.0.2 is covered by Oracle's Lifetime support policy and is included as part of what is now known as Oracle Fusion Middleware. Premier Support for Discoverer 10.1.2.x is scheduled to end in December 2010, with extended support available until December 2011 followed by indefinite sustaning support. Click here for more details
- Discoverer 10g (10.1.2.0.0) - The terminal release is 10.1.2.45.46c. You can upgrade to 10.1.2.48.18 by applying the 10.1.2.1 patchset which will bring you to the 10.1.2.0.2 code level. No ECS or ES dates have been announced for 10.1.2.0.0. Please so not use this release as it is very buggy. You need to upgrade to 10.1.2.3 with the latest cumulative patch.
- Discoverer 10g (9.0.4) - premier support ended as on December 31, 2006, with sustaining support being available only until December 31, 2009. The recommended release is 126.96.36.199.00 and you will need to be on this release before you can migrate to 10.1.2.
Note 1: The upgrade from 9.0.4 to 10.1.2 was a destructive upgrade. This is because, while 9.0.4 and 10.1.2 share a common EUL prefixing system, namely EUL5x, the End User Layers are different. Therefore, if you upgrade from 9.0.4 to 10.1.2 using the same schema be warned that you will not be able to use your 9.0.4 installation after the upgrade. You therefore may want to consider installing 10.1.2 into a separate schema, using Discoverer's export import mechanism to effect the EUL upgrade.
- Discoverer 9i (9.0.2) - Error Correction Support (ECS) ended on July 1, 2005 with Extended Assistance Support (EAS) being available until July 1, 2008. When installed from CD, the release was 188.8.131.52. The terminal release was 184.108.40.206.10. Patch 3079459, for Administrator and Desktop, which upgraded the software to 220.127.116.11.10, was released on August 1, 2003. Various one-off patches to support Administrator and Desktop bug fixes have been released since, with the last being on December 16, 2004.
Patch 3079487 is the one which upgrades Plus and Viewer to 18.104.22.168.10. It was released on August 5, 2003. Oracle continued to release one-off Plus and Viewer patches until desupport with the last one, 4104258, being released on February 18, 2005.
You are urged to upgrade to 10.1.2.0.2 as soon as you can.
Note 1: The upgrade from any version of 9i to 10.1.2 is a destructive upgrade. This is because, while 9i and 10.1.2 share a common EUL prefixing system, namely EUL5x, the End User Layers are different. Therefore, if you upgrade from 9i to 10.1.2 using the same schema be warned that you will not be able to use your 9i installation after the upgrade. You therefore may want to consider installing 10.1.2 into a separate schema, using Discoverer's export import mechanism to effect the EUL upgrade.
Note 2: So long as you are running at least 22.214.171.124, the upgrade from 9i to 9.0.4 is a non-destructive upgrade. This is because the two systems share a common EUL. Therefore, if you upgrade from 9i to 9.0.4 using the same schema you will still be able to use your 9i installation after the upgrade.
Note 3: Discoverer 9i was never certified for use against E-Business Suite.
Note 4: Discoverer 9.0.2 is not covered by Oracle's Lifetime Support policy.
- Discoverer 4.x (with E-Business Suite 11i) - Error Correction Support for Discoverer 4i with the E-Business Suite 11i applications stack ended on October 31, 2006. According to Oracle "since Discoverer 10g (10.1.2.0.2) is fully certified with E-Business Suite 11i, we HIGHLY recommend implementing or migrating to this release". Extended Support (ES) will continue only until October 31, 2009.
The terminal release for use with E-Business Suite was 4.1.48.08. When installed from CD, the release was 4.1.37. It is interesting to note that 4.1.48.08 was issued only as a one-off patch for Administrator and Desktop as 3451630 on February 18, 2004.
This release can be applied on top of any 4.1 release from 4.1.37. However, if applied to any release prior to 4.1.46 it will upgrade the EUL. The 4.1.48.06 patch for Administration and Desktop, 3201601, was released on November 25, 2003 and did an EUL upgrade. Since these major releases, Oracle has continued releasing additional one-off patches, mainly for bug fixes, to support E-Business Suite, with the most recent being 5231872 on June 8, 2006.
Patch 3201610, for 4i Plus and Viewer, was released on November 25, 2003 and upgraded the system to 4.1.48.06. The required E-Business Suite release is 4.1.48.08 which was released on February 18, 2004 and is patch number 3451636. Since then, Oracle has continued to release various one-off patches, with the last one being 3759425 which was released on February 15, 2006.
Note: Discoverer 4.x with E-Business Suite 11i is not covered by Oracle's Lifetime Support policy. See My Oracle Support note 337576.1 for obsolescence details.
- Discoverer 4.x (stand-alone, not as part of E-Business Suite) - desupported from June 30, 2004 with Extended Support (ES) available until June 30, 2007. You should migrate to 10.1.2.0.2 as soon as you can. The final release for 4.x not running against E-Business Suite was 4.1.48.06. See above for patch numbers.
Note 1: The upgrade from 4i to 10g is a non-destructive upgrade. This is because the two systems do not share a common EUL prefixing system. Discoverer 4i uses EUL4x while Discoverer 10g uses EUL5x. Therefore, if you upgrade from 4i to 10g using the same schema you will still be able to use your 4i installation after the upgrade. You may want to consider installing 10g into a separate schema, using Discoverer's export import mechanism to effect the EUL upgrade.
Note 2: Discoverer 4.x (without E-Business Suite) is not covered by Oracle's Lifetime Support policy. See My Oracle Support 231072.1 for obsolescence details.
- Discoverer 3.x - completely desupported. The terminal release was 3.1.46 for Administrator and Desktop, and 3.3.62 for Plus and Viewer. When installed from CD, the release was 3.1.36. Patch 2229365, for Administrator and Desktop was released on January 15, 2002 and upgraded 3.1.36 to 3.1.46. Patch 2240408, for Plus and Viewer, upgraded Discoverer 3i to 3.3.62 and was released on February 25, 2002. A further patch, 2675005, released on 19th November, 2003, upgraded this to the final release of 3.3.62.08.
You should migrate to 10.1.2.0.2 as soon as you can.
Note 1: There is no direct migration path from 3.1 to 10.1.2. This migration must be done via either 4.1.48.06 or 4.1.48.08. However, because 4.1 has been long desupported, from October 31, 2006, you need to do this as soon as you can.
Note 2: Discoverer 3.x is not covered by Oracle's Lifetime Support policy. See MetaLink note 162395.1 for obsolescence details regarding 3.1 Administrator and Desktop, or note 162402.1 for obsolescence details regarding the 3.1.x and 3.3.x Plus versions., note 162405.1 for Viewer.
- Older Discoverer Products such as Discoverer 3.0.8 or Discoverer 2000 - these products are long desupported with EAS for Discoverer 2000 ending on 30th December 2002 (see My Oracle Support note 74821.1 for more details) and EAS for Discoverer 3.0.8 ending on 30th September 2003 (see My Oracle Support note 74129.1 for more details).
You can find a lot of information relating to their desupport notices in MetaLink by clicking on the Certify tab at the top left, followed by clicking on the Desupport Notices link at the far right and then selecting BIT Desupport Notices from the drop-down list.
Footnote 1: Click here for the definitions of Premier Support, Extended Support and Sustaining Support. For products that were deupported before September 2005 you can find more information pertaining to their on My Oracle Support in document number 187553.1
Footnote 2: According to Oracle: A Terminal Release is the latest patch level for a release once Premier Support ends. This release contains all the latest bug fixes produced before error correction support ended. If Extended Support is available, then it is important to be on the Terminal Release version. If a new bug is encountered, one-off patches are created over the latest code-line and are not feasible to backport below the terminal release. To emphasize again, no new patches or backports are accepted by Development once a product is in the Sustaining Support phase of Lifetime Support.
Have you applied any patches to Discoverer that are different to those listed above or have you applied any of the patches listed? Did they fix the problem or not? If you have any additional information, let me know and I will gladly post it here for free to help the community.