Corporate E-Learning

We at Armstrong-Smith Consulting are pleased to be able to offer corporate E-Learning for Discoverer.
When you purchase our corporate E-Learning package for Discoverer.

Here is what you get:  Click here for more information

• You will get a site license to use both our Discoverer Administration and Discoverer End User classes for 2 years
• You will get two installation CDs, one containing the 13 Administration and a second containing the 17 End User interactive video modules
• You will get a PDF copy of both of the full Armstrong-Smith Consulting manuals
• You will get a copy of the Armstrong-Smith Consulting database schema along with full instructions for installing onto your database
• You will get the full Armstrong-Smith EUL complete with test workbooks
• You will be authorised to install the training modules onto any number of files servers within your corporation
• You will be licensed to use the material in either course any number of times over the 2 year period
• Your materials will be sent free of shipping and handling to any location in the world

Are there any Caveats or Restrictions?
The only caveats and restriction that we have are:

• You must own the relevant Discoverer licenses from Oracle
• You may not use this material to give training to anyone outside of your company without express permission from ASC
• You may not use this material in a country to which the United States has prohibited export

Click here for more information

Discoverer E-Learning Offer Extended Until Further Notice

Due to the great response we had from folks purchasing our Discoverer E-Learning software for Administrators and End Users we are delighted to let you know that we have extended the offer until further notice. Interested in buying? Click here.

How much does it cost?
We will let you have our E-Learning courses for the following amazing prices:

• Discoverer Administration course only $99.00
• Discoverer End User course only $199.00
• Buy both course for only $249.00

This is the offer of a lifetime and these prices represent a saving of 1000s of dollars over our standard price list.

We know that these courses will be of particular interest to people outside of the USA, or for people on a limited budget who cannot get to one of our fantastic instructor-led sessions in beautiful Tennessee, or for someone like you who would like to get training but your company has cut back on your training budget. Whatever the reason, you cannot afford not to take part in this offer to get a personal copy of one or both of our world-class training.

What will you get?

When you buy our E-Learning training through this offer, you get everything you need to complete your training. Here is what you get:

• You get the 13 Administration or 17 End User interactive video modules
• You get a PDF copy of the full Armstrong-Smith Consulting manual
• You get a copy of the Armstrong-Smith Consulting database schema along with full instructions for installing onto your database
• You get the full Armstrong-Smith EUL complete with test workbooks

How do you buy?

To purchase this training please click here. You will be able to pay either by credit card or via PayPal.

Useful Patch Numbers posting updated

I have today updated my Useful Patch Numbers posting with full details for 10.1.2.3 CP6

Click here for more information

There's Nothing like NULLs for Confusion

Happy New Year everyone. Here is a cautionary note about using NULLs and the 'NULL' string with Discoverer. If you want to select rows containing NULLs you need to use the condition IS NULL. However, this causes a problem if you want to select null values using a parameter because the condition column=:parameter would not return any rows if the parameter was NULL.

Before 10gR2, Discoverer did not handle selecting null values from a parameter so you needed to convert the NULL values into a NULL string and include the the NULL string in the list of values. So for example, if you had a column that contained the values 'YES', 'NO' and NULL you would create a list of values that returned the strings 'YES', 'NO' and 'NULL' then use a condition NVL(column, 'NULL') = :parameter. So when you wanted to select rows where the column contained 'YES' or was NULL, you selected 'YES' and 'NULL' from the list of values and Discoverer generated the condition NVL(column, 'NULL') IN ('YES', 'NULL') returning the correct rows (assuming your column did not actually contain any 'NULL' strings).

So far so good, but this changed with Discoverer Plus 10gR2. In this release Discoverer tried to deal with the NULL value in the list of values. So if you had 'NULL' in the list of values it would create an IS NULL condition. So in the above example you could use the conditioncolumn = :parameter and if you selected 'YES' and 'NULL' from the list of values Discoverer would generate the condition column IN ('YES') OR column IS NULL.

