So many Notes, so little time... You might have caught my recent article that touched on scaling up your E-Business Suite Release 11i environment with Real Application Clusters for reporting purposes or to improve your environment's overall performance and fault tolerance. If you're wondering whether this applies to EBS 11.5.10.2 environments running the 11gR1 11.1.0.6 database, the answer is, "Yes."
For details, see:
- Using Oracle 11g Release 1 Real Application Clusters and Automatic Storage Management with Oracle E-Business Suite Release 11i (Metalink Note 455398.1)
This document describes how to migrate Oracle Applications Release 11i (Release 11.5.10) running on a single database instance to an Oracle Real Application Clusters (RAC) environment running Oracle Database 11g Release 1 (11.1.0.6) with Automatic Storage Management (ASM).
RAC & ASM are Not Corequisites
We certify the E-Business Suite with Real Application Clusters with Automatic Storage at the same time, since customers often deploy them together. However, just because we document these two options together doesn't mean that one requires the other. In other words, it's also possible to deploy Real Application Clusters without Automatic Storage Management, and vice versa.
11gR1 Upgrade Feedback Wanted
By the way, I am extremely interested in hearing from any Apps customers moving to the 11g database. If you've been working on an 11gR1 upgrade, I'd be grateful if you could either post a comment or drop me a private email about your experiences so far.
Related Articles
Comments (9)
Hi Steven,
We are planning to upgrade to 10.2.0.4 64-bit RAC running on RHEL 5. Is 10.2.0.4 64-bit on RAC certified with EBS 11.5.10.2?
Thanks,
Sriram
Posted by Sriram | October 13, 2008 5:08 PM
Posted on October 13, 2008 17:08
Steven,
Is 11gRAC certified with R12?
thx,
John
Posted by John Stouffer | October 14, 2008 8:05 AM
Posted on October 14, 2008 08:05
Steven and ATG Folks:
I'm currently running two 11.5.10.2 (ATG_PF.H RUP4) EBS environments on 9.2.0.7 RAC. I need to choose whether to upgrade to 10gR2 (RAC, non-ASM) or 11gR1 (RAC, non-ASM).
Are there any compelling 11g features beneficial to EBS that would make it the obvious choice?
Is it known yet what percent of EBS customers are on 11g RAC and how that's going for them?
My highest priority is stability; I'm not a bleeding edge adrenaline junkie who needs multi-weekend patch fests ;-)
If I were to choose 11g, it also seems I would have to upgrade to 9.2.0.8 before applying ATG RUP 6, which is a bummer if true. Can you please confirm that my research to date is correct?
Thank you all very much in advance for any guidance you can provide.
Regards,
Jerry
(Solaris 10, Veritas Storage Foundation for Oracle RAC 5.1 MP1)
Posted by Jerry Kohler | October 14, 2008 8:23 AM
Posted on October 14, 2008 08:23
John,
Yes. You can see it referenced in the R12 certification announcement linked in the above article, as well as on my new Certification page:
http://blogs.oracle.com/stevenchan/certifications.html
Regards,
Steven
Posted by Steven Chan | October 14, 2008 9:41 AM
Posted on October 14, 2008 09:41
Hi, Jerry,
Our 11g Database certification was only released earlier this year, so there's still only a relatively small number of customers who have upgraded so far. The momentum is building, though. The anecdotal impression that I've been getting about these upgrades is that they're going smoothly so far.
I would consider database options such as Advanced Compression and Real Application Testing to be killer features, myself. If I were debating between 10gR2 and 11gR1, the availability of those 11gR1-only options would be the deciding factor for me. These options have the potential to save a tremendous amount of money.
If stability is your primary priority, then staying with the mature 10gR2 codeline may be the best choice. Many customers take the approach that they wait until Oracle's own EBS instance has been upgraded to a given technology before using it themselves. Our internal instance is still on 10gR2; we're planning an upgrade to 11gR1 sometime next year, due to various internal release cycles and financial reporting deadlines.
As for the prereqs: ATG RUP 6 (5903765) requires 11i.ATG_PF.H (patch 3438354), which requires 8.1.7.4 or higher (Note 284086.1).
Presumably, 9.2.0.7 qualifies for "higher", so in theory, you don't need to upgrade to 9.2.0.8. That said, 9.2.0.7 is getting a little long in the tooth, so I'd recommend 9.2.0.8 to get the latest security and performance bug fixes in that release.
Regards,
Steven
Posted by Steven Chan | October 14, 2008 10:04 AM
Posted on October 14, 2008 10:04
Hi, Sriram,
Almost missed your question -- sorry, wasn't ignoring you.
For the 10.2.0.4 Database with RAC:
E-Business Suite 11i is certified with the Red Hat Linux 64-bit operating system on x86-64 hardware architecture in a split configuration database tier, that is, only the database tier is certified on this platform.
Regards,
Steven
Posted by Steven Chan | October 14, 2008 4:00 PM
Posted on October 14, 2008 16:00
At least for 64-bit database on Solaris 10, there still is a problem with 9.2.0.8 JDBC with 11g. I am told there is a fix internally, but here are some regression tests still pending. So until the fix is released and rehosted to Apps, I would not upgrade11i Apps to 11g. This affect the workflow mailer and serveral OF pages.
Posted by Tianhua Wu | October 15, 2008 3:52 AM
Posted on October 15, 2008 03:52
just an FYI, RDBMS patch 7253531 "ORA-7445 [TTCI2U] FOR SOME APPS FUNCTIONALITY AFTER UPGRADE DATABASE TO 11G " has been released. The Java mailer and "Jserv Uasge" pages are working after applying the patch.
Posted by Tianhua Wu | October 23, 2008 7:53 AM
Posted on October 23, 2008 07:53
Hi, Tianhua,
Thanks for letting us know that these patches worked out for you. I've passed that along to the team that owns them.
Regards,
Steven
Posted by Steven Chan | October 23, 2008 10:53 AM
Posted on October 23, 2008 10:53