Great, but this release would change the 'NULL' string to NULL anywhere it was entered into a condition. So for example, if you entered the condition column = 'NULL' it would change it to column IS NULL. Also if you had the condition NVL(column, 'NULL') = 'NULL' it would change it to NVL(column,NULL) IS NULL. This would give you unexpected results and to add to the confusion, Discoverer Desktop continues to work as before so the results would be different from the Desktop edition.

However, the confusion is compounded in Discoverer Plus 10gR2 CP6. In this consolidated patchset the functionality changes yet again. Discoverer Plus nolonger converts the condition column='NULL' so Plus now returns the correct results. However it stores the condition internally as column = '''NULL''' and when you open and run the workbook in Discoverer Desktop the condition column = '''NULL''' is used so again you get different results. There are more differences when you create the conditions in Desktop and open the same workbook in Plus.

One would hope that with a product with the longevity of Discoverer the basic functionality of the product would be stable, but NULLs are nothing and nothing changes like 'NULL's.

Is it Friday yet?

Ever had one of those weeks (and yes I know today is Tuesday) when you wish it would not end? Well this week is that week for me. I am energized and delighted that my offer to you concerning E-Learning has been so well received and today the first CDs went out in the post.

Don't know what I'm talking about? Where have you been? From now until the end of the year we're offering you the deal of the year on our Discoverer E-Learning. You can have your own personal copy of our best selling end user training for only $199.

Why wait? You might never see these prices again. Click here now to get more information.

Fifth year anniversary of Armstrong-Smith Consulting and we have an offer for you

Armstrong-Smith Consulting is over 5 years old
It was five years ago, way back in 2004, that Armstrong-Smith Consulting was founded and in that time we have helped over 200 customers with Discoverer training or consulting. We are proud to have attained our five year status and as a means of saying thank you to all of our customers and friends around the world, we are making you an amazing offer on our world-class E-Learning initiative.

As you know we have developed what is arguably the best Discoverer training in the world. Mind you, you don't have to take my word on this, click here to see some of the comments we have received about our training.

We curently offer standard training for both Discoverer administrators (click here for outline) and end users (click here for end user outline).

Our E-Learning initiative was introduced during 2009 and has been very successful. This initiative provides attendees with a full video recording of our courses, with 13 modules in the administration class and 17 modules in the end user class.

If you haven't sampled any of these we have two free demos of our end user training and one free demo of our administrator training available for trial on our website at these locations:

• For the first example end user module (Understanding Discoverer) click here
• For the second example end user module (A First Look at Viewer) click here
• For the administration example module (Creating the Business Area) click here

Thank You Offer
Until further notice we will let you have our E-Learning courses available for the following amazing prices:

• Administration Class - only $99.00
  
  
• End User Class - only $199.00
  
  
• Buy both for only $249.00

This is the offer of the year and these prices represent a saving of 1000s of dollars over our standard price list.

We know that these courses will be of particular interest to people outside of the USA, or for people on a limited budget who cannot get to one of our fantastic instructor-led sessions in beautiful Tennessee, or for someone like you who would like to get training but your company has cut back on your training budget. Whatever the reason, you cannot afford not to take part in this offer to get a personal copy of one or both of our world-class training.

What will you get?
When you buy our E-Learning training through this offer, you get everything you need to complete our training. Here is what you get:

1. You get the 13 Administration or 17 End User interactive video modules
   
   
2. You get a PDF copy of the full Armstrong-Smith Consulting manual
   
   
3. You get a copy of the Armstrong-Smith Consulting database schema along with full instructions for installing onto your database
   
   
4. You get the full Armstrong-Smith EUL complete with test workbooks

Purchase Now
So what are you waiting for? Drop me an email or click here to get more information on make a purchase. The material will be delivered to you by CD in the mail and we ship within a couple of business days of receiving your order.

Release and patch numbers for all Discoverer versions - October 2010

Hello everyone

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 9.0.4.46.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 9.0.2.39. The terminal release was 9.0.2.54.10. Patch 3079459, for Administrator and Desktop, which upgraded the software to 9.0.2.54.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 9.0.2.54.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 9.0.2.53, 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.

Footnotes:
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.

Vista installer available for Discoverer 10g Administrator and Desktop

As many of you have already found out, if you attempt to install the base 10.1.2.0.2 software for Discoverer Administrator or Desktop onto Vista the install will fail. I am pleased to let you know that there is now a patch available on Oracle Support (formerly MetaLink) that will allow the install to go ahead on Vista.

The patch number is 6153263 and obviously it is only available for the Microsoft Windows 32-bit platform.

After you have downloaded the patch make sure you unzip it into a folder where there are no spaces in the path. A folder like this will work fine: c:\downloads\oracle\vista

After you have unzipped the patch you should notice a new folder called Disk1 containing a setup.exe file.

With the new setup you can install onto Vista in one of the two following ways:

Install Method 1:
In command line mode (aka DOS) go into the folder containing the new setup.exe and launch it pointing to the products.xml file of the original install, like this:

setup.exe FROM_LOCATION=c:\downloads\oracle\10gTools\stage\products.xml

Note: if your path contains a space you must enclose the whole file location in double quotes, like this:

setup.exe FROM_LOCATION="c:\downloads\oracle\10g Tools\stage\products.xml"

Install Method 2:

1. Within the Vista UI, use Explorer and navigate into the folder containing the new setup.exe
2. Double-click setup.exe
3. On the Specify File Locations screen, navigate to the products.xml file in the location where you unzipped the original Tools software

Become a follower of my blog

If you would like to receive automatic notification of new postings in my blog why not become a follower?

All you have to do is scroll to the bottom of this page where you will see the Followers section. In there you can click the Follow button to become a follower. The system will take care of the rest.

Adjusting the Plus Font Size

There is a known Java bug that causes a worksheet's results to display in a different font in Plus and Viewer. This posting will explain how, for most instances anyway, to rectify this situation.

If you create a workbook in Plus and then open the same workbook in Viewer you may have noticed that the font size in Viewer is bigger than the one in Plus. This can be very annoying and what I have seen happening with many report writers reduce the font size in Plus to something which is very hard to read like size 9. However, when the same workbook is opened in Viewer this same workbook displays in what looks like size 12.

As I say, this is a known bug and there is a fix. Let me show you with example screenshots from my own system. First of all, here is the output from Plus without the fix:

And here is the same report in Viewer. Notice how the font in Plus is smaller?

Ok, now let's equalize the fonts so that Plus displays in the same size as Viewer. You need to edit the pref.txt in the Oracle home for your middle tier. You will find it at this location:

$ORACLE_HOME\Discoverer\util, which in my case was here: c:\oracle\bihome1\discoverer\util

With me so far? I will continue.

You edit this file and look for the entry called AdjustPlusFontSize (with the first letter of each word capitalized and no spaces between the wrods). The entry in most systems will look like this: AdjustPlusFontSize = "false" with the following additional instructions:

# false - Do not adjust the font size to workaround the java bug, 1 Adjust the font size

The instructions are wrong.

The setting you need to apply to fix this is "true" not 1. By the way, if you have my Oracle Discoverer 10g Handbook, take a look at page 791. It gives the correct entries of false (to not adjust the size) and true (to adjust the size). The entry needs to be in double quotes as shown above.

After you save the pref.txt you will need to apply your preferences by executing applyprefences.sh (if running on Linux or Unix) or running applyprefences.bat (if running on Windows). The applyprefences file can be found in the same folder where pref.txt resides. A sort of one stop shopping.

Having changed and applied your preferences you need to stop and restart the Discoverer middle tier. On my system, after I did this I reran the report and got the following output:

Take a close look at where the report ends when compared to the menu bar above and now go and compare this with the compare the output that I gave earlier in the posting. As you can see, the Plus font has indeed got bigger. In actual fact, it is now displaying the same as it does in Viewer. With this fix done, your report writers can now focus on Plus when creating reports rather than having to reduce the Plus font manually to accommodate Viewer.

Bottom line: the fault is not with Viewer but with Plus not displaying fonts correctly. Oracle have stated that this is due to a Java bug. By the way, the bug, if it actually is a bug and not just an unwanted feature, still resides in the latest Sun Java 1.6 so I advise you to make this change no matter what version of Java you are running.

By the way, unlike some preferences when this one is changed it affects all workbooks not just new ones. What it does is make them display in the correct font in Plus, the same as the way it displays in Viewer. You may have noticed that in Viewer the same workbook seems to take up more space. The reality is that in Viewer the fonts display in the right size whereas in Plus they appear smaller than in other Windows applications such as Word, Excel and so on. This fix makes Discoverer Plus right in tune with other applications.

Values Based Skills and Success Traning Blog

Take a look at Our newest Blog -
We are excited to offer this Values Based Training to help you get the results in your company and your life. We will be giving frequent Webinars many of them will be free of charge and others which will be priced to fit into your training budget.


We will also be traveling around the country giving speeches and presentations to our clients and the public, so I will keep you posted on where we will be.

Our Armstrong-Smith Consulting clients will already be aquinted with our excellent technical training. Expect the same quality and dedication in all of our Values and Skills based training.

Values Based Success Skills

Armstrong-Smith Consulting is proud to announce our newest training initiative. My wife and the President of our company, Darlene Armstrong-Smith, spent a number of years delivering Success Skills training. She gave that up to support me in building our Business Intelligence initiatives. Now she is ready to launch a new division of Armstrong-Smith Consulting with training and coaching for companies and individuals in Values Based Success Skills.

As a means of launching this initiative she is giving a FREE Webinar on Tuesday September 29th. The title of the Webinar is; Do you know why you do what you do? She will be exploring the area of how paradigms are formed and give many useful tools to help you improve the way you think about things for better results. It is time to understand why you act the way you do, think the thoughts you think and get the results you get.

Darlene will open your eyes to the way you think about things and motivate you to make changes that give real results.


Title: Do you know why you do what you do?

Date: Tuesday, September 29, 2009

Time: 8:00 PM - 9:00 PM CDT

After registering (link) you will receive a confirmation email containing information about joining the Webinar.

Please share this information with anyone who you think would enjoy and benefit from this Webinar.

Join my LinkedIn group

For everyone who knows me or my company, Armstrong-Smith Consulting, I have recently started a new LinkedIn group.

Whether you're a client, an OTN forum follower or just interesting in anything to do with business intelligence or Oracle Discoverer come and join my group (link)

Supported Java Versions

From time to time I get asked what versions of Java are supported for Discoverer Plus. You can find this information on MetaLink in note number 465234.1

To help you, as of 16-DEC-2008 the following Java Virtual Machines are supported:

• Oracle JInitiator 1.3.1.18 and higher
• Sun Java Plug-in 1.4.2_06 and higher
• Sun Java Plug-in 1.5.0_2 and higher
• Sun Java Plug-in 1.6.0_4 and higher
• Apple JVM 1.4.2_05 or higher is needed when using Safari on an Apple Mac OS X

Please note that some people experience a slowing down when they upgrade to Sun Java 1.6. I have a posting (link) about this and Oracle has a document on MetaLink (747189.1)

Slow performance when using Sun Java 1.6

Over the past year of so, several of my clients have reported a slowing down of Discoverer Plus 10.1.2 (10.1.2.0.2, 10.1.2.2 and 10.1.2.3) following an upgrade of the Sun Java to version 1.6.0_04 or higher.

This has been recognized by Sun and if you are technically minded you can read more about this bug by clicking here.

From a Discoverer point of view there does not appear to be an issue with these Java versions:

• Sun Java Plug-in 1.4.2_06 and higher
• Sun Java Plug-in 1.5.0_2 and higher

To overcome the issue with Sun Java 1.6 please look at note 747189.1 on Oracle MetaLink.

There is a lot of information in this note but of interest there really are only two ways to overcome the problem and get Discoverer Plus working fast again. These are:

1. Ensure the external facing IP address of the Discoverer server has a reverse DNS entry in the DNS server, or
   
2. Add an entry for the Discoverer server to the local HOSTS file

Ever since I've been using Discoverer I've always tended to have an entry for the Discoverer server in my HOSTS file. So for me I rarely see this issue. On your local PC you will find the HOSTS file here:

• c:\windows\system32\drivers\etc

You can edit it with either Notepad or Wordpad

Maximize your Investment in Discoverer paper

Earlier this year, at the ODTUG 2009 Kaleidoscope conference in Monterey, California, I presented a paper called Maximize your investment in Discoverer.

I have taken the white paper and the PowerPoint presentation and revamped them a little and now have them available for download free of charge from my website (link). They are both contained in a zip file called MazimizeInvestment.zip

Please feel free to download this paper and take a look at the Armstrong-Smith Consulting recommendations for how you can maximize your investment. In a nutshell, because of the introduction of Oracle Business Intelligence Enterprise Edition (OBI EE) you basically have three options:

1. Protect your investment by staying with Discoverer - there will no forced migration away from Discoverer and Oracle will continue providing enhancements and cumulative patches plus support will be covered by Oracle's lifetime policy. Discoverer 11g is due for full release during 2010. Oracle also have a statement of direction stating that Discoverer will continue to be enhanced and supported.
   
   
2. Extend your investment by combining Discoverer with some of the OBI EE tools. One of the notable extensions is to interface Discoverer with BI Publisher
   
   
3. Migrate your investment by converting your Discoverer application into OBI EE. In order to do this effectively you will need to migrate your EUL and migrate your workbooks. Oracle currently have a migration utility for the EUL and hope to have a workbook migration utility available either as part of 11g or as a separate release around the same time.

CP5 for 10.1.2.3 released

Just wanted to let you know that Oracle has just released CP5 for 10.1.2.3. You will find it on MetaLink as patch number 8354043. When compared to CP4, 28 bugs have been fixed.

So far this cumulative patch has been released for the following platforms:

• Micrpsoft Windows 32-bit
• Linux x86 (works for both 32 bit and 64 bit)
• Sun Solaris SPARC (32-bit)

If you are upgrading to CP5 from any patch level other than CP4 then JDBC patch patch p4398431_10105_GENERIC.zip for bug 4398431(release 10.1.0.5) needs to be installed before you apply CP5.

This patch needs to be applied to all Oracle Homes, i.e. Infrastructure home as well as all related midtier homes.

Bug 4398431 - HANG WHEN RETRIEVING A CONNECTION FROM THE IMPLICIT CONNECTION CACHE

The following posting has been updated:

• Useful Patch Numbers
  

CP5 for 10.1.2.3 released

Just wanted to let you know that Oracle has just released CP5 for 10.1.2.3.

More to follow later today.

Getting virtually there with Discoverer

With so many different versions of Discoverer and versions of the database it always difficult to know what tools and patches you need for everything to work together. One way to make this much easier is to use virtual machines to install the software.

The computer I use the most is my laptop running Windows Vista and using the VMWare workstation tool, I have Discoverer Administator, Desktop, Plus and Viewer all working together with the Oracle 11g database on the laptop. I haven't got Discoverer 11g working yet in a VM, but I will try the software in the VM environment before installing elsewhere. You need lots of memory (I have 4Gb) and don't expect stunning performance. But having all the tools installed together is invaluble for testing, evaluation and training.

One thing I really like with this approach is that you can snapshot the VMs at any point in time. Then if you make a mistake, for example, an installation does not work properly, then you can quickly revert the VM back its previous state.

There isn't enough time for a detailed instructions to install all the Discoverer tools but here are the basic steps you need to follow:

1. Download and install VMWare workstation (http://www.vmware.com/download/ws/) which you can get on a one month trial.
2. Download the Oracle Enterprise Linux DVD from the e-delivery site (http://edelivery.oracle.com/linux). Check which releaes you want as OEL release 5 does not work with some versions of Oracle 10gAS.
3. Create a VM of type Red Hat Enterprise Linux. Give the VM the maxium recommended memory. Use a bridged network and specify the hostname and IP address. You can then add the hostname and IP address into the windows hosts file so that you will be able to access Discoverer running in the VM from the windows browser.
4. Install the VM tools which is an addition Linux package supplied with the VM workstation.
5. Add the ip address and hostname in the /etc/hosts file.
6. There are some addition Linux packages (such as gcc and gcc-c++) need to be installed. These are listed in the database and application server installation manuals. All the packages are available in the OEL DVD.
7. Some Linux kernal parameters have to be increased. Details of how to do this are in the 11g database installation guide. For an 10gAS installation you need shmmax = 4294967295 and msgmnb = 65536
8. There are some other pre-installation tasks for the Oracle 11g in the installation manual. These are adding the oracle, dba and oper unix groups and changing the shell limits.
9. Use VM Workstation to create a windows shared drive.
10. Download Oracle 11g database (http://www.oracle.com/technology/software/products/database/index.html), unzip in the shared drive and run the installer to install Oracle 11g in the VM.
11. Download the Discoverer software e.g. Business Intelligence (http://www.oracle.com/technology/software/products/ias/htdocs/101202.html) for Linux CDs. Unzip into the shared drive and run the installer from the Linux command line. Download and install any patches you need.
12. Download the Discoverer tools software for windows (Admin and Desktop) and install on Windows Vista.
13. Create a new tablespace for Discoverer and create an End User Layer. You are now ready to start importing objects into the EUL and creating workbooks.

Another thing I like about this approach is that you can run Discoverer Plus and Viewer in the windows browser connecting to the application server and database in the Linux VM just as you would if the Linux was on a separate server. You can create many different VMs, each with different versions, different software tools etc and switch between them to try out different ideas.

I can post more detailed instructions if anyone is interested.

Oracle releases Discoverer 11g

Hi everyone
The long and eagerly awaited release of Discoverer 11g has just been announced by Oracle and it is available for download right now. This new version of Discoverer is now part of Oracle Fusion Middleware 11g.

Here is a (link) to the software download. Scroll down to the section entitled Portal, Forms, reports and Discoverer and click on the appropriate link(s) for your platform. The download is beigger than you have been used to.

Here is a (link) to the documentation download.

My good friend Abhinav, who runs the Oracle BI Blog and was the techincal editor for the Discoverer 10g Handbook, has more information available (link). Please pay close attention to Abhinav's comments regarding the order for installing the software.

My friend, Mark Rittman, who also runs a blog and wrote the OLAP chapter in the Discoverer 10g Handbook, has further information (link) including some screenshots.

Here are some important notes for you to consider:

• Currently the software is only available for the Microsoft Windows and Unix x86 platforms. The other operating systems as well as the 64-bit versions will be available soon
• The OC4J engine that we have all got used to has been dispensed with and replaced with the WebLogic Server, otherwise known as WLS. Get used to this acronym as it will soon become common place within the Discoverer environment
• From 11g, Discoverer is still available as a stand-alone install but the install is done from a single interface. If you want to use the full-blown install there is now a single install instead of the two as there are with 10g.

I will be making more postings in the coming months as we all come up to speed on the new version.

One thing to note, as far as I know at this stage, is that once up and running the functionality of Discoverer 11g is virtually the same as the later versions of Discoverer 10g. I am not sure which cumulative patch it is equivalent to but as soon as I find out I will let you know.